Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

need to split a string into separate values.

eg.

col1 col2
----------
100 - 'a,b,c'
200 - 'a,x,d,e'
300 - 'c'

result:
value count
-------------
a - 2
b - 1
c - 2
etc.

Question Posted / kavitha.singhn

Answers were Sorted based on User's Feedback



need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c&..

Answer / sharath sn

substr('a,b,c',',',instr('a,b,c',',',1,1)-1)
,substr('a,b,c',instr('a,b,c',',',1,1)+1,instr
('a,b,c',',',2,1)-instr('a,b,c',',',1,1)-1)
,substr('a,b,c',instr('a,b,c',',',2,1)-1);

Is This Answer Correct ?    2 Yes 5 No

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c&..

Answer / sharath

select count(substr('a,b,c',',',instr('a,b,c',',',1,1)-1))
,count(substr('a,b,c',instr('a,b,c',',',1,1)+1,instr
('a,b,c',',',2,1)-instr('a,b,c',',',1,1)-1))
,count(substr('a,b,c',instr('a,b,c',',',2,1)-1)) from
table_name;

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

Can we use pl sql in mysql?

0 Answers  

wtite down triggr not any entry on Sunday

2 Answers   NIT,

Can there be 2 primary keys in a table?

0 Answers  

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

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

0 Answers  

What is the difference between rollback and rollback to statements?

0 Answers  

What is trigger types of trigger?

0 Answers  

what are Dynamic SQL statements?

9 Answers  

What are field types?

0 Answers  

How many joins can you have in sql?

0 Answers  

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

Explain exception handling in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories