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

What are the different parts of a package?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

Types of joins ?

11 Answers   Polaris, TCS,

which types of join is used in sql widely? : Sql dba

0 Answers  

What are the advantages of sql?

0 Answers  




Differentiate pl/sql and sql?

0 Answers  

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

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

0 Answers  

What does count (*) mean in sql?

0 Answers  

What is an implicit commit?

0 Answers  

Why is the cursor important?

0 Answers  

What is a merge query?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories