Varios
PROMPT ;
PROMPT <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>;
PROMPT <<<<<<< ELIMINADO TABLAS EXISTENTES >>>>>>>;
PROMPT<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>;
PROMPT ;
prompt ....eliminando tabla TASAS;
DROP TABLE TASAS CASCADE CONSTRAINT;
prompt ....eliminando tabla EMP;
DROP TABLE EMP CASCADE CONSTRAINT;
prompt ....eliminando tabla DEPT;
DROP TABLE DEPT CASCADE CONSTRAINT;
prompt ....eliminando tabla BONUS;
DROP TABLE BONUS CASCADECONSTRAINT;
prompt ....eliminando tabla SALGRADE;
DROP TABLE SALGRADE CASCADE CONSTRAINT;
prompt ....eliminando tabla DUMMY;
DROP TABLE DUMMY CASCADE CONSTRAINT;
prompt ....eliminando tabla ITEM;
DROP TABLE ITEM CASCADE CONSTRAINT;
prompt ....eliminando tabla ORD;
DROP TABLE ORD CASCADE CONSTRAINT;
prompt ....eliminando tabla CUSTOMER;
DROP TABLE CUSTOMER CASCADE CONSTRAINT;
prompt....eliminando tabla PRODUCT;
DROP TABLE PRODUCT CASCADE CONSTRAINT;
prompt ....eliminando tabla PRICE;
DROP TABLE PRICE CASCADE CONSTRAINT;
prompt ....eliminando tabla RESUMEN_ORD;
DROP TABLE RESUMEN_ORD CASCADE CONSTRAINT;
prompt ....eliminando tabla RESUMEN_ORD_DET;
DROP TABLE RESUMEN_ORD_DET CASCADE CONSTRAINT;
prompt ....eliminando tabla TEMP;
DROP TABLE TEMP CASCADE CONSTRAINT;
prompt....eliminando tabla LOG_OBJETOS;
--DROP TRIGGER log_modifica;
DROP TABLE log_objetos ;
prompt ;
PROMPT <<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>;
PROMPT <<<<<<< VOLVIENDO A CREAR TABLAS >>>>>>>;
PROMPT<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>;
prompt ;
prompt ....creando tabla TEMP;
create table temp (
columna1 char(10),
columna2 char(25),
columna3 char(10));
prompt ....creando tabla DEPT;
CREATE TABLE DEPT(
DEPTNO NUMBER(4) NOT NULL CONSTRAINT PK_DEPTPRIMARY KEY,
DNAME VARCHAR2(14),
LOCAL VARCHAR2(13));
prompt ....creando tabla EMP;
CREATE TABLE EMP(
EMPNO NUMBER(4) NOT NULL CONSTRAINT PK_EMP PRIMARY KEY,
ENAME VARCHAR2(20),
JOB VARCHAR2(15),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(4) );
-- CONSTRAINT FK_DEPTNO REFERENCES DEPT);
prompt....creando tabla TEMP_EMPLEADO;
CREATE TABLE TEMP_EMPLEADO(
ENAME VARCHAR2(20),
JOB VARCHAR2(15),
MGR NUMBER(4),
SAL NUMBER(7,2),
DEPTNO NUMBER(4),
DIRECCION VARCHAR2(500));
prompt ....creando tabla BONUS;
CREATE TABLE BONUS(
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
SAL NUMBER,
COMM NUMBER);
prompt ....creando tabla SALGRADE;CREATE TABLE SALGRADE(
GRADE NUMBER CONSTRAINT pk_salgrade PRIMARY KEY,
LOSAL NUMBER,
HISAL NUMBER);
prompt ....creando tabla DUMMY;
CREATE TABLE DUMMY(
DUMMY NUMBER);
prompt ....creando tabla CUSTOMER;
CREATE TABLE CUSTOMER(
CUSTID NUMBER(6) NOT NULL,
NAME CHAR(45),
ADDRESS CHAR(40),
CITY CHAR(30),
STATE CHAR(2),
ZIPCHAR(9),
AREA NUMBER(3),
PHONE CHAR(9),
REPID NUMBER(4),
CREDITLIMIT NUMBER(9,2),
COMMENTS LONG,
CONSTRAINT CUSTOMER_PRIMARY PRIMARY KEY (CUSTID),
CONSTRAINT CUSTID_ZERO CHECK(CUSTID>0));
prompt ....creando tabla ORD;
CREATE TABLE ORD(
ORDID NUMBER(4) NOT NULL,
ORDERDATE DATE,
COMMPLAN CHAR(1),
CUSTID NUMBER(6) NOT NULL,
SHIPDATE...
Regístrate para leer el documento completo.