About
Oracle dbms_lob
Oracle provides the
DBMS_LOB package which is used to access and
manipulate LOB values in both internal or
external storage locations.
dbms_lob Routines That Can Modify
BLOB, CLOB, And NCLOB Values 
Routines That Read Or
Examine LOB Values in dbms_lob 
dbms_lob Read-Only Routines Specific
To Bfiles 
dbms_lob Datatypes
Parameters for the DBMS_LOB
routines use the datatypes: 
dbms_lob
examples
The following SQL statements show the rule
conditions for the above mentioned rules:
SELECT
dbms_lob.substr(rule_condition,dbms_lob.getlength(rule_condition),1)
rule_condition FROM dba_rules where
rule_name = 'NY270'
/
RULE_CONDITION
--------------------------------------------------|
((:dml.get_object_owner () = 'NY2') and
:dml.is_nul
l_tag() = 'Y' and
:dml.get_source_database_name ()
= 'DNYTST10.WORLD' )
SELECT
dbms_lob.substr(rule_condition,dbms_lob.getlength(rule_condition),1)
rule_condition
FROM dba_rules where rule_name = 'NY271'
/
GRAPHICS_DBA
BEGIN dbms_lob.read (:1, :2, :3, :4);
END;2121 1 0 10251 488
See these related
notes on Oracle dbms_lob
|
|
