I have following column in the table.
col1
1
a
b
c
2
3
d
and I want to display it as
num chars
1 a
2 b
3 c
4 d
numbers in one column and letters in another column.
Answer Posted / sreenivasulu sangatipalli
SELECT REGEXP_SUBSTR(COL,'[A-B]+',COL) AS COL1,REGEXP_SUBSTR(COL,'[1-9]+',COL) AS COL2 FROM TEST10;
SELECT * FROM (SELECT CASE WHEN REGEXP_LIKE(COL,'[A-Z]+','i') THEN COL END ALPHS,
CASE WHEN REGEXP_LIKE(COL,'[0-9]+') THEN COL END NUMBS
FROM TEST10 ) where ALPHS is not null OR NUMBS is not null;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does join work in sql?
What is the purpose of cursors in pl/sql?
What is cartesian join in sql?
What does the acronym acid stand for in database management?
What is 19 null in sql?
what is a field in a database ? : Sql dba
What is the basic form of sql query?
What is file based approach?
how to write date and time literals? : Sql dba
what is an extent ? : Sql dba
What is a natural join?
What is rank dense_rank and partition in sql?
difference between anonymous blocks and sub-programs.
What is difference between inner join and cross join?
What is primary key in db?