databaseregistro oracle
If you can't read please download the document
DESCRIPTION
Ejemplo de oracleTRANSCRIPT
create tablespace tbs_empresa1 Datafile 'C:\oracle\product\10.1.0\oradata\orcl\Data_registro1.dbf' size 10 m; create user REGISTRO1 identified by oracle default tablespace tbs_empresa1; grant connect,resource,dba to REGISTRO1 ; connect REGISTRO1@orclCREATE TABLE REGISTRO(Empresa varchar(50),Tipo varchar(20),Ruc varchar(12),direccion varchar(100),Fecha date,Administrador varchar(50),Datos varchar(50),serie varchar(16));CREATE TABLE ADMIN(CodigoAdmin varchar(10),Datos varchar(50)); CREATE TABLE SERIE(Serie varchar(16));INSERT INTO ADMIN VALUES('ADMIN001','Jose Luis Perez');INSERT INTO SERIE VALUES('120-230-340-450');CREATE TABLE MODULOS(CODMOD VARCHAR(6) PRIMARY KEY,NOMMOD VARCHAR(50),ESTMOD varchar(1),DESMOD VARCHAR(200),F_CREAMOD DATE,F_MODIMOD DATE);CREATE TABLE CABECERA(CODCAB VARCHAR(6)PRIMARY KEY,NOMCAB VARCHAR(50),ESTCAB varchar(1),DESCAB VARCHAR(200),F_CREACAB DATE,F_MODICAB DATE,CODMOD VARCHAR(6) REFERENCES MODULOS(CODMOD));CREATE TABLE FORMULARIOS(CODFOR VARCHAR(6)PRIMARY KEY,NOMFOR VARCHAR(30),ESTFOR varchar(1),FECHA DATE);Create Table OPCIONES( CODopc Varchar(6) primary key, NomOPC Varchar(50), DesOPC Varchar(200), F_OPC Date, EstOPC Varchar(2), CODcab Varchar(6) references Cabecera, COdFor varchar (6) references Formularios, CODMod Varchar(6) references ModuloS );INSERT INTO FORMULARIOS VALUES('F0001','FmrCliente','1','06/12/2011');INSERT INTO FORMULARIOS VALUES('F0002','FmrProducto','1','06/12/2011');INSERT INTO FORMULARIOS VALUES('F0003','FmrEmpleado','1','06/12/2011');CREATE TABLE OPCIONES(CODOPC VARCHAR(6)PRIMARY KEY,NOMOPC VARCHAR(50),ESTOPC varchar(1),DESOPC VARCHAR(200),F_CREAOPC DATE,F_MODIOPC DATE,CODMOD VARCHAR(6)REFERENCES MODULOS(CODMOD),CODCAB VARCHAR(6)REFERENCES CABECERA(CODCAB),CODFOR VARCHAR(6)REFERENCES FORMULARIOS(CODFOR));