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
3062 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

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

996

What is left join example?

936

Which data type is a composite type?

976

What is the benefit of foreign key?

1010

how can we know the number of days between two given dates using mysql? : Sql dba

1031

What are the events on which a database trigger can be based?

1170

How many sql commands are there?

1102

Are views faster than queries?

980

What is sqlite format?

1179

Can we insert data in view?

950

How do I view a sql trace file?

1008

What is mutating error?

954

Which is better varchar or nvarchar?

980

Should I use mbr or gpt?

1013

List the ways to get the count of records in a table?

896