oracle - Return N columns from a table function

Question

I need to implement a table function, which I will submit a request with an unknown number of columns. It looks like:

SELECT * from TABLE (function())

where function, for example'SELECT x, y FROM z. I don't know how do this, so I'd like to hear some sort of way to solve, just as an idea.

Answer 1

I think what you are asking is you are getting multiple rows in the o/p when you are using

the function in select statement .

if i create a function as follows:

create or replace function get1job

(id in varchar2)

return varchar2 is

tittle jobs.JOB_TITLE%type;

begin

select job_title  into tittle from jobs where job_id=id;

return tittle;

end get1job;

and use it in select statement .

i will write :

select get_job('AD_PRES') from dual;

i will get only one row

if i write :

select get_job('AD_PRES') from jobs;

the number of rows displayed will be equal to the number of rows in the table jobs.