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
Messages: 500
Registered: December 2008
Senior Member
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: 65133
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

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

Current Time: Wed Aug 16 10:24:14 CDT 2017

Total time taken to generate the page: 0.11004 seconds