drop table q1 purgeORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table q1
(code varchar2(20)
)Table created.
insert into q1 values ('A1')1 row(s) inserted.
insert into q1 values ('A2')1 row(s) inserted.
insert into q1 values ('Az')1 row(s) inserted.
insert into q1 values ('AK')1 row(s) inserted.
insert into q1 values (10)1 row(s) inserted.
insert into q1 values ('oh')1 row(s) inserted.
commitStatement processed.
select code,
case
when regexp_like (code, '^[[:alnum:]]+$') then 'Alpha Numeric'
when regexp_like (code, '^[[:upper:]]+$') then 'Upper'
when regexp_like (code, '^[[:digit:]]+$') then 'Numeric'
when regexp_like (code, '^[[:lower:]]+$') then 'lower'
end dat_type
from q1| CODE | DAT_TYPE | A1 | Alpha Numeric | A2 | Alpha Numeric | Az | Alpha Numeric | AK | Alpha Numeric | 10 | Alpha Numeric | oh | Alpha Numeric |
|---|
select code,
case
when regexp_like (code, '^[[:upper:]]+$') then 'Upper'
when regexp_like (code, '^[[:alnum:]]+$') then 'Alpha Numeric'
when regexp_like (code, '^[[:digit:]]+$') then 'Numeric'
when regexp_like (code, '^[[:lower:]]+$') then 'lower'
end dat_type
from q1| CODE | DAT_TYPE | A1 | Alpha Numeric | A2 | Alpha Numeric | Az | Alpha Numeric | AK | Upper | 10 | Alpha Numeric | oh | Alpha Numeric |
|---|
select code,
case
when regexp_like (code, '^[[:upper:]]+$') then 'Upper'
when regexp_like (code, '^[[:digit:]]+$') then 'Numeric'
when regexp_like (code, '^[[:alnum:]]+$') then 'Alpha Numeric'
when regexp_like (code, '^[[:lower:]]+$') then 'lower'
end dat_type
from q1| CODE | DAT_TYPE | A1 | Alpha Numeric | A2 | Alpha Numeric | Az | Alpha Numeric | AK | Upper | 10 | Numeric | oh | Alpha Numeric |
|---|
select code,
case
when regexp_like (code, '^[[:upper:]]+$') then 'Upper'
when regexp_like (code, '^[[:digit:]]+$') then 'Numeric'
when regexp_like (code, '^[[:lower:]]+$') then 'lower'
when regexp_like (code, '^[[:alnum:]]+$') then 'Alpha Numeric'
end dat_type
from q1| CODE | DAT_TYPE | A1 | Alpha Numeric | A2 | Alpha Numeric | Az | Alpha Numeric | AK | Upper | 10 | Numeric | oh | lower |
|---|