Re: Inserting data with Select

This should work :

insert into signout (signature, software, sigout_date) select ('LR', 'visio', sysdate) from ...

Achille Carette
Bluegate Group
http://www.bluegate.be

L.Ray <lray_at_nospam.bigfoot.com> wrote in message news:3a39a795.174070890_at_news.easynews.com...
> 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:46:58 CST