This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table in one schema and insert it into the same table
in another schema. However, I am not 100% certain that the tables exist in both
schemas or that the columns are the same.
The columns can be
Title: RE: Need help with a dynamic query
Since the target schema is the one whose columns matter most, I would think that you should do an outer join to the columns in the original schema, to see if any not null columns in the target schema are missing from the original schema
SELECT
'CREATE TABLE TMP_'||table_name||' TABLESPACE tables AS '||chr(10)||
'SELECT * FROM '||table_name||';'
from sys.all_tables where owner = 'yourowner';
Or add a @dblink
bob
This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table