Re: pl/sql function help

Try

create or replace function fn_return_comma return varchar2 as cursor c is

• replace with your sql select table_name from user_tables;

vret varchar2(1000);

begin

for vrec in c loop

    vret := vret || ', ' || vrec.table_name end loop;

vret := ltrim(vret, ', ');

return vret

end;

For the second part of the question, look up joins in any SQL book.

• rajXesh

--

All you need in this life is ignorance and confidence, and then success is sure. -- Mark Twain (1835 - 1910)

Posted via http://dbforums.com Received on Thu Jan 09 2003 - 18:55:45 CET