Harpreet Dhaliwal wrote:
> lately I have been looking at difference between a Stored
> Proc and User Defined Functions in other RDBMS like Sql
> Server / Oracle.
Nomenclature varies wildly between different Database
Management Systems. Be careful.
The SQL standard (2005) speaks of "SQL-invoked
Hi,
lately I have been looking at difference between a Stored Proc and User
Defined Functions in other RDBMS like Sql Server / Oracle.
However, in postgresql, I think Stored Procs are wrapped around in User
Defined functions, if I am not wrong.
The following is the list of main differences b/w a St
