/* Shell Borrado de Tablas */
PROMPT 'BORRA TABLAS para Recrearlas'
drop table emp;
drop table dept;

/* Shell Creacion de Tablas */
PROMPT Creando Tabla 'emp'
create table emp (
empno number (4) primary key,
ename varchar2 (10),
job varchar2 (9),
mgr number (4),
hiredate date,
sal number (7,2),
comm number (7,2),
deptno number (2)
)
/

PROMPT Creando Tabla 'dept'
create table dept (
deptno number(2 ) primary key,
dname varchar2 (14),
loc varchar2 (13)
);





