Home » SQL & PL/SQL » SQL & PL/SQL » using cursor (oracle 10g)
using cursor [message #384324] Tue, 03 February 2009 05:39 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
can anyone show a procedure how to
1)declare cursor for getting records for a given empno form emp table.
2)open cursor
3)fetch values
4)replace empno with new empno
5)insert it
6)loop again if any more records exist
Re: using cursor [message #384327 is a reply to message #384324] Tue, 03 February 2009 05:48 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Show us what you did we are here to help you but not to make your homework.

A good reading:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: Urgent help in Extracting numbers only
Next Topic: A list of Mounth
Goto Forum:
  


Current Time: Sat Dec 10 18:41:12 CST 2016

Total time taken to generate the page: 0.25339 seconds