Thursday, 20 March 2014

CONVERT LONG RAW COLUMN TO BLOB COLUMN

You just need to create new table with TO_LOB () function as flollows:-

CREATE TABLE EMP2(EMPNO,PIC) AS
SELECT EMPNO,TO_LOB(PIC) PIC FROM EMP1;


That's it :-)