GeekInterview.com
Series: Subject: Topic:
Question: 98 of 492

Explicit cursor and Select into statement

What is the difference between an explicit cursor and select into statement?
Asked by: varma.ukk | Member Since Sep-2008 | Asked on: Sep 29th, 2008

View all questions by varma.ukk

Showing Answers 1 - 6 of 6 Answers
neppalli

Answered On : Oct 3rd, 2008

View all answers by neppalli

Explicit cursors are those user defined cursors in order to retrive more than one row from a table. Select into statment helps in invoking parmeters into the formal parameters.

  
Login to rate this answer.
kz4ora

Answered On : Nov 8th, 2008

View all answers by kz4ora

Explicit cursor- They are defined by programmer.The select statement can return multiple rows as a query result. If you want to process single row at a time then you can define an explicit cursor for this select statement.Cursor is  like a temporary area where you can process fetch the records and process then individually as required select into statement-select value1,value2... into var1,var2......

Yes  1 User has rated as useful.
  
Login to rate this answer.
promisinganuj

Answered On : Sep 13th, 2009

View all answers by promisinganuj

When a cursor name is explicitly assigned to a SELECT statement through CURSOR statement, it is called an explicit cursor. Explicit cursors are generally used to work with more than one row within PL/SQL. It has got the following attributes:1. Defining the Cursor2. Opening the Cursor3. Fetching rows(values) from Cursor (one at a time)4. Closing the CursorSELECT into statement allows you to retrives the query result in user defined variables. But the limitation here is that the query must return a single row. Its a best practice to handle NO_DATA_FOUND and TOO_MANY_ROWS exception when dealing with "SELECT INTO" statement.

  
Login to rate this answer.
manveshv

Answered On : Dec 30th, 2009

View all answers by manveshv

A Select..into statement is even an implicit cursor concept. But the disadvantage is it can't handle if the select statement returns more than 1 row.So, implicit cursor opens before the statements executed and closed after automatically and hence it is preferred when a select statement returns one row or for using DML operations.Explicit Cursor needs to be opened, fetch rows and close explicitly. This can be used when we need to process each and every statement the select query returns.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
rashlikesu

Answered On : May 12th, 2010

View all answers by rashlikesu

When select into query returns just one row, Oracle uses implicit cursor to execute and fetch the results for the query.But if the select statement returns more than one row, an Explicit cursor is created to fetch the data.

  
Login to rate this answer.
neerajalatha

Answered On : Jul 5th, 2010

View all answers by neerajalatha

Select statement can return multiples rows at a time and there exists only one network round trip.Explicit cursors are memory areas which acts as a handle or pointer to context area and allows to fetch and process query results row by row .because of row by row processing there will me more network round trips. 

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.