Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to insert long data type column

886282Dec 4 2014 — edited Dec 4 2014

HI Experts,

I have given a task to insert backup data to one of the table having long datatype.

For example :

Table_A (

idseq number,

long_value long

);

BKP_Table_A

(

idseq number,

long_value long

);

Want something like this

insert into BKP_Table_A (idseq,long_value)

select idseq,long_value from Table_A;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2015
Added on Dec 4 2014
9 comments
2,301 views