create table testLong ( empno number, history long )
create table testLong1 ( empno number, history varchar2(100) )
how to put data in testLong.history (which is of datatype long) to testLong1.history (which is of datatype varchar2).
~ Pratibha Malhotra<br /> <br />Sun Certified Java Programmer<br />SCEA 1.4 (In Progress)<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />"Many of life's failures are people who did not realize how close they were to success when they gave up!!"
Don't get me started about those stupid light bulbs.