📄 copy_tables.sql
字号:
/*
|| 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/
*/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -