SQL Plus - Implicit Cursor attributes

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 38 of 132

Implicit Cursor attributes

Total Answers and Comments: 4

Last Update: November 03, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 24, 2005 19:35:54

PALLAVI

RE: Implicit Cursor attributes

SQL FOUND SQL NOT FOUND SQL IS OPEN SQL ROW COUNT

Is this answer useful? Yes | No

May 31, 2006 08:45:08

narasimhulu

Member Since: May 2006 Contribution: 4

RE: Implicit Cursor attributes

hai

Sorry to tell you SQL IS OPEN is not a valid implicit cursor attribute.

You will have SQL FOUND SQL NOT FOUND SQL ROW COUNT as implicit cursor attirbutes

Is this answer useful? Yes | No

December 07, 2006 06:42:37

rampratap409

Member Since: September 2006 Contribution: 111

RE: Implicit Cursor attributes

sql isopen is there but it will always return false for implicit cursor

Is this answer useful? Yes | No

November 03, 2008 09:15:50

Haraprasad

Member Since: November 2008 Contribution: 1

RE: Implicit Cursor attributes

SQL ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank