copy_tables.sql

OReilly Oracle PL SQL Programming第4版源代码

/*
  || COPY_TABLES.sql
  || Create tables for demonstration of when row level
  || and statement level triggers fire
*/
-- create a table to copy rows from
CREATE TABLE from_table
(col1 NUMBER);

-- create a table to copy rows into
CREATE TABLE to_table
(col1 NUMBER);

-- populate the copy from table
BEGIN
  FOR counter IN 1..10 LOOP
    INSERT INTO from_table VALUES(counter);
  END LOOP;
END;
/

COMMIT;


/*======================================================================
| Supplement to the third edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2002 O'Reilly &
| Associates, Inc. To submit corrections or find more code samples visit
| http://www.oreilly.com/catalog/oraclep3/
*/