enrique_aeo
asked on
not execute all code
i am trying execute this query in pL/SQL
why is not execute all code? only execute
--TA_ANIO_EJERCICIO
CREATE TABLE TA_ANIO_EJERCICIO(
idAnioEjercicio NUMBER(8) PRIMARY KEY,
anio VARCHAR2(4) NOT NULL,
CONSTRAINT UNQ_TA_ANIO_EJERCICIO
UNIQUE (anio)
);
CREATE SEQUENCE SEQ_idAnioEjercicio START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER TGR_ANIO_EJERCICIO_INSERT
BEFORE INSERT ON TA_ANIO_EJERCICIO
FOR EACH ROW
BEGIN
SELECT SEQ_idAnioEjercicio.Nextva l into :new.idAnioEjercicio FROM DUAL;
END;
CREATE-TABLE.sql
why is not execute all code? only execute
--TA_ANIO_EJERCICIO
CREATE TABLE TA_ANIO_EJERCICIO(
idAnioEjercicio NUMBER(8) PRIMARY KEY,
anio VARCHAR2(4) NOT NULL,
CONSTRAINT UNQ_TA_ANIO_EJERCICIO
UNIQUE (anio)
);
CREATE SEQUENCE SEQ_idAnioEjercicio START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER TGR_ANIO_EJERCICIO_INSERT
BEFORE INSERT ON TA_ANIO_EJERCICIO
FOR EACH ROW
BEGIN
SELECT SEQ_idAnioEjercicio.Nextva
END;
CREATE-TABLE.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you execute it as a script ?