OraFAQ Forum: SQL & PL/SQL » setting default values.

Home » SQL & PL/SQL » SQL & PL/SQL » setting default values.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

setting default values. [message #1811]

Fri, 31 May 2002 12:50

ckr
Messages: 13
Registered: May 2002

Junior Member

hi,

i just want to know how to set default value for a column.

i used the query

SQL> create table orders1
2 (
3 order_num integer not null,
4 order_date date not null default sysdate,
5 cust_id varchar2(10) not null
6 );

the answer is

order_date date not null default sysdate,
*
ERROR at line 4:
ORA-00907: missing right parenthesis

can any body tell what is wrong with this query?and how to set default values.

thanku.

Report message to a moderator

Re: setting default values. [message #1813 is a reply to message #1811]

Fri, 31 May 2002 13:02

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Just switch the order of the keywords:

order_date date default sysdate not null

Report message to a moderator

Previous Topic:	Which SQL statement is correct?
Next Topic:	Package ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:54:10 CDT 2024