Home » SQL & PL/SQL » SQL & PL/SQL » About Procedure
About Procedure [message #213744] Fri, 12 January 2007 03:01 Go to next message
romi
Messages: 67
Registered: October 2006
Member
Hello all,

Can we return more rows by procedure.If yes then how?

Can we write equijoin query in procedure?

Thanks



icon2.gif  Re: About Procedure [message #213760 is a reply to message #213744] Fri, 12 January 2007 03:59 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
if you can do them with SQL you can do them with procedure.
Re: About Procedure [message #213768 is a reply to message #213760] Fri, 12 January 2007 04:24 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, using refcursor.
Yes, why not?
Previous Topic: Need to change table space of existing Index
Next Topic: How to find Grants given on Synonyms.
Goto Forum:
  


Current Time: Wed Dec 07 12:46:43 CST 2016

Total time taken to generate the page: 0.09548 seconds