Hi!

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 (scsb@freemail.hu), April 24, 2004