Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
checking for lower case
create table t1 ( a varchar(100) )\\ insert into t1 (a) values ( 'A' )\\ insert into t1 (a) values ( 'a' )\\ insert into t1 (a) values ( 'å' )\\ insert into t1 (a) values ( 'æ' )\\ select (case when a = upper( a ) then a || ' Is Upper' else a || ' Has lower' end) as r_upper, (case when not regexp_like(a, '[a-z]', 'c') then a || ' Is Upper' else a || ' Has lower' end) as r_reg from t1\\ drop table t1
run
|
edit
|
history
|
help
0
Srinivas
DBMS
Srinivas
Srinivas
Reverse of a number
Srinivas
Test
add pl/sql
Aditya ADMT
Srinivas