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  ...

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 ...