Operating on LOBs

Operating on LOBs

• LOBs can be operated on from OCI as well as PL/SQL (DBMS_LOB package)
• Functions and procedures to examine LOB data
  • COMPARE
  • INSTR
  • LENGTH
  • READ
  • SUBSTR
• Functions and procedures to change LOB data
  • APPEND
  • COPY
  • ERASE
  • TRIM
  • WRITE

Previous slide

Next slide

Back to the first slide

View Graphic Version