Re: Inserting data with Select

insert into signout
(signature
,software
,signout_date

) values
('LR'
,'visio'
,trunc(sysdate)

)
/

"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.
>