Re: Inserting data with Select

You can use
insert into signout (signature, software, signout_date) values ('LR', 'visio', SysDate);

or

insert into signout (signature, software, signout_date)  (select 'LR', 'visio', SysDate from dual);

the former one is better.

--
Have a nice day
Michel


L.Ray <lray_at_nospam.bigfoot.com> a écrit dans le message : 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.

>