object with mix or lowercase name - Oracle Database Script. 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);
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);