|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
|
|
|
|
|