怎么用一条sql,将一张表中数据插入到两张表中

2024-10-30 06:11:18
推荐回答(1个)
回答1:

oracle 9i 及以上 可以用insert all insert all into t_table1 (tid, tname) values (object_id, object_name) into t_table2 (tid, tname) values (object_id, object_name) select object_id, object_name, object_type from dba_objects where wner = 'TEST';