SQL Snippets ™: Tutorials for Oracle Developers

create table t_1k
(
  key  integer primary key,
  key2 varchar2(10) ,
  m_1  varchar2(4000) ,
  m_2  varchar2(4000)
) ;

begin
  for i in 1 .. 1000 loop
    insert into t_1k values ( i, to_char(i), 'a', 'b' );
  end loop;
end;
/
commit;

create table t_100k
(
  key   number primary key,
  key_1 char(100) ,
  key_2 char(100) ,
  key_3 char(100) ,
  m_1   varchar2(1000)
) ;

begin
  for i in 0 .. 99999 loop
    insert into t_100k values
    ( i,
      to_char(i),
      to_char( mod(i-1,1000) + 1 ),
      to_char( trunc(i,-3) ),
      'a'
    );
  end loop;
end;
/
commit;

execute dbms_stats.gather_schema_stats( ownname => null )

column key_1 format a5 truncate
column key_2 format a5 truncate
column key_3 format a5 truncate

column m_1 format a3
column m_2 format a3
column m_3 format a3