-
Originally posted by jmodic
That should probably read:
Code:
... and
rownum >= 1 )
...
Damn you and your Slovenian sharp eyes. I suppose so.
-
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?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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!
-
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;
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|