Home » RDBMS Server » Server Administration » oracle script
oracle script [message #375122] Fri, 27 July 2001 23:36 Go to next message
GJ
Messages: 3
Registered: July 2001
Junior Member
I am new to oracle and was wondering if you could help me with a simple script..I need to populate one table with another tables data...I know what I
have to do but do not know the oracle commands to do the job..

I basically need to open my source table and step through it row by row and assign my target table with the selected fields until I reach the end of my
source table...I would also need to populate one field in the target table with the current system date..

Any suggestions you could offer including a command reference book would be appreciated...

Thanks,

Gregg

Report message to a moderator

Re: oracle script [message #375123 is a reply to message #375122] Sat, 28 July 2001 00:48 Go to previous messageGo to next message
S.Muthu Kumar
Messages: 6
Registered: July 2001
Junior Member
Hi Gregg,
All u need to do is
Insert into TABLE_NAME1(col1, col2, col3)
Select col1, col2, SYSDATE from TABLE_NAME2;

HTH
S.Muthu Kumar

Report message to a moderator

Re: oracle script [message #375124 is a reply to message #375122] Sat, 28 July 2001 00:48 Go to previous message
S.Muthu Kumar
Messages: 6
Registered: July 2001
Junior Member
Hi Gregg,
All u need to do is
Insert into TABLE_NAME1(col1, col2, col3)
Select col1, col2, SYSDATE from TABLE_NAME2;

HTH
S.Muthu Kumar

Report message to a moderator

Previous Topic: oracle script
Next Topic: Oracle Net8 Packets?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 07:06:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.