|
-
Hi "guys",
I created a table and I think I did everything correct but I am getting an error that does not sound good to me.
create table customer_info(
cust_id char(3) NOT NULL,
cust_add char(12) NOT NULL,
acct_no char(35) NOT NULL,
acct_password varchar(2)8 NOT NULL)
storage(initial 5242880
next 5242880
minextents 1
maxextents 500
pctincrease 0)
tablespace tablespace_name
SQL>
acct_password varchar(2)8 NOT NULL)
*
ERROR at line 5:
ORA-00907: missing right parenthesis
But line five looks good to me
Can anybody point where I went wrong?
thanks,
learn
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|