PACKAGE .Function (Procedure – never return)

Sequence
Trigger
PACKAGE .Function (Procedure – not return )
in package, Return cursor

RETURN CHECK_USER_ROLE (V('APP_USER'),'***J_FIELD_TECH_RL')

http://forums.oracle.com/forums/thread.jspa?messageID=547397

Not
<>
!=
not

IN operator
To specify multiple values in a Where clause
MAX() function
returns the largest value of the selected column.

The outer join marker (+) signals the DBMS to insert a NULL value for the fields in the outer table that do not have matching rows in the inner table.

upper function converts all letters in the specified string to uppercase
the instr function returns the location of a substring in a string
the NVL function lets you substitute a value when a null value is encountered.