ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
why use cursors?
 Question Submitted By :: Sophia
I also faced this Question!!     Rank Answer Posted By  
 
  Re: why use cursors?
Answer
# 1
Cursor is used to process multiple rows using pl/sql.
 
Is This Answer Correct ?    6 Yes 3 No
Aravind
 
  Re: why use cursors?
Answer
# 2
Cursor : It's a private SQL worksheet area where we can 
execute SQL commands and processing information.
The purpose of the Cursor is,  PL/SQL execution block will 
process only one records means it will return only one 
records.If we want to retrieve or process more number of 
records we use the "Cursors". 
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh
 
Is This Answer Correct ?    8 Yes 1 No
Suresh Kumar Somayajula
 
 
 
  Re: why use cursors?
Answer
# 3
to perform multiple rows accessing.
 
Is This Answer Correct ?    0 Yes 0 No
Chandu
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
wht is the difference between sqlaserver2000 and 2005 ABC1
What is TABLE SPACE? ABB2
Explain the usage of WHERE CURRENT OF clause in cursors ?  2
if i perform any operation on views such as insert, delete etc will my base table get affected?????  3
select 1,col1,col2 from table1. output? Ramco3
Can we write create command in the plsql block?if possible how?  2
What are the advantages of the packages Oracle4
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?  2
What is clustered and non-clustered indexes? Microsoft3
Give the structure of the procedure ?  1
Explain the two type of Cursors ? Hi-Caliber-IT4
What cursor type do you use to retrieve multiple recordsets? Microsoft9
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees. Wipro7
How to convert ms-excel file to oracle table?  2
how to create object in plsql Microsoft1
What is a join?Explain the different types of joins? Saama-Tech3
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS Polaris1
difference between cursor and procedure in a package  2
What is Pragma EXECPTION_INIT ? Explain the usage ?  1
What is the difference between RDBMS and DBMS? Stag-Computers5
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com