Answer / gopi muluka

DECLARE @STR VARCHAR(50),
@Char VARCHAR(10),@N INT, @CNT INT
DECLARE @TAB TABLE (VAL VARCHAR(30), CNT INT)

SET @STR='A,B,C,D,E,F,C,A,S,K,C,B'
SET @CHAR=''
SET @N=1
SET @CNT=1
WHILE @N>0
BEGIN
PRINT @STR
SET @CHAR=SUBSTRING(@STR,1,CHARINDEX(',',@STR)-1)
IF NOT EXISTS(SELECT 1 FROM @TAB WHERE VAL=@CHAR)
INSERT @TAB VALUES (@CHAR,@CNT)
SET @STR=SUBSTRING(@STR,CHARINDEX(',',@STR)+1,115)
IF CHARINDEX(@CHAR,@STR)>0
BEGIN
UPDATE @TAB
SET CNT=CNT+1
WHERE VAL=@CHAR
END
SET @N=CHARINDEX(',',@STR)
PRINT @N
END
SELECT * FROM @TAB

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

What is an inconsistent dependency?

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

Are sql views compiled?

1 Answers  

---

What is record in pl sql?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

what is a join? : Sql dba

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

---