Re: Duplicating records with some columns changing..
From: EdwardP <member_at_dbforums.com>
Date: 10 Jan 2002 16:13:23 -0500
Message-ID: <3c3e03f3$3_at_usenetgateway.com>
Date: 10 Jan 2002 16:13:23 -0500
Message-ID: <3c3e03f3$3_at_usenetgateway.com>
Hi,
Have Oracle data dictionary "write" column names for you:
select 'insert into YOUR_TABLE_NAME' from dual union all select 'select ' from dual union all select column_name || ',' from user_tab_columns where table_name='YOUR_TABLE_NAME' union all select 'from YOUR_TABLE_NAME;' from dual
Remove ',' before 'from...'; Change columns that you want to provide other values for; And add your WHERE clause...
-Edward
--
Posted via dBforums
http://dbforums.com
Received on Thu Jan 10 2002 - 22:13:23 CET