number of rows
Hi,
on 12 C ,
I'm following this tutorial :
Setting Up Compression Tiering for Automatic Data Optimization
It says that the following should inser 3500 rows. Why ? How the number of rows is defined ?
Insert about 3500 rows into SCOTT.employee table.
insert into scott.employee (empno, ename, job, mgr, hiredate, sal, comm, deptno)
select empno, ename, job, mgr, hiredate, sal, comm, deptno
from scott.emp;
declare
blowup PLS_INTEGER := 8;
sql_test clob;
begin
for i in 1..blowup
loop sql_test := 'insert /*+ append */ into scott.employee select * from scott.employee';
execute immediate sql_test;
commit;
end loop;
end;
/
=============End of script===============
Personnaly I have :