Skip to main content

Insert some records selected from another table plus some other data in to a new table

Eg:
Select a,b,c from test;
insert into test_bak values (a,b,c,'ttt','123');
This 'ttt' and '123' should be repeated across selected rows.

Insert statement:

insert into test_bak
select a, b, c, 'ttt', '123'
from test;

Comments

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID