Interview Question

    1. Pseudo columns

     Automatically filled by Oracle.

     Ex: sysdate, nextval, currval, rowid, rownum, level, sqlcode, sqlerrm, new, old.

2. What are the Parameters for raise_application_errror ()?

    The parameters are Error Code and an Error Message.

    The Syntax: raise_application_errror (Error Code, Error Message);

3. What are the User PARAMETERS in the Reports?

           P_CONC_REQUEST_ID

       P_FLEX_VALUE