RDBMS2_INTERNAL

-----PROCEDURE

CREATE OR REPLACE PROCEDURE PROCEDURE_NAME
(PARAMETER)
AS
CURSOR CURSOR_NAME IS SQL_QUERY;
BEGIN
FOR VARIABLE_NAME IN CURSOR_NAME
LOOP
--CODE
--DISPLAY STATEMENT DEPENDS ON QUESTION
DBMS_OUTPUT.PUT_LINE();
END LOOP;
--DISPLAY STATEMENT DEPENDS ON QUESTION
DBMS_OUTPUT.PUT_LINE();
END;

BEGIN
PROCEDURE_NAME(PARAMETERS);
END;

--------
OR
--------

CREATE OR REPLACE PROCEDURE PROCEDURE_NAME
(PARAMETER)
AS
BEGIN
FOR VARIABLE_NAME IN (SQL_QUERY)
LOOP
--CODE
--DISPLAY STATEMENT DEPENDS ON QUESTION
DBMS_OUTPUT.PUT_LINE();
END LOOP;
--DISPLAY STATEMENT DEPENDS ON QUESTION
DBMS_OUTPUT.PUT_LINE();
END;

BEGIN
PROCEDURE_NAME(PARAMETERS);
END;


-----TRIGGER


CREATE TRIGGER TRIGGER_NAME
BEFORE INSERT OR UPDATE ON TABLE_NAME
FOR EACH ROW
--CODE
END;


----SEQUENCE


CREATE SEQUENCE SEQUENCES_NAME
START WITH 1
INCREMENT BY 1

INSERT INTO TABLE_NAME(SEQUENCES_NAME.NEXTVAL,.....);


----CURSOR


CURSOR CURSOR_NAME IS SQL_QUERY;
OPEN CURSOR_NAME;
FETCH CURSOR_NAME INTO VARIABLE_NAME;
CLOSE CURSOR_NAME;


----PACKAGE


CREATE OR REPLACE PACKAGE PACKAGE_NAME
AS
PROCEDURE PROCEDURE1_NAME(PARAMETERS);
PROCEDURE PROCEDURE2_NAME(PARAMETERS);
PROCEDURE PROCEDURE3_NAME(PARAMETERS);
END;

CREATE OR REPLACE PACKAGE BODY PACKAGE_NAME
AS

PROCEDURE PROCEDURE1_NAME(PARAMETERS)
--CODE
END;

PROCEDURE PROCEDURE2_NAME(PARAMETERS)
--CODE
END;

PROCEDURE PROCEDURE3_NAME(PARAMETERS)
--CODE
END;

END;

BEGIN
PACKAGE_NAME.PROCEDURE_NAME(PARAMETERS);
END;


----FUNCTION


--FUNCTION RETURNS ONLY VALUES WHERE PROCEDURE EXECUTES COMMANDS

CREATE OR REPLACE FUNCTION FUNCTION_NAME
(PARAMETERS)
RETURN DATA_TYPE
IS
VARIABLE
BEGIN
SQL_QUERY;
RETURN VARIABLE;
END;

DECLARE
VARIABLE
BEGIN
VARIABLE := FUNCTION_NAME(PARAMETERS);
DBMS_OUTPUT.PUT_LINE(VARIABLE);
END;