HIII, I heard to migrate data one db to another db where table structure and their datatypes are different.we can do by using stored procedure with cursor.
Ex---scott.abc table id char(10)
My olddb name A
my newdb Name B
xyz.bc table eid char(20)
Now migration of data from abc to bc table by using procedure and cursor.
IS it possible?
If yes any one can write procedure for above table.