CREATE TABLE rpt_master
( rep_id VARCHAR2 (10),
name VARCHAR2 (100),
date_format VARCHAR2 (20),
number_format VARCHAR2 (2),
filename VARCHAR2 (50),
deliminator VARCHAR2 (5),
table_name VARCHAR2 (50),
where_cond VARCHAR2 (500),
filename_date VARCHAR2 (20)
)
/
CREATE TABLE RPT_FIELDS
( rep_id VARCHAR2(10),
header_text VARCHAR2(50),
orderby NUMBER,
column_name VARCHAR2(50)
)
/