order by desc with distinct

[slimdave]

Originally posted by jmodic
That should probably read:

... and
      rownum >= 1 )
...

Damn you and your Slovenian sharp eyes. I suppose so.

[jmodic]

Originally posted by slimdave
Damn you and your Slovenian sharp eyes. I suppose so.

I was only returning you the ball - remember not so long ago you spotted a missing double-singe quotes inside the quoted string (hm, should I read/rewrite that agin immediately?) in one of my responses?

[slimdave]

Originally posted by jmodic
I was only returning you the ball - remember not so long ago you spotted a missing double-singe quotes inside the quoted string (hm, should I read/rewrite that agin immediately?) in one of my responses?

Oh yes, I remember that very well indeed.

Ah, happy days!

[rajabalachandra]

sorry, no luck.
what i got is...

1 select*
2 from
3 (
4 select distinct
5 invoicenumber
6 from
7 invoices i
8 where
9 hnum='2222222' and
10 rownum >= 1 )
11 order by
12* invoicenumber desc
SQL>
SQL> /
select*
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

[jmodic]

What about avoiding explicit DISTINCT and using it implicitly? Something like:

select invoicenumber from invoices
 where hnum='2222222'
UNION
select invoicenumber from invoices
 where 1=2
order by invoicenumber desc;

[rajabalachandra]

oops! it's even worse.

SQL> select invoicenumber from invoices
2 where hnum='2222222'
3 UNION
4 select invoicenumber from invoices
5 where 1=2
6 order by invoicenumber desc;
select invoicenumber from invoices
*
ERROR at line 4:
ORA-00600: internal error code, arguments: [12451], [], [], [], [], [], [], []

SQL>

[slimdave]

Well, that's it then -- time to get patching and upgrading. To my own recollection, 8.1.5 sucked.

[rajabalachandra]

everybody, thank you for the interest and effort.

-Raja