2 Replies Latest reply on Sep 26, 2019 3:19 AM by 4094196

    Syntax error

    4094196

      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