pl/sql sample code wherabouts

Am at a complete loss here:

have to extract data from several tables and reformat (creating further records for given date periods) it before pushing to a file for interface with a nother system.

think I need to create a PACAKAGE to do this:

1. define a record based on my multi table select
2. define a table based on this record
3. create a function(s) to populate table from record
4. create more functions (cursor?!) to manipulate data further

Does anyone know of any sample code libraries where I can maybe see something similar and get a feel for the code structure. Have looked at the oracle example stuff but nothing seems to apply.

Failing that I could maybe seek employment in the refuse collection industry.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 06:35:24 CDT