Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check the column value are camel case or not

sadasivamSep 8 2021

Hi,
My column values are stored in camel case and few are not in proper camel case.Is there any option to find camel case or not
with t as(
select 'country' camel_business_name from dual
union
select 'countryCode' from dual
union
select 'countryCurrencyValue' from dual
union
select 'CountryRegionalLanguage' from dual--not a camel case
union
select 'countryname' from dual --not a camel case
)
select * from t

Comments
Post Details
Added on Sep 8 2021
5 comments
2,983 views