Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Inserting data with Select
I need to insert 2 values and the current date into a table. I can't figure out the correct syntax. I need to do something like:
insert into signout (signature, software, signout_date) values ('LR', 'visio', select SysDate from dual)
which, of course, doesn't work. Any advice on how to do this would be greatly appreciated. Received on Wed Dec 13 2000 - 10:43:24 CST
![]() |
![]() |