-
In Oralce 8.1.6.3.4 on Windows NT 4.0 SP6a.
select owner, object_name, object_type
from dba_objects
where owner = 'XXX'
and upper(object_name) = 'AAAAAABBBB';
It returns 2 rows, one is in uppercase, the other one is in capital lowercase. The output looks like:
OWNER OBJECT_NAME OBJECT_TYPE
---------- ---------------------------------------- ------------------
XXX AAAAAABBBB TABLE
XXX AaaaaaaBbbb TABLE
What's wrong with Oracle dictionary?
Is there any bug to be applied?
Any help will be appreciated.
Thanks.
Queyon
Queyon Zeng
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
|