PL/SQL Stored Functions Question

Hi, all.

I am new to Oracle and having installed it on my Linux server I am pretty happy with it so far. However, I still can't figure out how to make a stored function that would return a SQL query result (I guess that would be a cursor). Can anyone post a small example of such a function? For example, I want a function which recieves one parameter: soc_sec_num and returns the following query result:

select lname, fname from employee where ssn=soc_sec_num

 Thanks! Received on Mon Nov 01 1999 - 07:35:59 CST