|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
February 12th, 2003, 03:26 PM
|
|||
|
|||
|
Need Script to do an INSERT
In an Oravle 8.1.5 db
Need to enter a record count from table A and current date/time into an audit table B My attempt: insert into TABLE_b (usercount,date_counted) values (SELECT COUNT(*) FROM TABLE_a, sysdate); Looks like I need something else. Any help would be apprechiated, Mike
|
|
#2
February 18th, 2003, 05:52 AM
|
|||
|
|||
|
RE: Need Script to do an INSERT
It has been awhile since I used ORACLE but I believe the code you need is this:
Code:
INSERT INTO table_b (usercount, date_counted) SELECT count(*), sysdate FROM table_a; I see you are from OP, KS. Heard of Step 1?
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Need Script to do an INSERT |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
