Home » SQL & PL/SQL » SQL & PL/SQL » Loops (oracle 11g)
Loops [message #651992] Tue, 31 May 2016 01:48 Go to next message
Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
Difference between cursor for loop and for loop, which is faster?

Pls explain me with examples.
Re: Loops [message #651996 is a reply to message #651992] Tue, 31 May 2016 01:58 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
What do you mean? Can you provide code for the two structures to which you are referring?
Re: Loops [message #651997 is a reply to message #651992] Tue, 31 May 2016 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Don't expect we answer your interview questions, you have to work a little bit.
In addition, we are waiting for your feedback in your previous topic: http://www.orafaq.com/forum/m/651916/#msg_651916

Re: Loops [message #652006 is a reply to message #651997] Tue, 31 May 2016 03:40 Go to previous messageGo to next message
Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
I am just working out to get answer for all the possible interview questions by own..I am coming here if i am not satisfied with my answer and have any doubt..Please its my request not to feel bored of my interview questions. Kindly help me to get the answers. Thank you
Re: Loops [message #652008 is a reply to message #652006] Tue, 31 May 2016 03:41 Go to previous messageGo to next message
Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
Yet i didnt get into the above topic which you have all answered recently. I am sure i will reply u all once i went through the whole answers.
Re: Loops [message #652009 is a reply to message #652008] Tue, 31 May 2016 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
.I am coming here if i am not satisfied with my answer and have any doubt.


So post your answer and we will tell you what's wrong (if anything is) and point you to the proper section of the documentation but you must FIRST feedback to your previous topics.

[Updated on: Tue, 31 May 2016 04:20]

Report message to a moderator

Re: Loops [message #652010 is a reply to message #652006] Tue, 31 May 2016 03:48 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I am just working out to get answer for all the possible interview questions by own
No, you are not "working out" any answers. You are asking for answers. Do what I suggested: write some code that shows what you are talking about, and then investigate further.

There is no point in memorizing answers to questions. You need to develop your problem-solving skills. In the Oracle environment, that means being able to experiment, to develop test cases. When I interview people, that is what I look for.
Re: Loops [message #652011 is a reply to message #652010] Tue, 31 May 2016 04:03 Go to previous message
Satheesh.A
Messages: 9
Registered: May 2016
Location: Chennai
Junior Member
Thanks Mr.John Watson.. Will do what u said.
Previous Topic: DDL commands
Next Topic: Filler / Bound Filler in External tables
Goto Forum:
  


Current Time: Fri Apr 19 15:10:47 CDT 2024