Database Administration (MOSC)

MOSC Banner

Sql parse error oracle 19c

Bonjour,

j'ai cette erreur pour oracle 19c

PARSE ERROR: ospid=13828698, error=12872 for statement:
SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE12c_QUERY*/
       C.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER,
       C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE,
       C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT,
    ( SELECT CMT.COMMENTS FROM SYS.ALL_COL_COMMENTS CMT
      WHERE C.OWNER = CMT.OWNER
        AND C.TABLE_NAME = CMT.TABLE_NAME
        AND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS
    , decode(C.CHAR_USED, 'B', 'BYTE', 'C', 'CHAR', null)
    , C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, C.IDENTITY_COLUMN, C.DEFAULT_ON_NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center