SQL Oracle is too long



  • I also know about the size of the identifier in 30 bayts, and the fact that the kyril weighs 2 bayta, but there are no 15 symbols in my table.

    CREATE TABLE insurance_type(
    "ID_Видстрах"  NUMBER(2, 0)        NOT NULL,
    "Вид страх"    VARCHAR2(8) UNIQUE  NOT NULL,
    "Наим риска" VARCHAR2(32) UNIQUE NOT NULL,
    constraint ВИД_СТРАХ_PK PRIMARY KEY ("ID_Видстрах"));
    

    [42000][972] ORA-00972: too long identifier

    Such a mistake is made in many tables where there are no longer than 15 symbols with the use of Cyrillians. Tell me what to do.



  • All identifiers with longer than 30 English symbols, as well as any non-English letters, shall be double quotes.

    You have the key name. ВИД_СТРАХ_PK No skirts.

    With sistaxy, the table below was created under Oracle 11.

    CREATE TABLE insurance_type(
    "ID_Видстрах"  NUMBER(2, 0)        NOT NULL,
    "Вид страх"    VARCHAR2(8) UNIQUE  NOT NULL,
    "Наим риска" VARCHAR2(32) UNIQUE NOT NULL,
    constraint "ВИД_СТРАХ_PK" PRIMARY KEY ("ID_Видстрах"));
    

    Equitablely described English alphabet is default. According to documentation under certain conditions, even Russian identifiers may be without quarries.

    Non 'ed identifiers must begin with an alphabetic character from your database character set. Quoted identifiers can begin with any character

    Details https://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm#SQLRF51109 ♪




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2