Answer Posted / 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 scalar data type in pl sql?

1053

---

Can you join a table to itself?

1105

---

What is sql partition function?

1182

---

Does postgresql run on the cloud?

1125

---

is mysql query is case sensitive? : Sql dba

1073

---

What are packages in pl sql and also explain its advantages?

1012

---

How to use distinct and count in sql query? Explain

998

---

Show how functions and procedures are called in a pl/sql block.

1095

---

Can sql function call stored procedure?

986

---

What is the maximum database size for sql express?

1006

---

what is a view? : Sql dba

1063

---

What is serial sql?

954

---

Explain the advantages and disadvantages of stored procedure?

1127

---

What are the various restrictions imposed on view in terms of dml?

955

---

Explain what is rdbms?

1017

---