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

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

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS
Post a Comment
Read more