Sunday, 18 December 2016

Stored Procedures

Stored Procedures 1.Its a PL/SQL Named Sub program,Which compiled and Stored in the Database for the repeated usage. 2.Its a Schema Object 3."Procedure Perform an action" 4.We can call the procedure inside the anonymous block. Example Diagram:: ================= =Stored Program = ================= |...

Saturday, 3 December 2016

Exceptions In Oracle

Exception Handling In Oracle                       Exception means "Handling the Errors". Types of Exceptions::         1.Pre Defined Exceptions         2.User Defined Exceptions 1.Pre Defined Exceptions  ...