Skip to main content

Oracle Interview Question And Answer

1. How many report trigger available in Oracle Reports?

Answer: Oracle Report has 5 triggers. There are :
    1.BEFORE PARAMETER FORM
    2. AFTER PARAMETER FORM
    3. BEFORE REPORT
            4. AFTER REPORT
            5. BETWEEN PAGES

2. How many built-in Package available in Oracle Reports?

Answer:  Oracle Report has 14 built-in package. There are:

Built-in Package:
1. EXEC_SQL
2. SRW
3. OLE2
4. DDE
5. ORA_FFI
6. ORA_PROF
7. ORA_NLS
8. TEXT_IO
9. TOOL_ENV
10. TOOL_RES
11. TOOL_ERR
12. LIST
13. DEBUG
14. STANDARD

-- Cheers !!!

Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.
Post a Comment
Read more

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System).   Basically Its’s occurring on windows platform.
Post a Comment
Read more

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???
Post a Comment
Read more