From oracle-l-bounce@freelists.org Wed Jun 16 17:37:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5GMb6M03084 for ; Wed, 16 Jun 2004 17:37:16 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5GMau603048 for ; Wed, 16 Jun 2004 17:37:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 08CAD72C28D; Wed, 16 Jun 2004 17:21:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29410-77; Wed, 16 Jun 2004 17:21:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4089C72C11C; Wed, 16 Jun 2004 17:21:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 16 Jun 2004 17:19:52 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8577D72C02D for ; Wed, 16 Jun 2004 17:19:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29164-57 for ; Wed, 16 Jun 2004 17:19:51 -0500 (EST) Received: from nwkea-mail-1.sun.com (nwkea-mail-1.sun.com [192.18.42.13]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0E6E072C013 for ; Wed, 16 Jun 2004 17:19:51 -0500 (EST) Received: from phys-giza-1 ([129.147.4.102]) by nwkea-mail-1.sun.com (8.12.10/8.12.9) with ESMTP id i5GMeLJ6004969 for ; Wed, 16 Jun 2004 15:40:21 -0700 (PDT) Received: from conversion-daemon.giza-mail1.Central.Sun.COM by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0HZF00F01ALO77@giza-mail1.Central.Sun.COM> (original mail from Michael.Spalinger@Sun.COM) for oracle-l@freelists.org; Wed, 16 Jun 2004 16:40:21 -0600 (MDT) Received: from sun.com (tutelage [129.147.51.9]) by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0HZF000KHAY87B@giza-mail1.Central.Sun.COM> for oracle-l@freelists.org; Wed, 16 Jun 2004 16:39:44 -0600 (MDT) Date: Wed, 16 Jun 2004 16:39:44 -0600 From: Mike Spalinger Subject: Re: SQL Loader Question on 8.1.7 In-reply-to: To: oracle-l@freelists.org Message-id: <40D0CC30.6090104@sun.com> MIME-version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20040414 References: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2853 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Michael.Spalinger@Sun.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Kevin, I think there's an example of this in SQL*Loader Case Study 7 in the 9.2 Utilities Guide. You can use package variables and triggers to save your dept numbers. Mike Kevin Lange wrote: > Evening; > I figured if anyone would know ... you all would. Here is a simple > example given in the Oracle SQLLDR manual: > > You have conditional data in a singl file to be loaded into different > tables: > > 1 50 Manufacturing > 2 1100 Smith > 2 1200 Snyder > 1 60 Shipping > 2 1121 Stevens > > > It gets more difficult when you ask the question .... Can you carry the > data from one of the When sections over into another section ?? i.e. Is > there a way to make a presistant variable that is set in one section and > then used in another section ?? > > Using the sample above, we need to have the "Department Number" (depno) > inserted into the EMP table without having to add it to each individual > record where recid = 2 since it is already on the record where recid = 1. > > > Any help or direction to go for samples if possible would be greatly > appreciated. > > Kevin ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------