A
A
Artem [email protected]2018-06-30 20:46:25
Oracle
Artem [email protected], 2018-06-30 20:46:25

Where is the error when creating the table?

I'm trying to create a table in a database in Oracle, but an error occurs.
I use the import cx_Oracle module

queryCreate = """CREATE TABLE ST2018 (
                          ID_SCH VARCHAR2(25 BYTE),
                          DR DATE,
                          FAM VARCHAR2(40 BYTE),
                          IM VARCHAR2(40 BYTE),
                          OT VARCHAR2(40 BYTE),
                          GLP VARCHAR2(6 BYTE),
                          )
                          TABLESPACE SYSTEM
                          STORAGE (INITIAL 64 K
                                 MAXEXTENTS UNLIMITED)
                          LOGGING;
                          CREATE UNIQUE INDEX UK_ST2018 ON ST2018  (ID_SCH, GLP)
                          """
dbcur.execute(queryCreate)
db.commit()

error: ORA-00911: invalid character
I can't figure out which character is wrong, where exactly I wrote it wrong; and the same code works without errors in Oracle through a query.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman, 2018-06-30
@file2

Semicolon

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question