DBA Hub

📋Steps in this guide1/1

object with mix or lowercase name

set lines 132 pages 1000 col object_name format a30 heading "Object Name"; col object_type format a10 heading "Object|Type"; col created format a30 heading "Created"; col status format a30 heading "Status"; select OWNER,object_name,object_type,created,status from dba_objects where (object_name = lower(object_name) or object_name = initcap(lower(object_name))) and object_name != upper(object_name);

oracle configurationintermediate
by OracleDba
11 views
1

object with mix or lowercase name

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
set lines 132 pages 1000
col object_name format a30 heading "Object Name";
col object_type format a10 heading "Object|Type";
col created format a30 heading "Created";
col status format a30 heading "Status";
select OWNER,object_name,object_type,created,status from dba_objects
where (object_name = lower(object_name) or
object_name = initcap(lower(object_name)))
and object_name != upper(object_name);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!