Submitted Questions

  • Current Database Name

    How to know the current database name in PL/SQL?

    Saravanan Govindan

    • Jul 20th, 2011

    Select name from v$database;

    Code
    1. SELECT name FROM v$database;

    Saravanan Govindan

    • Jul 20th, 2011

    Select name from v$database;

  • User Defined Exception Handler

    Suppose a programmer creates a user defined exception handler Invalid_Number in declare block with type EXCEPTION and raise this exception in begin block. Then how will you access the user defined exception and same system defined exception (i.e Inavlid_Number)

  • SQL NULLIF Function

    What is the use of NULLIF function in SQL?

    sampra

    • Mar 6th, 2012

    In SQL, NullIf function is used to compare two expressions. There are 3 possible results for NULLIF. 1. If the values are same, NullIf returns NULL. Eg: NULLIF(Prem,Prem) returns NULL 2. If they are...

    Prem_p

    • Apr 28th, 2011

    In SQL, NullIf function is used to compare two expressions. There are 3 possible results for NULLIF.1. If the values are same, NullIf returns NULL. Eg: NULLIF('Prem','Prem') returns NU...

  • On-Error Trigger

    If you write NULL in on-error trigger defined in Form level of Forms 10g, then what will happen to the error message during runtime? Will the error message get displayed or not?

    praduman jha

    • Dec 10th, 2011

    Dear All, Basically when we write null on on error then at that time, no error will display. At the backend when we want to search the on which packages are firing then write down ON_ERROR...

    Nithin

    • Jul 24th, 2011

    Nothing Happens... the on-error trigger wont be handled in case a NULL is written in the trigger