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
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
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
Previous Topic: How to fetch record from cursor and store in memory- URGENT
Next Topic: Group By and (SELECT) , oracle newbie question
Goto Forum:
  


Current Time: Thu Sep 23 12:39:20 CDT 2021