oracle order by problem : LUSENET : DBAzine : One Thread


I've got a problem with order by clause in oracle. I have to order the result of a query like this: select col1, col2, col3 from table order by col1='value1', col2; so the first lines of the results will be the rows, where col1 = 'value1'. It works in mysql, postgresql, etc, but it doesn't work in oracle...

Is it possible some way?

Thanks in advance, Csaba

-- Csaba Sólya (, April 24, 2004

Moderation questions? read the FAQ