/* VIEW1: reference list */ CREATE OR REPLACE VIEW view1 AS SELECT * FROM tab1 WHERE f1 BETWEEN 1000 AND 2000 /