Student Reviews
( 5 Of 5 )
1 review
Video of 81/125 Oracle PLSQL: Design consideration / Bulk Binding 2 in Oracle PL/SQL course by khaled alkhudari channel, video No. 81 free certified online
Learn Oracle PLSQL
EXAM 1Z0-144
Bulk Binding
Bulk collect
begin
dbms_output.put_line(sqlerrm (-12899));
end;
-------------------------------------------------------------
--------------------------------------------------------------
drop table ename;
create table ename
as select distinct first_name from employees;
select first_name
from ename;
declare
type ename_t is table of varchar2(100);
ename_table ename_t:ename_t();
c number:0;
errors number;
begin
for i in (select from ename )
loop
c:c+1;
ename_table.extend;
ename_table(c):i.first_name;
end loop;
forall i in ename_table.first ename_table.last save exceptions
update ename
set first_namefirst_name ' to be added:)' --14 char
where first_nameename_table(i);
exception
when others then
errors : sql%bulk_exceptions.count;
dbms_output.put_line ('The total number of errors occured are ' errors);
for j in 1errors loop
dbms_output.put_line ('The error iteration is '
sql%bulk_exceptions(j).error_index
' and the error code is '
sql%bulk_exceptions(j).error_code
' and the error message is '
sqlerrm ( -sql%bulk_exceptions(j).error_code)
);
end loop;
end;
select from ename
-----------------------------
drop table ename;
create table ename
as select distinct first_name from employees;
select first_name
from ename;
declare
type ename_t is table of varchar2(100);
ename_table ename_t:ename_t();
c number:0;
errors number;
begin
/
for i in (select from ename )
loop
c:c+1;
ename_table.extend;
ename_table(c):i.first_name;
end loop;
/
select first_name bulk collect into ename_table
from ename;
forall i in ename_table.first ename_table.last save exceptions
update ename
set first_namefirst_name ' to be added:)' --14 char
where first_nameename_table(i);
exception
when others then
errors : sql%bulk_exceptions.count;
dbms_output.put_line ('The total number of errors occured are ' errors);
for j in 1errors loop
dbms_output.put_line ('The error iteration is '
sql%bulk_exceptions(j).error_index
' and the error code is '
sql%bulk_exceptions(j).error_code
' and the error message is '
sqlerrm ( -sql%bulk_exceptions(j).error_code)
);
end loop;
end;
select from ename