Oracle SQL / PLSQL uses synonym as an alias for any database object such as tables, views, sequences, stored procedures, and other database object. In other words we can say that in Oracle SQL / PLSQL a synonym is an alternative name for database objects. Oracle SQL / PLSQL syntax to create or replace a […]
plsql
WHEN OTHERS CLAUSE in Exceptions in Oracle PLSQL
WHEN OTHERS CLAUSE in PLSQL Exceptions:- WHEN OTHERS CLAUSE in PLSQL Exceptions is used to capture an exception that’s not handled by our Named System Exception or Named Programmer Defined Exception. The plsql syntax for using WHEN OTHERS Clause in an Exception within a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] […]
Named Programmer Defined Exceptions in Oracle PLSQL
Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named Programmer Defined Exception:- The named programmer defined exceptions are the plsql exceptions that are defined by a programmer to trap specific exceptions hence have been named. The named programmer defined plsql exceptions are not named in the standard package in plsql […]
Named System Exceptions in Oracle PLSQL
Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named System PLSQL Exceptions:- The named system exceptions are the plsql exception that are encountered frequently and hence have been named for ease of use and that’s why they are called as named system exception. The named plsql exceptions are named in […]
Exception Handling in Oracle PLSQL
Oracle PLSQL exception can be termed as a condition that terminates the execution of plsql block. Oracle PLSQL gives us the functionality to handle the exception that can crop up in any Oracle PLSQL block and this functionality is called as Exception Handling. Using plsql exception handling we can avoid the code to end abruptly. […]