The implicit cursors :
The declaration of implicit cursors performed during SQL queries returning single row from the PL/SQL block.The implicit cursors are constructed through the simple SELECT statements which resides between the BEGIN and END section of PL/SQL Block.It is easy to perform the code.
The cursor are capable to retrieve exactly one row at a time.The commonly occurred exceptions regarding the implicit cursor areNO_DATA_FOUND or TOO_MANY_ROWS. The syntax would be as follows :
Code:
SQL> SELECT emp_name, salary INTO Enm, Esal FROM EMP WHERE EMPNO = 4439;
Where the Emp_name and salary are columns of the EMP table and Enm and Esal are variables being used to store the result fetched by the query.
Bookmarks