Hints and tricks for Oracle and other stuff...

procedure LogCreateTables as
v_vred varchar2(4000);
v_ime varchar2(4000);
begin
  -- Test statements here
  for r in (select t.table_name
            from user_tables t
            order by t.table_name) loop
htp.p('create table log$'r.table_name' as select * from 'r.table_name' where 1=2;');
htp.p('alter table log$'r.table_name' add logczsp date not null;');
htp.p('alter table log$'r.table_name' add logoper varchar2(50) not null;');
htp.p('alter table log$'r.table_name' add logakcija varchar2(50) not null;');
  end loop;
end;

# posted by Domen Dolar @ 11:15 AM