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

Windows 8 boot loader corrupted

Problem:     Installed Windows 7 and Windows 8 in EFI mode on a hard disk some days past. Today, the boot loader is absent or corrupted. At present have the Windows 8 installer on a flash drive and tried using the Automatic Repair option to repair the boot loader but it didn't do anything. The Startup Repair option is also absent in the Windows 8 installer. How I can repair or recreate the EFI boot loader from the Command Prompt? BCDEDIT   returns the following message: The requested system device cannot be found. Solution: Firstly, boot from a UEFI Windows 8 recovery disk (CD/DVD/USB) - I found that the automated recovery process didn't find the correct Windows partition, nor when I managed to add it to BCD settings would it make it reliably boot-able e.g. using BCDEDIT I got it to find and launch the Windows partition but it refused to cold boot or would not "keep" the settings after a 2nd reboot or power off. Go into the Advanced option
5 comments
Read more