be carefull, dumb user question:
I have to load 4.2e data records in different tables , usually for a
single table i would use sqlloader. But in this case i need some
additional logic to manipulate the data records.
Please, can somene point me into the right direction ?

Thanks in advance

On 6 Dec, 17:31, dx111ge <sven.andr...@gmail.com> wrote:
> be carefull, dumb user question:
> I have to load 4.2e data records in different tables , usually for a
> single table i would use sqlloader. But in this case i need some
> additional logic to manipulate the data records.
> Please, can somene point me into the right direction ?
>
> Thanks in advance

Oracle version?

Depending on the answer to the above, look into using External Tables:

http://download.oracle.com/docs/cd/B....htm#sthref777

HTH

-g

On 6 Dez., 18:37, gazzag <gar...@jamms.org> wrote:
> On 6 Dec, 17:31, dx111ge <sven.andr...@gmail.com> wrote:
>
> > be carefull, dumb user question:
> > I have to load 4.2e data records in different tables , usually for a
> > single table i would use sqlloader. But in this case i need some
> > additional logic to manipulate the data records.
> > Please, can somene point me into the right direction ?
>
> > Thanks in advance
>
> Oracle version?
>
> Depending on the answer to the above, look into using External Tables:
>
> http://download.oracle.com/docs/cd/B.../b14220/schema...
>
> HTH
>
> -g

oracle 10.2.3 on windows server

Thanks

On Dec 6, 12:02 pm, dx111ge <sven.andr...@gmail.com> wrote:
> On 6 Dez., 18:37, gazzag <gar...@jamms.org> wrote:
>
>
>
>
>
> > On 6 Dec, 17:31, dx111ge <sven.andr...@gmail.com> wrote:
>
> > > be carefull, dumb user question:
> > > I have to load 4.2e data records in different tables , usually for a
> > > single table i would use sqlloader. But in this case i need some
> > > additional logic to manipulate the data records.
> > > Please, can somene point me into the right direction ?
>
> > > Thanks in advance
>
> > Oracle version?
>
> > Depending on the answer to the above, look into using External Tables:
>
> >http://download.oracle.com/docs/cd/B.../b14220/schema...
>
> > HTH
>
> > -g
>
> oracle 10.2.3 on windows server
>
> Thanks- Hide quoted text -
>
> - Show quoted text -

It also depends upon what 'logic' you need, as SQL*Loader can load
multiple tables from a single control file/data file. You should look
at:

$ORACLE_HOME/rdbms/demo/ulcase5.ctl

to get an idea of how to do this and what logic is available. Also
peruse:

http://download.oracle.com/docs/cd/B...e.htm#i1005798


David Fitzjarrell