Database Administration (MOSC)

MOSC Banner

number of rows

edited Jul 17, 2014 1:35AM in Database Administration (MOSC) 2 commentsAnswered ✓

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 :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center