Damn you and your Slovenian sharp eyes. I suppose so.Quote:
Originally posted by jmodic
That should probably read:
Code:... and
rownum >= 1 )
...
Printable View
Damn you and your Slovenian sharp eyes. I suppose so.Quote:
Originally posted by jmodic
That should probably read:
Code:... and
rownum >= 1 )
...
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? :pQuote:
Originally posted by slimdave
Damn you and your Slovenian sharp eyes. I suppose so.
Oh yes, I remember that very well indeed.Quote:
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? :p
Ah, happy days!
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
What about avoiding explicit DISTINCT and using it implicitly? Something like:
Code:select invoicenumber from invoices
where hnum='2222222'
UNION
select invoicenumber from invoices
where 1=2
order by invoicenumber desc;
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>
Well, that's it then -- time to get patching and upgrading. To my own recollection, 8.1.5 sucked.
everybody, thank you for the interest and effort.
-Raja