How to handle Long data type in insert statements?
there are many restrictions on long data type in oracle. u cannot use a long data type in insert statements where you select the data from some other table. For example :- (insert into table emp) (selct * from emp_temp)…In this case u cannot have a long data type in ur select statement. Also u cannot create a new table by using create table temp1 as select * from temp2. Sloution to this is make a copy of table which has long data type using the copy command. You can also copy tables from one database to another database.