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
What is the difference between explicit and implicit cursors in oracle?
What is synonyms?
How can you load microsoft excel data into oracle? : aql loader
What is pragma in sql?
How to read/write files from pl/sql?
What is normalisation in sql?
How many types of cursors supported in pl/sql?
What is a trigger word?
What is a trigger in sql?
When is a declare statement required?
what are the advantages a stored procedure? : Sql dba
How to return multiple rows from the stored procedure?
What is difference between hql and native sql?
What is difference between group by and partition by?
How many commands are there in sql?