My_trigg.Sql
CREATE
OR
REPLACE
TRIGGER
my_trigger
AFTER
UPDATE
of
fid ON
flights
DECLARE
nameu
VARCHAR2(50);
BEGIN
dbms_output.put_line('We
here.');
nameu
:= USER;
IF
(nameu <> 'SYSTEM') THEN
INSERT
INTO
for_trigger VALUES(seq.nextval,
nameu, TO_DATE(SYSDATE,'DD.MM.YYYY'));
END
IF;
END;
My_view.Sql
CREATE
OR
REPLACE
VIEW
my_view AS
SELECT
airplanes.avialines, airplanes.acapacity AS
airplanes, flights.fname, flights.fdata AS
flights FROM
flights, airplanes
WHERE
flights.fid = airplanes.f_id;
SELECT
* FROM
my_view;
GRANT
SELECT
ON
my_view TO
PUBLIC;
grant.sql
CREATE
OR
REPLACE
PROCEDURE
changekey(num IN
NUMBER,
newkey IN
NUMBER)
IS
BEGIN
pack2.changekey(num,
newkey);
END
changekey;
/
GRANT
EXECUTE ON
changekey TO
SYSTEM;