Re: pl/sql function help

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Fri, 10 Jan 2003 16:11:01 GMT
Message-ID: <pgCT9.3221$8V5.715629_at_news1.telusplanet.net>


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!

I find tahiti.oracle.com one of the best online resources for any pl/sql solutions I need, that and the complete oracle reference by Osborne and Jonathan Gennick's excellent book teach yourself pl/sql in 27 days

hth   Received on Fri Jan 10 2003 - 17:11:01 CET

Original text of this message