Home » SQL & PL/SQL » SQL & PL/SQL » Question about cursors (merged)
Question about cursors (merged) [message #189506] Thu, 24 August 2006 23:16 Go to next message
kishore2y
Messages: 14
Registered: April 2006
Location: chennai
Junior Member

hi,


i was attend one interview question is like this


if iam using cursor means it will gives me multiple rows

but iam using procedure also it is possible.but why iam going for cursor and why iam calling that cursor into procedure


thanks,
kishore
Re: cursors [message #189564 is a reply to message #189506] Fri, 25 August 2006 02:14 Go to previous messageGo to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member

Can you post your question clearly? i did not get it....
cursor problem [message #189663 is a reply to message #189506] Fri, 25 August 2006 08:42 Go to previous messageGo to next message
kishore2y
Messages: 14
Registered: April 2006
Location: chennai
Junior Member

hi,


i faced one interview they asking me cursors like this


using cursors means fetching multiple rows.

insted of cursors i create a procedure and fetch multiple rows

so why we create a cursors and caling that cursors into procedures

what is the main advantage



thanks,
kishore





Re: cursor problem [message #189676 is a reply to message #189663] Fri, 25 August 2006 09:36 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You already asked. No need to start a new topic in another forum.

Topics merged.
Re: cursor problem [message #189700 is a reply to message #189663] Fri, 25 August 2006 12:41 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
With grammar and punctuation like that you'd be lucky to get an answer, or a job for that matter.
Re: cursor problem [message #189894 is a reply to message #189700] Mon, 28 August 2006 06:47 Go to previous messageGo to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
i'm just wondering how it is possible to fetch the record in the procedure without cursor..

is it possible???

Even if you want to process multiple records with row by row operation, you have to use cursor. i dont think that other choice is exist for this.

Thanks,
Thangam
Re: cursor problem [message #189898 is a reply to message #189894] Mon, 28 August 2006 07:11 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
gold_oracl wrote on Mon, 28 August 2006 13:47

i'm just wondering how it is possible to fetch the record in the procedure without cursor..

is it possible???
I think not. Oracle will (AFAIK) always open a cursor.

MHE
Re: cursor problem [message #189900 is a reply to message #189700] Mon, 28 August 2006 07:16 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

With grammar and punctuation like that you'd be lucky to get an answer, or a job for that matter
unless of course, The ability to converse in English is not a major requirement for the job (not every job requires good English Smile )
Previous Topic: Need a query
Next Topic: Decode help
Goto Forum:
  


Current Time: Sat Dec 10 20:24:26 CST 2016

Total time taken to generate the page: 0.21962 seconds