DDL

/* VIEW1: reference list */

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