Cheat Sheet

Oracle

OAF MVC Diagram



GRANT ALL PRIVILEGES TO SAKUYA;

CREATE [OR REPLACE] FUNCTION | PROCEDURE name
    [ (parameter [,parameter]) ]
    RETURN return_datatype
IS | AS
    [declaration_section]
BEGIN
    executable_section
[EXCEPTION
    exception_section]
END [function_name];

accessing a Sequence's next value

XXHLS.XXHLS_REFERENCE_NUMBER_S.NEXTVAL