Hi guys, I just started with a self-taught sql course where I find my first command line, I would like to know if you can help me find the errors please.
this is the syntax
CREATE TABLE CLIENTES
(
CD_CLIENTE VARCHAR2(10) NOT NULL,
ST_NOMBRE VARCHAR2(30) NULL,
TX_DIRECCION VARCHAR2(200) NULL,
ST_STATUS CHAR(1) NULL CONSTRAINT CONSTRAINT001 CHECK (ST_STATUS IN (`S`,`N`)),
NU_NUMERO1 NUMBER NULL,
NU_NUMERO2 NUMBER NULL,
FH_FECHA DATE NULL
);
When execute this sintax show the next error
Informe de error -
ORA-00911: invalid character
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:
i`m working with sql developer version18.2 and Oracle database express 11g all in 32 bits
Thank for your help