Re: pl/sql function help

sdm wrote:
> I'm new to SQL and brand new to PL/SQL. I probably would not have ventured
> into PL/SQL except that in a report I'm writing I discovered that I will
> need to write a PL/SQL function that will retrieve items and return them as
> a comma-separated values list. I've been searching the Oracle books online
> and I have a copy of Oracle Press' PL/SQL 101 but I can't find a good
> example of how to do this. I'd like to see not just the syntax of how to
> write, but also see a real-world example.
>
> A 2nd problem with this is that, in the comma separated list, I want to see
> POs (purchase orders) for certain SKUs but only when the SKUs have a certain
> sort code. This info is in 2 different tables and no examples I've seen show
> how to query from more than one table.
>
> Can someone help me or at least point me towards a reference that is going
> to help me learn what I need to learn? Thanks!
>
>
You don't indicate which version of Oracle you have, nor to what purpose your CSV file will be put, but 9i has a terrific new feature for all of us who think of CSVs as the only solution. Its the Extraction, Transformation, and Loading (ETL) toolkit. You might find what you're looking for in this.

For an article that appeared in Oracle Magazine, check out:

http://www.oracle.com/oramag/oracle/01-sep/index.html?o51o9i.html Received on Fri Jan 10 2003 - 19:28:41 CET