CODEWITHSUNDEEP
sqloracle-sqldeveloper
A THOUSAND HOURS
A THOUSAND HOURS

Reputation: 25

How do I do create a table on SQL Developer by running a script on the SQL Worksheet?

enter code hereI'm trying to create a table by running an Script from the SQL Worksheet and ORA-00904 error appears.

I don't know maybe the script it's misspelled?

CREATE table IMAGEN (
[ID_ADM] [SMALLINT] NOT NULL ,
[ID_USUARIO] [varchar] (20)  NOT NULL ,
[IMAGEN] [varbinary] (max),
[MINIATURA] [varbinary] (max),
[IMAGEN_ALT1] [varbinary] (max),
[IMAGEN_ALT2] [varbinary] (max),
[IMAGEN_ALT3] [varbinary] (max),
[ESTADO_REG] [varchar] (1)  NULL ,
[FEC_ESTADO_REG] [datetime] NULL ,
[FEC_ING_REG] [datetime] NULL ,
[ID_USUARIO_ING_REG] [varchar] (20)  NULL ,
[FEC_ULT_MODIF_REG] [datetime] NULL ,
[ID_USUARIO_ULT_MODIF_REG] [varchar] (20)  NULL ,
[ID_FUNCION_ULT_MODIF_REG] [varchar] (16)  NULL 
) ON [PRIMARY]
GO

Upvotes: 1

Views: 716

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22467

Here's one interpretation of this table in Oracle

create table IMAGEN (
       ID_ADM                    smallint not null
       , ID_USUARIO                varchar2(20) not null
       , IMAGEN                    blob
       , MINIATURA                 blob
       , IMAGEN_ALT1               blob
       , IMAGEN_ALT2               blob
       , IMAGEN_ALT3               blob
       , ESTADO_REG                varchar2(1) null
       , FEC_ESTADO_REG            date null
       , FEC_ING_REG               date null
       , ID_USUARIO_ING_REG        varchar2(20) null
       , FEC_ULT_MODIF_REG         date null
       , ID_USUARIO_ULT_MODIF_REG  varchar2(20) null
       , ID_FUNCION_ULT_MODIF_REG  varchar2(16) null
);

varchar2, never varchar in Oracle

date = datetime

blobs can store any amount of binary data

enter image description here

Upvotes: 2

Related Questions