October 24th, 2003, 06:55 AM
hi i m trying to dump data from table A to table B in different schema but same instance. now table A has column that has different data values then table B. for example
TABLE A. identification_no varachar(5)
TABLE B .reference_id varchar(15)
can someone help me with the script here they are pretty big tables.
October 24th, 2003, 11:02 AM
I think we spoke about this issue in http://forums.devshed.com/t92585/s.html.
Maybe what was posted there looks too simplistic but that's the power of a fourth generation language like SQL: You specify only what has to be done without being concerned about the underlying details.