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 =
=================
|...
Sunday, 18 December 2016
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
...
Monday, 7 November 2016
Cursor In Oracle
CURSOR IN ORACLE
It's a SQL Private work area Where the query get Passed & execute.
TYPES::
1.Implicit Cursor
2.Explicit Cursor
1.Implicit Cursor
If your query returns exactly one row,Then declare the PL/SQL Engine
Default Name .....((SQL))
SQL%attribute_Name;
2.Explicit...
Sunday, 6 November 2016
Conditional Statements
Conditional Statements
The following conditional statement are there in Oracle.Which is used inside the PL/SQL Block While Checking the Condition or Validating the Business logic's in our own Way.
1.IF
2.IF ELSE
3.Multiple IF ELSE
4.LOOP
5.FOR LOOP
6.WHILE
7.GO TO
8.EXIT
...