Oracle driving me bonkers [serious]

[chocoloco]

Does anyone know how do you write a User Defined Function in Oracle 9.2 that returns a table ?

[grilkip]

Isn't that a stored procedure?

[chocoloco]

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.

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.

[grilkip]

I've worked with PL/SQL in Oracle but only with triggers. I will see if I can dig anything up on functions.