Hello Experts,
I am using database 11g.
I have the following table DEPT
Column:: DEPT_ERR varchar2
Case: I am performing a set of validation on record, if the record contains multiple errors then needs to concatenate all the errors in the single column.
IF condition1= 'Wrong value' THEN
END IF;
PROCEDURE.....
L_Text = ‘Dept Invalid’
BEGIN
update DEPT
set DEPT_ERR = DEPT_ERR ||nvl(DEPT_ERR , L_Text);
WHERE …;
END;
Output
DEPT_ERR
Wrong value Dept Invalid
Is the above code right or did i missed somthing?
Can somebody help me. Is there any other way of doing this?