Hi all,
is there a trick how to select values of all columns into one single varchar-like variable?
Consider that SOME_TABLE has 5 columns of VARCHAR or NUMBER data type.
DECLARE
vvc_String VARCHAR2(1000);
BEGIN
SELECT * INTO vvc_String FROM SOME_TABLE;
END;
/
Thanks for advice.