Re: Is it possible in SQL or PL/SQL

"toto" <parag9i_at_gmail.com> a écrit dans le message de news: 1144133925.450121.252140_at_z34g2000cwc.googlegroups.com...
| Hi,
|
| I am using Oracle 9.2 database. I am having following data
|
| drop table toto;
| create table toto
| (
| r char(10)
| )
| organization external
| (
| type oracle_loader
| default directory data_dir
| access parameters
| (
| records delimited by newline
| logfile data_dir:'toto.log'
| )
| location ('pp.sysout')
| )
| reject limit unlimited
| /
|
| In pp.sysout I am having following data
|
| A
| B
| C
| D=10
| E
| F
| G
| A
| B
| C
| D=20
| E
| F
| G
| H
| I
| A
| B
| C
| D=20
| E
| F
| G
| H
| A
| B
| C
| D=30
| E
| F
| G
| H
|
| I want set of results in a different spool file starting from 'A' upto
| next 'A'
| where value of 'D' is unique.
|
| For e.g.
| 1. spool file xxx.1 will contain
| A
| B
| C
| D=10
| E
| F
| G
|
| 2. spool file xxx.2 will contain ( it will have two sets because D=20
| appearing
| twice in data )
|
| A
| B
| C
| D=20
| E
| F
| G
| H
| I
| A
| B
| C
| D=20
| E
| F
| G
| H
|
| 3. spool file xxx.3 will contain
|
| A
| B
| C
| D=30
| E
| F
| G
| H
|
| Kindly let me know is it possible to do that ? if yes pl show me how.
|
| thanks & regards
| pjp
|

I answered you on AskTom:

http://asktom.oracle.com/pls/ask/f?p=4950:61:11624793246688494627::::P61_ID:127312348064#61079610047885

Regards
Michel Cadot Received on Thu Apr 06 2006 - 10:43:50 CDT