BISWARUPYOGI
   Latestt Score:50
   Pings:0



ORACLE TECHNICAL PAPER 2 Question Papers
1. What are the PL/SQL Statements used in cursor processing ?
ANS:-DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record
types, CLOSE cursor name.
2. What are the cursor attributes used in PL/SQL ?
ANS:-%ISOPEN - to check whether cursor is open or not
% ROWCOUNT - number of rows fetched/updated/deleted.
% FOUND - to check whether cursor has fetched any row. True if rows are fetched.
% NOT FOUND - to check whether cursor has fetched any row. True if no rows are fetched.
These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit
Cursors.

Shared By: jaism123     Views: 349     Comments: 0      Downloads: 77      Rating :       Your Rating: 
Close X Share This Document

Copy and Paste URL



Close X Send This Document

Your Name:


Send to:


Message:


Close X Did you like this Question Paper      

Close X Embed This Document
Copy the embed code below Advanced Options

Embed Code:


Embed Code for WordPress.com

Close X Please select the reason(s) for reporting this document



 


Copyright (Report it to me , our team will take an appropiate action after due dilogenie )
Get registered with latestt to download full details. Its Free
Comments
Please try again..
Add Comments:


No comment available.
Note :- Latestt provides general and basic information related to colleges, institutes, universities, exams guidelines, course details, news, updates offered by respective educational bodies and authorities. Information has been collected through various secondary resources available in public domain. Please contact the respective College / University / Institutes / Exam Authorities for the accurate & updated information. All rights and trademarks are reserved for their respective owners. We have tried to provide as correct details as possible. However, if you come across any error or discrepancy, do let us know about it.