Notes

create or replace TRIGGER Venueadd
BEFORE INSERT ON VENUE
FOR EACH ROW
DECLARE
rowcount int;
BEGIN
SELECT COUNT(*) into rowcount FROM Venue WHERE Venue_name =:new.Venue_name;
IF rowcount<>0 THEN
raise_application_error(-20011,'Email Already Registered');
END IF;
END;


create or replace TRIGGER Updateprice
BEFORE INSERT ON VENUE
FOR EACH ROW
DECLARE
count int;
BEGIN
Dbms_output.put_line(‘The venue_name has been changed to : ‘|| :NEW.venue_name);
END;


CREATE OR REPLACE FUNCTION ADD_VENUE_FUNCTION (VENUE_SIZE_FUNCTION IN INTEGER) RETURN NUMBER
AS
NUMBER_O_DATA NUMBER :=0;
BEGIN
SELECT COUNT(*) INTO NUMBER_O_DATA
FROM VENUE WHERE VENUE_SIZE = VENUE_SIZE_FUNCTION;
RETURN NUMBER_O_DATA;
END ADD_VENUE_FUNCTION;


--CHECKING DATA
BEGIN
DBMS_OUTPUT.PUT_LINE ('NUMBER OF VENUE WITH: ' || ADD_VENUE_FUNCTION (2000));
END;


CREATE OR REPLACE FUNCTION ADD_VENUE_FN (VENUE_SIZE_FN IN INTEGER) RETURN NUMBER
AS
NUMBER_O_DATA NUMBER :=0;
BEGIN
SELECT COUNT(*) INTO NUMBER_O_DATA
FROM VENUE WHERE VENUE_SIZE = VENUE_SIZE_FN;
RETURN NUMBER_O_DATA;
END ADD_VENUE_FN;


--CHECKING DATA
BEGIN
DBMS_OUTPUT.PUT_LINE ('NUMBER OF VENUE WITH: ' || ADD_VENUE_FN (2000));
END;

create or replace procedure event_detail(
eve in event.event_id%type,
e_name in event.event_name%type
)as
Begin
insert into event(event_id,event_name) values (eve, e_name);
end event_detail;

Begin event_detail(
eve =>'12',
e_name =>'Winter Party'
);
end event_detail;

create or replace procedure band_detail(
ban in band.band_id%type,
b_name in band.band_name%type
)as
Begin
insert into band(band_id,band_name) values (ban, b_name);
end band_detail;

Begin band_detail(
ban =>'12',
b_name =>'Winter Party'
);
end band_detail;


create or replace FUNCTION VENUE_FUNC (VENUE_SIZE_FN IN INTEGER)
RETURN NUMBER
AS
NUMBER_OF_DATA NUMBER :=0;
BEGIN
SELECT COUNT(*) INTO NUMBER_OF_DATA
FROM venue
WHERE venue_size=VENUE_SIZE_FN;
RETURN NUMBER_OF_DATA;
END VENUE_FUNC;