Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / kvikas2056


I have following column in the table. col1 1 a b c 2 3 d and I want to display it as nu..

Answer / 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

More SQL PLSQL Interview Questions

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

0 Answers  

Explain the the delete statements in sql?

0 Answers  

What is sql and explain its components?

0 Answers  

Is not null in sql?

0 Answers  

What is a stored procedure ?

9 Answers  




What is the use of sqlerrd 3?

0 Answers  

What is procedure function?

0 Answers  

Why are cursors used?

0 Answers  

What does <> sql mean?

0 Answers  

Can you have a foreign key without a primary key?

0 Answers  

What is a primary key called that is made up of more than one field?

0 Answers  

What operating systems are supported by oracle sql developer?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories