Home » SQL & PL/SQL » SQL & PL/SQL » procedures using cursors
procedures using cursors [message #343425] Wed, 27 August 2008 04:50 Go to next message
rahulsql
Messages: 18
Registered: August 2008
Junior Member
i need procedures that uses cursors to fetch rows.i need simple code how to write cursor inside procedure.ex code for to fetch rows from emp table and insert this records into another table
Re: procedures using cursors [message #343433 is a reply to message #343425] Wed, 27 August 2008 05:10 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Please go through the link below You will get a lot of example there.
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/01_oview.htm#740

And yes, one more thing , before posting your queries search in Google.If still it doesnt help then only post your queries.

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


Regards,
Oli

[Updated on: Wed, 27 August 2008 05:29]

Report message to a moderator

Re: procedures using cursors [message #343444 is a reply to message #343425] Wed, 27 August 2008 05:31 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: single column data
Next Topic: how to fined total hour between a date
Goto Forum:
  


Current Time: Sat Dec 10 02:53:56 CST 2016

Total time taken to generate the page: 0.10656 seconds