Friday, June 02, 2006

PL/SQL: String concatenation

FUNCTION dyna_string1(p_string varchar2) RETURN VARCHAR2 IS

t VARCHAR2(2) :=',';
t1 VARCHAR2(2) :='''';
t2 VARCHAR2(32767);
t_check NUMBER(10);
newstring VARCHAR2(32767);

BEGIN

newstring :=p_string;
t_check :=instr(newstring,',');
IF t_check!=0 THEN
t2 := t1tt1;
newstring := replace(newstring,',',t2);
newstring := '('''''newstring''''')';
ELSE
newstring:=newstring;
newstring:='('''''newstring''''')';
END IF;
RETURN newstring;

END dyna_string1;

0 Comments:

Post a Comment

<< Home