Script Oracle
CREATE TABLE categories
(
categoryid INTEGER primary key NOT NULL,
categoryname VARCHAR2(15 BYTE) NOT NULL,
description VARCHAR2(500 BYTE)
)
CREATE TABLE products
(
productid INTEGER primary key NOT NULL,
productname VARCHAR2(40 BYTE) NOT NULL,
supplierid INTEGER,
categoryid INTEGER,
quantityperunit VARCHAR2(20 BYTE),
unitprice NUMBER(18, 4),
unitsinstock NUMBER(4),
unitsonorder NUMBER(4),
reorderlevel NUMBER(4),
discontinued NUMBER(1)
)
Suscribirse a:
Entradas (Atom)
No hay comentarios.:
Publicar un comentario