Home » SQL & PL/SQL » SQL & PL/SQL » what r the steps we have to follow after sucessfully compiled the explicit cursor
what r the steps we have to follow after sucessfully compiled the explicit cursor [message #433] Tue, 12 February 2002 00:10 Go to next message
ranjan kumar dash
Messages: 15
Registered: February 2002
Junior Member
if we have a explicit cursor then what are the steps we have to follow after sucessfully compiled athe cursers

Report message to a moderator

Re: what r the steps we have to follow after sucessfully compiled the explicit cursor [message #435 is a reply to message #433] Tue, 12 February 2002 00:57 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
1. open the cursor
2.fetch the data
3. close cursor

Report message to a moderator

Re: what r the steps we have to follow after sucessfully compiled the explicit cursor [message #487 is a reply to message #433] Fri, 15 February 2002 00:06 Go to previous message
Abul Fazal
Messages: 39
Registered: February 2002
Member
Cursor is a part of PL/SQL code. Hence if the PL/SQL Code executes perfectly then the cursor is valid. And by default the cursors we use are Explicit Cursors or External Cursors. Implicit cursors are defined by the system. Please refer to any Pl/SQL Book for additional Info

Report message to a moderator

Previous Topic: How to fetch record from cursor and store in memory- URGENT
Next Topic: Group By and (SELECT) , oracle newbie question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 14:36:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.