Re: PL/SQL script for Indendted Bill of Material BOM

On Mon, 18 Apr 2005 09:48:23 -0700, Lobbs74 interested us by writing:

> Hi, Does anyone know or have a copy of a PL/sql scritp i can use to

First, I'd take a serious look at the version of Oracle being used, and see whether I could use External Tables.

Second, I'd take a look at Oracle's CONNECT BY clause of the Select statement, and see whether that, together with the level information, could be used to simulate the request.

Then I'd probably look at Oracle's Sample Schema documentation for Oracle9i, and possibly at the Oracle By Example or the Sample Code sections of Oracle's publically available Oracle Technet site to see whether there are examples of the above.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***