SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why I am getting: missing right parenthesis when create table with nvarchar2 data type

a5ca6032-e3b7-49b0-a672-cf5a89321679Mar 29 2016 — edited Mar 29 2016

CREATE TABLE VISIONSTG.ZOLFA1_STG

(

ZCHPARENT VARCHAR2(10 BYTE),

ID_NAME1 VARCHAR2(40 BYTE),

ID_NAME4 VARCHAR2(40 BYTE),

ZCHVATREG VARCHAR2(20 BYTE),

ZCHVAT VARCHAR2(1 BYTE),

CREA_DATE DATE,

POSTCD_BOX VARCHAR2(10 BYTE),

SORTL VARCHAR2(10 BYTE),

ADDR_NUMBR VARCHAR2(10 BYTE),

ZCHTELNO2 VARCHAR2(16 BYTE),

COUNTRY VARCHAR2(3 BYTE),

ZCHPURBLK VARCHAR2(1 BYTE),

ZCHPOSBLK VARCHAR2(1 BYTE),

ADDRESS NVARCHAR2(35 byte),

PHONE_NUMBER VARCHAR2(16 BYTE),

EMAIL VARCHAR2(60 BYTE),

LOAD_DATE DATE

)

but after I remove the "byte" which is ADDRESS NVARCHAR2(35) , then it works i dont know why

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2016

Added on Mar 29 2016

3 comments

1,536 views