create table ß (lowercase /* column named as an indicator */ int)
Table created.
create table ẞ (uppercase /* column named as an indicator */ int)
Table created.
select
count(distinct upper(table_name)), count(distinct lower(table_name))
from
user_tables
| COUNT(DISTINCTUPPER(TABLE_NAME)) | COUNT(DISTINCTLOWER(TABLE_NAME)) | 2 | 1 |
|---|
select
(select column_name from user_tab_columns where user_tab_columns.table_name = user_tables.table_name) as indicator,
table_name, upper(table_name), lower(table_name),
case when table_name=lower(table_name) then 'x' end as is_lower, case when table_name=upper(table_name) then 'x' end as is_upper,
case when upper(lower(table_name))=upper(table_name) then 'x' end as is_upper_lower, case when lower(upper(table_name))=lower(table_name) then 'x' end as is_lower_upper
from
user_tables
| INDICATOR | TABLE_NAME | UPPER(TABLE_NAME) | LOWER(TABLE_NAME) | IS_LOWER | IS_UPPER | IS_UPPER_LOWER | IS_LOWER_UPPER | LOWERCASE | ß | ß | ß | x | x | x | x | UPPERCASE | ẞ | ẞ | ß | - | x | - | x |
|---|