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

Report message to a moderator

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....

Report message to a moderator

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

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
You already asked. No need to start a new topic in another forum.

Topics merged.

Report message to a moderator

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: 4963
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.

Report message to a moderator

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

Report message to a moderator

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: 7065
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

Report message to a moderator

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 )

Report message to a moderator

Previous Topic: Need a query
Next Topic: Decode help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 15:15:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.