Hello Shantha
By using the UTL_RAW Oracle built-in package, available with Oracle PL/SQL 8 or higher.
Example:
drop table test_blob
Table dropped
drop table test_clob
Table dropped
CREATE TABLE test_blob (c1 NUMBER,
c2 BLOB)
Table created
CREATE TABLE test_clob...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.