Oracle ROWSCN Demo - Part 1

oracle-rowscn-demo-part1.sql

set echo off time on timing off linesize 9999 feedback off heading off

-- The following statement might fail if table t does not exist.
drop table t;

/* Create Table wiht ROWDEPENDENCIES enabled */
CREATE TABLE t
(
    x,
    y
)
ROWDEPENDENCIES
AS
    SELECT ROWNUM, substr(table_name,1,10)
      FROM all_tables
     WHERE ROWNUM < 100;