| Oracle PL / SQL » System Packages » dbms_lob |
| 1. | Use dbms_lob.getchunksize to get the clob column size | ||
| 2. | Call dbms_lob.write to write value to clob type value | ||
| 3. | Use dbms_lob.writeappend to append value to clob type value | ||
| 4. | Use dbms_lob.compare to compare | ||
| 5. | Use dbms_lob.compare to compare clob type value with offset | ||
| 6. | Use dbms_lob for load clob data from file | ||
| 7. | This block demonstrates the use of DBMS_LOB.COPY. | ||
| 8. | This block demonstrates DBMS_LOB.GETLENGTH. | ||
| 9. | DBMS_LOB.SUBSTR: Select the first 50 characters of clob_col, and the first 25 bytes of blob_col, for each row. |