1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| SQL> create table TBFVSANA2
(
IDANO NUMBER ,
NOPOL VARCHAR2(50) not null,
DTCREREJ DATE not null,
COFLX VARCHAR2(2),
COCAUEVE VARCHAR2(2),
VADONREJ VARCHAR2(50) not null,
COACT VARCHAR2(2),
COSTA VARCHAR2(2),
ANAMOA CLOB,
ANAMOE CLOB,
ANAGES CLOB,
DTCOR DATE,
DTDERMOD DATE,
KODGF NUMBER(1) not null,
LBMSGERR VARCHAR2(150),
ROLPER VARCHAR2(3),
IDCLIGRP VARCHAR2(50),
LID VARCHAR2(4),
MOESTA VARCHAR2(75),
ATTMOESIL VARCHAR2(125),
DTESTREA DATE,
NOTIC VARCHAR2(50),
CONATCTR VARCHAR2(2)
);
Table creee.
SQL> CREATE SEQUENCE IDANO
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;
Sequence creee.
SQL> |
Partager