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...
Monday, 7 November 2016
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
...
Oracle PL/SQL Introduction
Oracle PL/SQL Introduction
*Procedural Language extension with SQL with design features of Programming language.
*Data Manipulation & query Statement of SQL are included with procedural Unit of
Code.
*It mainly used for reduce the network traffic.
*It group the set of logical statement Into...
