Tia,
You could get only one record for each patient, just select the first row or
something like that.
as for createing the file utl_file package is the way to go.
Tom
Ruud Schmeitz <R.Schmeitz_at_MEMIC.UNIMAAS.NL> wrote in message
news:8ca5l1$btk$1_at_rl0001.unimaas.nl...
> Hi readers,
>
> We have an Oracle database which contains a parent table and 15
> child tables (1:n).
> Our clients use specific data-analysis software, which requires a
> flat file as input. This flat file (with only 1 record for every patient)
> should contain the data from the parent table and 1 or more child
> tables.
>
> The question of course is, how to create this flat file ?
> I can't use a SELECT statement for this, because then I get (much)
> more than 1 record for every patient.
>
> Is there an easy way to do this in Oracle ?
>
> Tia,
>
> ============================================================
>
> "Live Long and Prosper" - Spock
> "And let Wisdom be your Guide" - Spock's brother
>
> Ruud Schmeitz
> Universiteit Maastricht
>
>
>
Received on Mon Apr 03 2000 - 18:58:15 CDT
