Does anyone know how do you write a User Defined Function in Oracle 9.2 that returns a table ?
Printable View
Does anyone know how do you write a User Defined Function in Oracle 9.2 that returns a table ?
Isn't that a stored procedure?
No its not. A user defined function can be references inside a sql statement, a Sproc cannot be referenced like that.Quote:
Originally Posted by grilkip
For Example ...
Select * From dbo.udf_GetEmployees(@Section)
is a valid Sql statement where dbo.udf_GetEmployees is a Sql server user defined function and @Section is the parameter to that function. If this was a Sproc, you could not use it like that.
I am very good at Sql Server, just have to work on Oracle thesedays and struggling to find the similar functionality in oracle. I know you can create UDFs in Oracle 9.2, just do not know the syntax and there is very poor documentation (whatever available) on the internet.
I've worked with PL/SQL in Oracle but only with triggers. I will see if I can dig anything up on functions.