SELECT REGEXP_SUBSTR(COL,'[A-B]+',COL) AS COL1,REGEXP

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.

Question Posted / sreenivasulu sangatipalli

1 Answers
3086 Views
IBM, Saama Tech, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are all the common sql functions?

1036

How many disk partitions should I have?

991

How can a function retun more than one value in oracle with proper example?

1080

What is difference between table and view?

1065

How to install oracle sql developer?

1055

Does access use sql?

1047

What is memory optimized table?

1049

explain the options of myisamchk to improve the performance of a table. : Sql dba

1022

How many developers work on postgresql?

988

Are subqueries faster than joins?

1024

How many row comparison operators are used while working with a subquery?

1036

Can we use ddl statements in stored procedure?

1154

What is output spooling in sql*plus?

1041

Is keyword pl sql?

1012

What is pl sql architecture?

965