-
Current Database Name
How to know the current database name in PL/SQL?
-
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)
-
PL/SQL UTL_FILE Package
Which exception is used in UTL_FILE package in PL/SQL?
-
SQL NULLIF Function
What is the use of NULLIF function in SQL?
-
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?
-
Records Count
How to count number of records in a table without using COUNT function?