17 de junio de 2015 - GiselleE/basedatos2 GitHub Wiki

CREATE TABLE aerolinea(ID_Aerolinea INTEGER, NOMBRE VARCHAR2(120), CONSTRAINT ID2_Aerolinea_PK PRIMARY KEY(ID_Aerolinea));

CREATE TABLE avion (ID_avion INTEGER, ID_aerolinea INTEGER, asiento INTEGER, CONSTRAINT ID_Avion_PK PRIMARY KEY(ID_avion), CONSTRAINT ID_Aerolinea_FK FOREIGN KEY (ID_Aerolinea) references aerolinea (ID_Aerolinea));

describe avion;

create sequence sec_aerolinea start with 1 increment by 1 nomaxvalue;

create sequence sec_avion start with 1 increment by 1 nomaxvalue;

CREATE OR REPLACE procedure guardar_aerolinea( MY_ID_Aerolines OUT INTEGER, MY_NOMBRE IN VARCHAR2) AS BEGIN SELECT sec_aerolinea.NEXTVAL INTO MY_ID_AEROLINEA FROM DUAL; INSERT INTO AEROLINEA VALUES(MY_ID-AEROLINEA, MY_NOMBRE); END; /

CREATE OR REPLACE PROCEDURE GUARDAR_AVION( MY_ID_AVION OUT INTEGER, MY_ID_AEROLINEA IN INTEGER, MY_ASIENTOS IN INTEGER) AS BEGIN SELECT sec_avion.NEXTVAL INTO MY_ID_AVION FROM DUAL; INSERT INTO AVION VALUES(MY_ID_AVION, MY_ID-AEROLINEA, MY_ASIENTOS); END; /