Error ORA-00905 when creating table

Question

Error ORA-00905 when creating table

Navigation

#1 by (2 votes)

0

I'm starting to model a database. I started with a table first (later I could add more elements) but when entering the code to SQL Developer, this error appears:

Informe de error -
ORA-00905: missing keyword
00905. 00000 -  "missing keyword"
*Cause:
*Action:

The table has this code:

CREATE TABLE MULTI_TBL_TD (
    idTd DOUBLE NOT NULL,
    nomTienda VARCHAR(200) NOT NULL,
    modTienda LONGVARCHAR NOT NULL,
    stkTienda LONGVARCHAR NOT NULL,
    CONSTRAINT MULTI_TBL_TD_PK PRIMARY KEY (idTd)
)

The SQL developer software tells me that the error "starts at line: 2 of the command:".
What could I be doing wrong?

sql oracle

asked by virtual8870 03.01.2018 в 20:00

source

1 answer

Error: Repository not found, Please make sure you have the correct accesses? How to enable a cell of a datagridview?

score 2 · Accepted Answer

The problem is simply that you are using types that do not exist in Oracle.

In this case, the error is by type DOUBLE . I assume that the intention in this case is to use BINARY_DOUBLE .

But once you fix that problem, you will see that the next error will be with the type LONGVARCHAR , ~~that frankly, nor can I suggest an alternative, because I do not understand what is your intention.~~ Searching A bit, it seems that maybe you're referring to the% LONG VARCHAR in the database Derby , which is basically a VARCHAR without a maximum limit. If applicable, the appropriate equivalent in Oracle would be CLOB .

Be sure to limit yourself to the types listed here: Oracle Built-In Data Types .