Order of Data Dispaly / printing has changed! [message #407711] |
Thu, 11 June 2009 04:02  |
msmallya77
Messages: 28 Registered: June 2009 Location: Ahmedabad
|
Junior Member |
|
|
This we have obsereved after exporting data from Oracle 9i(9.2.0.4.0) RHL 9 and importing into Oracle 10g (10.2.0.1.0) RHL 5 SE
Can any one tell me why it is happening and solution if any (other than to use order by clause).
Because VB application which was running properly connected to Oracle 9i, now it is displaying with different order while connecting to Oracle 10g. This is happening in Help (list of values), and in reports.
Also from Sql prompt display order changes. Following is the observation.
In oracle 10g
gives the output as
Quote: | c1 c2 c3 c4
-- -- -- --
01 02 01 A1
01 02 02 A2
01 02 03 A3
01 02 04 A4
01 02 05 A5
01 02 06 A6
01 02 07 A7
|
where as after adding exists clause, ie
Quote: |
select * from abc a
where exists (select * from xyz b
where a.c1=b.c1 and
a.c2=b.c2 and
a.c3=b.c3)
|
gives the output as
Quote: | c1 c2 c3 c4
-- -- -- --
01 02 06 A6
01 02 01 A1
01 02 02 A2
01 02 03 A3
01 02 04 A4
01 02 05 A5
01 02 07 A7
|
Secon output is strange, though data returned is ok.
but the Order has changed! (first row)
Also I have checked xyz table
Quote: | select * from xyz where c1='01' and c2='02'
|
gives output as
Quote: | c1 c2 c3 c4
-- -- -- --
01 02 06 A6
01 02 01 A1
01 02 02 A2
01 02 03 A3
01 02 04 A4
01 02 05 A5
01 02 07 A7
|
This means it has returned result in the order of xyz table?
This type of behaviour also noticed in some of the reports printed and displaying List of Values
Any suggestions?
Thanking you in advance.
Murlidhar S Mallya
|
|
|
|
Re: Order of Data Dispaly / printing has changed! [message #407713 is a reply to message #407712] |
Thu, 11 June 2009 04:15   |
msmallya77
Messages: 28 Registered: June 2009 Location: Ahmedabad
|
Junior Member |
|
|
Thanks for your immediate feedback.
But in Oracle 9i we have never observed this behaviour. And there was no issue. Now suddenly the issue has comeup only after changing from 9i to 10g (from application users complaining list of values order has changed as againt earlier used to display).
Regards,
M S Mallya
|
|
|
|
|
|
|