implicit trimming of trailing spaces for bulk collect
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Fri, 1 Apr 2022 08:17:48 +0300
Message-ID: <CA+riqSWuegHZkGbo7QspBottjRXu2u77fmsc=vwhzsXMEW5iQQ_at_mail.gmail.com>
Hello,
Date: Fri, 1 Apr 2022 08:17:48 +0300
Message-ID: <CA+riqSWuegHZkGbo7QspBottjRXu2u77fmsc=vwhzsXMEW5iQQ_at_mail.gmail.com>
Hello,
DECLARE
TYPE rt_type IS RECORD (col1 VARCHAR2(6));
TYPE rec_rt_type IS TABLE OF rt_type;
v_c2 rec_rt_type;
CURSOR c2 IS SELECT col1 FROM mytable;
BEGIN
OPEN c2;
LOOP
FETCH c2 BULK COLLECT INTO v_c2;
dbms_output.put_line('Value is: "' || v_c2(1).col1|| '" Length is : '
||length(v_c2(1).col1));
EXIT
WHEN c2%NOTFOUND;
END LOOP;
CLOSE c2;
END;
/
THank you
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 01 2022 - 07:17:48 CEST