Control Repository - dat_repositories.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: dat_repositories.sql -- -- Author: Steve Roach -- -- Date: 12-FEB-2006 -- -- Version: 01.00 -- -- -- -- Description: Seed data for REPOSITORIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 12-FEB-06 1.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DELETE FROM repositories; INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'CONTROL'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'EXTERNAL FILE'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'EXTERNAL TABLE'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'ODS'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'STAGING'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'VALIDATION'); INSERT INTO repositories VALUES( s_rep.NEXTVAL, 'WAREHOUSE'); COMMIT;