Re: SQLLDR syntax question
From: gazzag <gareth_at_jamms.org>
Date: Wed, 10 Mar 2010 07:03:10 -0800 (PST)
Message-ID: <2649ea54-8c4d-409c-a8c9-2f9c76371975_at_i25g2000yqm.googlegroups.com>
On 9 Mar, 22:07, ddf <orat..._at_msn.com> wrote:
>
> This all seems to be far more work than necessary simply to enable the
> use of some round-about 'calculation' rather than coding the numeric
> values desired. Yes, it's creative, but having to write a funciton to
> process the mathematical gyrations loaded into the inline data
> unnecessarily complicates a fairly basic data load. Has no one heard
> of Occam's Razor? Paraphrased:
>
> "The simplest solution is the best"
>
> It's simplest in this situation to code 10 rather than 1+9;
> interesting as the other offerings may be they are merely baroque
> additions to what should be a minimalist execution.
>
> David Fitzjarrell
Date: Wed, 10 Mar 2010 07:03:10 -0800 (PST)
Message-ID: <2649ea54-8c4d-409c-a8c9-2f9c76371975_at_i25g2000yqm.googlegroups.com>
On 9 Mar, 22:07, ddf <orat..._at_msn.com> wrote:
>
> This all seems to be far more work than necessary simply to enable the
> use of some round-about 'calculation' rather than coding the numeric
> values desired. Yes, it's creative, but having to write a funciton to
> process the mathematical gyrations loaded into the inline data
> unnecessarily complicates a fairly basic data load. Has no one heard
> of Occam's Razor? Paraphrased:
>
> "The simplest solution is the best"
>
> It's simplest in this situation to code 10 rather than 1+9;
> interesting as the other offerings may be they are merely baroque
> additions to what should be a minimalist execution.
>
> David Fitzjarrell
Agreed. However, we don't really know the OP's requirement and why he perhaps needs a way of loading the data as is.
-g Received on Wed Mar 10 2010 - 09:03:10 CST