-
IS THERE ANY WAY TO TRIGGER LOW COLLATION OF NULLS IN ORACLE (Maybe an environment variable). eg. select * from table order by column2 - where table contains 3 records:
A NULL
A XXXX
B NULL
displays:
A XXXX
A NULL
B NULL
but required order is (As per INFORMIX):
A NULL
A XXX
B NULL
NOTE: Obviously this is a simplified case
autouser
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
|