Hello,
Something like: insert into test select t.*,'val1' as col1,'val2' as col5 from test t where col2='1';
But this doesnt works. ORA-00913: too many values
The selects result give something like: SQL> select t.*,'val1' as col1,'val2' as col5 from test t where col2='1';
col1 col2 col3 col4 col5 col1 col5 ----- ----- ----- ----- ----- ---- ---- 1 1 1 1 1 val1 val2
col1,col5 columns are duplicated.
There is any way to remove column(s) from '*', if it exists after without hardcoding all columns names?
Or maybe other solution?
Thanks.
-- Veres Lajos vlajos@xxxxxxxxxxxxxx +36 20 438 5909 -- //www.freelists.org/webpage/oracle-l