Re: HELP!!! SORT ORDER

Serge,

If you do not use "ORDER BY" clause the order of the rows that are selected from DB
is determined based on the sequence in which these rows were inserted into DB. If you have 2 different databases then it is possible. The rows could be inserted in such order:

On UNIX
1 ABTYP
2 AB3050

On NT4
1 AB3050
2 ABTYP If you want the different order then use "ORDER BY CLAUSE" with a column name. All the rows will be sorted based on this specified column independently of the sequence of the insertion:

On UNIX
SELECT bla bla bla
ORDER BY col1

ABTYP
AB3050

On NT4
SELECT bla bla bla
ORDER BY col1

ABTYP
AB3050

Good luck:)

-- 
Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com


Serge Nantel wrote:


> 

> I have 2 Oracle database one running on UNIX and one running on NT4


> 

> I run a select and the result is not the same

> 

> On UNIX                        On NT4

> Select bla bla bla              Select bla bla bla

> ABTYP                            AB3050

> AB3050                           ABTYP

> 

> On UNIX the sort is not in the same order as the one on NT4 ???

> 

> thank you kindly

> Serge

> snantel_at_virtuo-cio.com