Home » SQL & PL/SQL » SQL & PL/SQL » What way Procedure are better then Function for Select statement
What way Procedure are better then Function for Select statement [message #246519] Thu, 21 June 2007 03:33 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
For Select statement we are using Procedure (with the help of Bind variable we get the out put in sql prompt) instead of Function.
What way Procedure are better then Function .Will it reduce open_cursors ?

by
sbmk_design
Re: What way Procedure are better then Function for Select statement [message #246524 is a reply to message #246519] Thu, 21 June 2007 03:54 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference between function and procedure but the use in SQL statement.

Regards
Michel
Previous Topic: Issue with a query
Next Topic: Rows to column conversion, based on date column
Goto Forum:
  


Current Time: Sun Dec 04 18:29:08 CST 2016

Total time taken to generate the page: 0.11003 seconds