How to insert date into a table by selecting form sysdate
498112Mar 13 2006 — edited Mar 13 2006Hi
My Table format is like this
SQL>desc log;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMP_ID VARCHAR2(30)
LOGIN DATE
LOGOUT DATE
now when ever an employee logs in i w'd like to insert date into the table.
i put up the following query
SQL> insert into log(emp_id,login)
2 values
3 ('Ed_01',
4 select
5 sysdate
6 from dual
7 );
select
*
ERROR at line 4:
ORA-00936: missing expression
I got the above error how can i rectify that plz suggest me very urgently as i have to submit my project very early to my boss.