EXPORT:V10.02.01 UBDB RUSERS 2048 0 20 0  Sun Jun 24 23:18:9 2007demo_app.dmpd`$     #G###A#d`$     #G###A#+00:00BYTEUNUSED2 INTERPRETED DISABLE:ALL METRICSU METRICSUpre-schema procedural objects and actions PROCACTION BEGIN sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM', inst_scn=>'4696706'); COMMIT; END; METRICEU 16 METRICSUforeign function library names for user METRICEU 16 METRICSUPUBLIC type synonyms METRICEU 16 METRICSUprivate type synonyms METRICEU 16 METRICSUobject type definitions for user METRICEU 16 METRICSUpre-schema procedural objects and actions METRICEU 16 METRICSUdatabase links METRICEU 16 METRICSUsequence numbers CREATE SEQUENCE "DEMO_IMAGES_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 11 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "DEMO_CUST_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "DEMO_ORDER_ITEMS_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "DEMO_ORD_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 11 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "DEMO_PROD_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "DEMO_USERS_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "EAGLE_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "HELP_TABLE_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE METRICEU 24 METRICSUcluster definitions METRICEU 24 METRICSUXDB Schemas by user METRICEU 24 TABLE "DEMO_CUSTOMERS" CREATE TABLE "DEMO_CUSTOMERS" ("CUSTOMER_ID" NUMBER NOT NULL ENABLE, "CUST_FIRST_NAME" VARCHAR2(20) NOT NULL ENABLE, "CUST_LAST_NAME" VARCHAR2(20) NOT NULL ENABLE, "CUST_STREET_ADDRESS1" VARCHAR2(60), "CUST_STREET_ADDRESS2" VARCHAR2(60), "CUST_CITY" VARCHAR2(30), "CUST_STATE" VARCHAR2(2), "CUST_POSTAL_CODE" VARCHAR2(10), "PHONE_NUMBER1" VARCHAR2(25), "PHONE_NUMBER2" VARCHAR2(25), "CREDIT_LIMIT" NUMBER(9, 2), "CUST_EMAIL" VARCHAR2(30), "COMMENTS" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_CUSTOMERS" ("CUSTOMER_ID", "CUST_FIRST_NAME", "CUST_LAST_NAME", "CUST_STREET_ADDRESS1", "CUST_STREET_ADDRESS2", "CUST_CITY", "CUST_STATE", "CUST_POSTAL_CODE", "PHONE_NUMBER1", "PHONE_NUMBER2", "CREDIT_LIMIT", "CUST_EMAIL", "COMMENTS") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) << JohnDulles45020 Aviation DriveSterlingVA20166 703-555-2143 John is one the best customers I've ever had. When he calls, we need to be very responsive to his needs - he only asks when he REALLY needs something. Don't take anything he says for granted - listen carefully.William Hartsfield6000 North Terminal ParkwayAtlantaGA30320 404-555-3285 William is generally a 'B' customer and maybe even a 'C' customer. Don't do anything he asks you to do unless you get approval - he will take everything we have for free or ask us to pay him if he could.EdwardLogan1 Harborside Drive East BostonMA02128 617-555-3295 Edward "Butch"OHare10000 West OHareChicagoIL60666 773-555-7693 Fiorello LaGuardia Hangar Center Third FloorFlushingNY11371 212-555-3923 AlbertLambert!10701 Lambert International Blvd. St. LouisMO63145 314-555-4022 EugeneBradleySchoephoester Road Windsor LocksCT06096 860-555-1835 CREATE UNIQUE INDEX "DEMO_CUSTOMERS_PK" ON "DEMO_CUSTOMERS" ("CUSTOMER_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_CUSTOMERS" bBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_CUSTOMERS_PK"',NULL,NULL,NULL,7,1,7,1,1,1,0,6); END; CREATE INDEX "DEMO_CUST_NAME_IX" ON "DEMO_CUSTOMERS" ("CUST_LAST_NAME" , "CUST_FIRST_NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_CUSTOMERS" bBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_CUST_NAME_IX"',NULL,NULL,NULL,7,1,7,1,1,1,0,6); END; CALTER TABLE ALTER TABLE "DEMO_CUSTOMERS" ADD( CONSTRAINT "DEMO_CUST_CREDIT_LIMIT_MAX" CHECK (credit_limit <= 5000) ENABLE NOVALIDATE ALTER TABLE "DEMO_CUSTOMERS" ADD CONSTRAINT "DEMO_CUSTOMERS_PK" PRIMARY KEY ("CUSTOMER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_CUSTOMERS" YBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_CUSTOMERS"',NULL,NULL,NULL,7,5,139,6); END; ANALSTATS TS "DEMO_CUSTOMERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C108'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,7&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUSTOMER_ID"', NULL ,NULL,NULL,7,.142857142857143,0,srec,3,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '416C62657274'; SREC.MAXVAL := '57696C6C69616D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339697591798236000000000000000000000,453868069894243000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_FIRST_NAME"', NULL ,NULL,NULL,7,.142857142857143,0,srec,9,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '427261646C6579'; SREC.MAXVAL := '4F48617265'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I345011503569423000000000000000000000,411659505850871000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_LAST_NAME"', NULL ,NULL,NULL,7,.142857142857143,0,srec,8,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3120486172626F7273696465204472697665'; SREC.MAXVAL := '5363686F6570686F657374657220526F6164'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255077317761553000000000000000000000,432976872013522000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_STREET_ADDRESS1"', NULL ,NULL,NULL,7,.142857142857143,0,srec,22,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '546869726420466C6F6F72'; SREC.MAXVAL := '546869726420466C6F6F72'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I438270661075105000000000000000000000,438270661075105000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_STREET_ADDRESS2"', NULL ,NULL,NULL,1,1,6,srec,3,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41746C616E7461'; SREC.MAXVAL := '57696E64736F72204C6F636B73'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339860642113916000000000000000000000,453868225886844000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_CITY"', NULL ,NULL,NULL,7,.142857142857143,0,srec,10,6); END; ANALSTATS TS "DEMO_CUSTOMERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4354'; SREC.MAXVAL := '5641'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I349587611928540000000000000000000000,447855886458233000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_STATE"', NULL ,NULL,NULL,7,.142857142857143,0,srec,3,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3032313238'; SREC.MAXVAL := '3633313435'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I250248267411768000000000000000000000,281422331587924000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_POSTAL_CODE"', NULL ,NULL,NULL,7,.142857142857143,0,srec,6,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3231322D3535352D33393233'; SREC.MAXVAL := '3836302D3535352D31383335'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I260612656396596000000000000000000000,291867691139498000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"PHONE_NUMBER1"', NULL ,NULL,NULL,7,.142857142857143,0,srec,13,6); END; ANALSTATS TS "DEMO_CUSTOMERS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"PHONE_NUMBER2"', NULL ,NULL,NULL,0,0,7,srec,0,6); END; ANALSTATS TS "DEMO_CUSTOMERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C20B'; SREC.MAXVAL := 'C20B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 1000,1000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CREDIT_LIMIT"', NULL ,NULL,NULL,1,1,0,srec,3,6); END; ANALSTATS TS "DEMO_CUSTOMERS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"CUST_EMAIL"', NULL ,NULL,NULL,0,0,7,srec,0,6); END; ANALSTATS TS "DEMO_CUSTOMERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4A6F686E206973206F6E6520746865206265737420637573746F6D6572732049'; SREC.MAXVAL := '57696C6C69616D2069732067656E6572616C6C7920612027422720637573746F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I386489588809019000000000000000000000,453868069894243000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_CUSTOMERS"','"COMMENTS"', NULL ,NULL,NULL,2,.5,5,srec,61,6); END; TABLE "DEMO_IMAGES" CREATE TABLE "DEMO_IMAGES" ("IMAGE_ID" NUMBER, "FILE_OBJECT_ID" NUMBER, "IMAGE_NAME" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_IMAGES" ("IMAGE_ID", "FILE_OBJECT_ID", "IMAGE_NAME") VALUES (:1, :2, :3)  ">TN=Eno_image_found.gif "I'(=Ebluetooth_headset.gif "S>%=Emp3_player.gif "];6=E desktop_pc.gif #H=E! laptop.gif # G=E!portable_dvd.gif #X=E! plasma_tv.gif #!&4=E#pda_cellphone.gif #+5D=E( memory.gif #3Z:=E(stereo_headphones.gif #@#=E)low_tech_projector.gif CREATE UNIQUE INDEX "DEMO_IMAGES_PK" ON "DEMO_IMAGES" ("IMAGE_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_IMAGES" aBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_IMAGES_PK"',NULL,NULL,NULL,11,1,11,1,1,1,0,6); END; ALTER TABLE "DEMO_IMAGES" ADD CONSTRAINT "DEMO_IMAGES_PK" PRIMARY KEY ("IMAGE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_IMAGES" VBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_IMAGES"',NULL,NULL,NULL,11,5,29,6); END; ANALSTATS TS "DEMO_IMAGES" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_IMAGES"','"IMAGE_ID"', NULL ,NULL,NULL,11,.0909090909090909,0,srec,3,6); END; ANALSTATS TS "DEMO_IMAGES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C80A223E544E3D4504'; SREC.MAXVAL := 'C80A234019233D4529'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(933618377606803,934632434606840&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_IMAGES"','"FILE_OBJECT_ID"', NULL ,NULL,NULL,11,.0909090909090909,0,srec,10,6); END; ANALSTATS TS "DEMO_IMAGES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '626C7565746F6F74685F686561647365742E676966'; SREC.MAXVAL := '73746572656F5F6865616470686F6E65732E676966'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I511044893467369000000000000000000000,599474935693861000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_IMAGES"','"IMAGE_NAME"', NULL ,NULL,NULL,11,.0909090909090909,0,srec,17,6); END; TABLE "DEMO_ORDERS" CREATE TABLE "DEMO_ORDERS" ("ORDER_ID" NUMBER NOT NULL ENABLE, "CUSTOMER_ID" NUMBER NOT NULL ENABLE, "ORDER_TOTAL" NUMBER(8, 2), "ORDER_TIMESTAMP" DATE, "USER_ID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_ORDERS" ("ORDER_ID", "CUSTOMER_ID", "ORDER_TOTAL", "ORDER_TIMESTAMP", "USER_ID") VALUES (:1, :2, :3, :4, :5)   xk .dxk .dxk .3xk .)xk .3xk  .'xk . )xk . 3xk . xk . CREATE UNIQUE INDEX "DEMO_ORDER_PK" ON "DEMO_ORDERS" ("ORDER_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_ORDERS" `BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_ORDER_PK"',NULL,NULL,NULL,10,1,10,1,1,1,0,6); END; CREATE INDEX "DEMO_ORD_CUSTOMER_IX" ON "DEMO_ORDERS" ("CUSTOMER_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_ORDERS" fBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_ORD_CUSTOMER_IX"',NULL,NULL,NULL,10,1,7,1,1,1,0,6); END; CALTER TABLE ALTER TABLE "DEMO_ORDERS" ADD" CONSTRAINT "DEMO_ORDER_TOTAL_MIN" CHECK (order_total >= 0) ENABLE NOVALIDATE ALTER TABLE "DEMO_ORDERS" ADD CONSTRAINT "DEMO_ORDER_PK" PRIMARY KEY ("ORDER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_ORDERS" VBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_ORDERS"',NULL,NULL,NULL,10,5,20,6); END; ANALSTATS TS "DEMO_ORDERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDERS"','"ORDER_ID"', NULL ,NULL,NULL,10,.1,0,srec,3,6); END; ANALSTATS TS "DEMO_ORDERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C108'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,7&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDERS"','"CUSTOMER_ID"', NULL ,NULL,NULL,7,.142857142857143,0,srec,3,6); END; ANALSTATS TS "DEMO_ORDERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C129'; SREC.MAXVAL := 'C227'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(40,3800&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDERS"','"ORDER_TOTAL"', NULL ,NULL,NULL,9,.111111111111111,0,srec,4,6); END; ANALSTATS TS "DEMO_ORDERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786B031517202E'; SREC.MAXVAL := '786B050517202E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2454181.93871528,2454226.93871528&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDERS"','"ORDER_TIMESTAMP"', NULL ,NULL,NULL,10,.1,0,srec,8,6); END; ANALSTATS TS "DEMO_ORDERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C103'; SREC.MAXVAL := 'C103'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(2,2&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDERS"','"USER_ID"', NULL ,NULL,NULL,1,1,0,srec,3,6); END; TABLE "DEMO_ORDER_ITEMS" CREATE TABLE "DEMO_ORDER_ITEMS" ("ORDER_ITEM_ID" NUMBER(3, 0) NOT NULL ENABLE, "ORDER_ID" NUMBER NOT NULL ENABLE, "PRODUCT_ID" NUMBER NOT NULL ENABLE, "UNIT_PRICE" NUMBER(8, 2) NOT NULL ENABLE, "QUANTITY" NUMBER(8, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_ORDER_ITEMS" ("ORDER_ITEM_ID", "ORDER_ID", "PRODUCT_ID", "UNIT_PRICE", "QUANTITY") VALUES (:1, :2, :3, :4, :5)  d 3 3 3 d 3 ) 3    3 )  3  CREATE UNIQUE INDEX "DEMO_ORDER_ITEMS_PK" ON "DEMO_ORDER_ITEMS" ("ORDER_ITEM_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_ORDER_ITEMS" fBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_ORDER_ITEMS_PK"',NULL,NULL,NULL,16,1,16,1,1,1,0,6); END; ALTER TABLE "DEMO_ORDER_ITEMS" ADD CONSTRAINT "DEMO_ORDER_ITEMS_PK" PRIMARY KEY ("ORDER_ITEM_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_ORDER_ITEMS" [BEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_ORDER_ITEMS"',NULL,NULL,NULL,16,5,15,6); END; ANALSTATS TS "DEMO_ORDER_ITEMS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C111'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,16&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDER_ITEMS"','"ORDER_ITEM_ID"', NULL ,NULL,NULL,16,.0625,0,srec,3,6); END; ANALSTATS TS "DEMO_ORDER_ITEMS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,2,3,4,5,6,7,8,9,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(1,5,6,8,9,10,12,13,15,16); SREC.EPC := 10; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDER_ITEMS"','"ORDER_ID"', NULL ,NULL,NULL,10,.03125,0,srec,3,6); END; ANALSTATS TS "DEMO_ORDER_ITEMS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDER_ITEMS"','"PRODUCT_ID"', NULL ,NULL,NULL,9,.111111111111111,0,srec,3,6); END; ANALSTATS TS "DEMO_ORDER_ITEMS" }DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C129'; SREC.MAXVAL := 'C21464'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(40,1999&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDER_ITEMS"','"UNIT_PRICE"', NULL ,NULL,NULL,9,.111111111111111,0,srec,4,6); END; ANALSTATS TS "DEMO_ORDER_ITEMS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C105'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,4&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_ORDER_ITEMS"','"QUANTITY"', NULL ,NULL,NULL,4,.25,0,srec,3,6); END; TABLE "DEMO_PAGE_HIERARCHY" CREATE TABLE "DEMO_PAGE_HIERARCHY" ("PAGE_ID" NUMBER, "PARENT_PAGE_ID" NUMBER, "PAGE_NAME" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_PAGE_HIERARCHY" ("PAGE_ID", "PARENT_PAGE_ID", "PAGE_NAME") VALUES (:1, :2, :3)  Enter a Customer  Select Items  Reset PasswordCharts : Cluster BarCharts : Pie ChartCharts : Stacked Bar AdminHomeAbout This ApplicationSample Application CustomersProductsAdd/Modify Products Add Product ImageOrdersView Order DetailsAdd/Modify Customers Order Confirmation CREATE UNIQUE INDEX "DEMO_PAGE_HIERARCHY_PK" ON "DEMO_PAGE_HIERARCHY" ("PAGE_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_PAGE_HIERARCHY" iBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_PAGE_HIERARCHY_PK"',NULL,NULL,NULL,18,1,18,1,1,1,0,6); END; ALTER TABLE "DEMO_PAGE_HIERARCHY" ADD CONSTRAINT "DEMO_PAGE_HIERARCHY_PK" PRIMARY KEY ("PAGE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_PAGE_HIERARCHY" ^BEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_PAGE_HIERARCHY"',NULL,NULL,NULL,18,5,21,6); END; ANALSTATS TS "DEMO_PAGE_HIERARCHY" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C11E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,29&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PAGE_HIERARCHY"','"PAGE_ID"', NULL ,NULL,NULL,18,.0555555555555556,0,srec,3,6); END; ANALSTATS TS "DEMO_PAGE_HIERARCHY" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C10D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,12&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PAGE_HIERARCHY"','"PARENT_PAGE_ID"', NULL ,NULL,NULL,10,.1,1,srec,3,6); END; ANALSTATS TS "DEMO_PAGE_HIERARCHY" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41626F75742054686973204170706C69636174696F6E'; SREC.MAXVAL := '56696577204F726465722044657461696C73'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339495802622095000000000000000000000,448675221754570000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PAGE_HIERARCHY"','"PAGE_NAME"', NULL ,NULL,NULL,18,.0555555555555556,0,srec,16,6); END; TABLE "DEMO_PRODUCT_INFO" CREATE TABLE "DEMO_PRODUCT_INFO" ("PRODUCT_ID" NUMBER NOT NULL ENABLE, "PRODUCT_NAME" VARCHAR2(50), "PRODUCT_DESCRIPTION" VARCHAR2(2000), "CATEGORY" VARCHAR2(30), "PRODUCT_AVAIL" VARCHAR2(1), "LIST_PRICE" NUMBER(8, 2), "IMAGE_ID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_PRODUCT_INFO" ("PRODUCT_ID", "PRODUCT_NAME", "PRODUCT_DESCRIPTION", "CATEGORY", "PRODUCT_AVAIL", "LIST_PRICE", "IMAGE_ID") VALUES (:1, :2, :3, :4, :5, :6, :7) 23.2 GHz Desktop PC(All the options, this machine is loaded!ComputerY  MP3 Player-Store up to 1000 songs and take them with youAudioYdBluetooth HeadsetHands-Free without the wires!PhonesY)PDA Cell Phone/Combine your cell phone and PDA into one devicePhonesY3Portable DVD PlayerSmall enough to take anywhere!VideoY 512 MB DIMM0Expand your PCs memory and gain more performanceComputerY 54" Plasma Flat Screen;Mount on the wall or ceiling, the picture is crystal clear!VideoY(` Classic Projector0Does not include transparencies or grease pencilVideoY3  Ultra Slim Laptop+The power of a desktop in a portable designComputerYd Stereo Headphones4Noise-cancelling headphones perfect for the travelerAudioY3 CREATE UNIQUE INDEX "DEMO_PRODUCT_INFO_PK" ON "DEMO_PRODUCT_INFO" ("PRODUCT_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_PRODUCT_INFO" gBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_PRODUCT_INFO_PK"',NULL,NULL,NULL,10,1,10,1,1,1,0,6); END; ALTER TABLE "DEMO_PRODUCT_INFO" ADD CONSTRAINT "DEMO_PRODUCT_INFO_PK" PRIMARY KEY ("PRODUCT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_PRODUCT_INFO" \BEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_PRODUCT_INFO"',NULL,NULL,NULL,10,5,80,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"PRODUCT_ID"', NULL ,NULL,NULL,10,.1,0,srec,3,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '332E322047487A204465736B746F70205043'; SREC.MAXVAL := '556C74726120536C696D204C6170746F70'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I265744102024866000000000000000000000,443544959078216000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"PRODUCT_NAME"', NULL ,NULL,NULL,10,.1,0,srec,18,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '416C6C20746865206F7074696F6E732C2074686973206D616368696E65206973'; SREC.MAXVAL := '54686520706F776572206F662061206465736B746F7020696E206120706F7274'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339698362727758000000000000000000000,438270318799566000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"PRODUCT_DESCRIPTION"', NULL ,NULL,NULL,10,.1,0,srec,46,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '417564696F'; SREC.MAXVAL := '566964656F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339880293174759000000000000000000000,448675137050807000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"CATEGORY"', NULL ,NULL,NULL,4,.25,0,srec,8,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '59'; SREC.MAXVAL := '59'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I462114420409600000000000000000000000,462114420409600000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"PRODUCT_AVAIL"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" }DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C129'; SREC.MAXVAL := 'C22860'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(40,3995&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"LIST_PRICE"', NULL ,NULL,NULL,10,.1,0,srec,4,6); END; ANALSTATS TS "DEMO_PRODUCT_INFO" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C10B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,10&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_PRODUCT_INFO"','"IMAGE_ID"', NULL ,NULL,NULL,10,.1,0,srec,3,6); END; TABLE "DEMO_STATES" CREATE TABLE "DEMO_STATES" ("ST" VARCHAR2(30), "STATE_NAME" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_STATES" ("ST", "STATE_NAME") VALUES (:1, :2) AKALASKAALALABAMAARARKANSASAZARIZONACA CALIFORNIACOCOLORADOCT CONNECTICUTDCDISTRICT OF COLUMBIADEDELAWAREFLFLORIDAGAGEORGIAHIHAWAIIIAIOWAIDIDAHOILILLINOISININDIANAKSKANSASKYKENTUCKYLA LOUISIANAMA MASSACHUSETTSMDMARYLANDMEMAINEMIMICHIGANMN MINNESOTAMOMISSOURIMS MISSISSIPPIMTMONTANANCNORTH CAROLINAND NORTH DAKOTANENEBRASKANH NEW HAMPSHIRENJ NEW JERSEYNM NEW MEXICONVNEVADANYNEW YORKOHOHIOOKOKLAHOMAOROREGONPA PENNSYLVANIARI RHODE ISLANDSCSOUTH CAROLINASD SOUTH DAKOTATN TENNESSEETXTEXASUTUTAHVAVIRGINIAVTVERMONTWA WASHINGTONWI WISCONSINWV WEST VIRGINIAWYWYOMING ANALSTATS TS "DEMO_STATES" VBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_STATES"',NULL,NULL,NULL,51,5,12,6); END; ANALSTATS TS "DEMO_STATES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '414B'; SREC.MAXVAL := '5759'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339020476525038000000000000000000000,453534961147255000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_STATES"','"ST"', NULL ,NULL,NULL,51,.0196078431372549,0,srec,3,6); END; ANALSTATS TS "DEMO_STATES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '414C4142414D41'; SREC.MAXVAL := '57594F4D494E47'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339045929270160000000000000000000000,453541244091061000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_STATES"','"STATE_NAME"', NULL ,NULL,NULL,51,.0196078431372549,0,srec,10,6); END; TABLE "DEMO_USERS" CREATE TABLE "DEMO_USERS" ("USER_ID" NUMBER, "USER_NAME" VARCHAR2(100), "PASSWORD" VARCHAR2(4000), "CREATED_ON" DATE, "QUOTA" NUMBER, "PRODUCTS" CHAR(1), "EXPIRES_ON" DATE, "ADMIN_USER" CHAR(1), "EMAIL_ADDRESS" VARCHAR2(100), "COMPANY" VARCHAR2(100), "PHONE" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEMO_USERS" ("USER_ID", "USER_NAME", "PASSWORD", "CREATED_ON", "QUOTA", "PRODUCTS", "EXPIRES_ON", "ADMIN_USER", "EMAIL_ADDRESS", "COMPANY", "PHONE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) d ` `ddADMIN 1B8BE835E4EAE9F471ABB7A6E0EE86B6xk YYadmin@anycompany.com Any Company 303-555-1239DEMO 5DD55E1291FFB1B3416F9E4E268BC0FAxk 3YxlNdemo@anycompany.comAnother Company 303-555-1210 CREATE UNIQUE INDEX "DEMO_USERS_PK" ON "DEMO_USERS" ("USER_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "DEMO_USERS" ^BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"DEMO_USERS_PK"',NULL,NULL,NULL,2,1,2,1,1,1,0,6); END; ALTER TABLE "DEMO_USERS" ADD CONSTRAINT "DEMO_USERS_PK" PRIMARY KEY ("USER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEMO_USERS" TBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEMO_USERS"',NULL,NULL,NULL,2,5,57,6); END; ANALSTATS TS "DEMO_USERS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C103'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,2&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"USER_ID"', NULL ,NULL,NULL,2,.5,0,srec,3,6); END; ANALSTATS TS "DEMO_USERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41444D494E'; SREC.MAXVAL := '44454D4F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I338884622913028000000000000000000000,354481797660850000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"USER_NAME"', NULL ,NULL,NULL,2,.5,0,srec,6,6); END; ANALSTATS TS "DEMO_USERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3142384245383335453445414539463437314142423741364530454538364236'; SREC.MAXVAL := '3544443535453132393146464231423334313646394534453236384243304641'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255765642388840000000000000000000000,276576341337550000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"PASSWORD"', NULL ,NULL,NULL,2,.5,0,srec,33,6); END; ANALSTATS TS "DEMO_USERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786B050A17202E'; SREC.MAXVAL := '786B050A17202E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2454231.93871528,2454231.93871528&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"CREATED_ON"', NULL ,NULL,NULL,1,1,0,srec,8,6); END; ANALSTATS TS "DEMO_USERS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C30233'; SREC.MAXVAL := 'C30233'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 15000,15000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"QUOTA"', NULL ,NULL,NULL,1,1,1,srec,3,6); END; ANALSTATS TS "DEMO_USERS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '59'; SREC.MAXVAL := '59'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I462766002760475000000000000000000000,462766002760475000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"PRODUCTS"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "DEMO_USERS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"EXPIRES_ON"', NULL ,NULL,NULL,0,0,2,srec,1,6); END; ANALSTATS TS "DEMO_USERS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E'; SREC.MAXVAL := '59'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I405650737316592000000000000000000000,462766002760475000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEMO_USERS"','"ADMIN_USER"', NULL ,NULL,NULL,2,.5,0,srec,2,6); END; TABLE "DEPT" CREATE TABLE "DEPT" ("DEPTNO" NUMBER(2, 0), "DNAME" VARCHAR2(14), "LOC" VARCHAR2(13)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "DEPT" ("DEPTNO", "DNAME", "LOC") VALUES (:1, :2, :3)   ACCOUNTINGNEW YORKRESEARCHDALLASSALESCHICAGO) OPERATIONSBOSTON ALTER TABLE "DEPT" ADD PRIMARY KEY ("DEPTNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "DEPT" NBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"DEPT"',NULL,NULL,NULL,4,5,20,6); END; ANALSTATS TS "DEPT" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C10B'; SREC.MAXVAL := 'C129'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(10,40&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEPT"','"DEPTNO"', NULL ,NULL,NULL,4,.25,0,srec,3,6); END; ANALSTATS TS "DEPT" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4143434F554E54494E47'; SREC.MAXVAL := '53414C4553'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I338863550087541000000000000000000000,432285038677786000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEPT"','"DNAME"', NULL ,NULL,NULL,4,.25,0,srec,10,6); END; ANALSTATS TS "DEPT" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '424F53544F4E'; SREC.MAXVAL := '4E455720594F524B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I344300505052090000000000000000000000,406405544089997000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1l); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DEPT"','"LOC"', NULL ,NULL,NULL,4,.25,0,srec,8,6); END; TABLE "EAGLE" CREATE TABLE "EAGLE" ("ID" NUMBER, "ACCOUNTNO" VARCHAR2(30), "PARCELNUMBER" VARCHAR2(255), "OWNERGRANTEE" VARCHAR2(255), "OWNERADDRESS2" VARCHAR2(255), "OWNERADDRESS3" VARCHAR2(255), "CITY" VARCHAR2(30), "STATE" VARCHAR2(30), "ZIPCODE" VARCHAR2(30), "BUILDINGTYPE" VARCHAR2(255), "SUBDIVISION" VARCHAR2(255), "BLOCK" VARCHAR2(255), "LOT" VARCHAR2(255), "CONDO" VARCHAR2(255), "UNITNO" VARCHAR2(255), "LEGALDESCRIPTION" VARCHAR2(4000), "TAXAREA" VARCHAR2(30), "TOTALACRES" VARCHAR2(255), "TOTALACTVALUE" NUMBER, "ACTLANDVALUE" VARCHAR2(255), "ACTIMPSVALUE" VARCHAR2(255), "TOTALASSDVALUE" NUMBER, "ASSDLANDVALUE" VARCHAR2(255), "ASSDIMPVALUE" VARCHAR2(255), "RESBLDGCOUNT" NUMBER, "FIRSTRESSTORIES" VARCHAR2(255), "FIRSTRESYEARBUILT" VARCHAR2(255), "FIRSTRESBATHS" VARCHAR2(255), "FIRSTRESBEDROOMS" VARCHAR2(255), "FIRSTRESROOMS" VARCHAR2(255), "FIRSTRESGARAGECAPACITY" VARCHAR2(255), "FIRSTRESSFHEATED" VARCHAR2(255), "COMMBLDGCOUNT" NUMBER, "SECTION" VARCHAR2(255), "TOWNSHIP" VARCHAR2(255), "RANGE" VARCHAR2(255), "STREETNO" VARCHAR2(255), "STREETALPHA" VARCHAR2(255), "STREETDIR" VARCHAR2(255), "STREETNAME" VARCHAR2(255), "STREETSUFFIX" VARCHAR2(255), "BUILDINGNO" VARCHAR2(255), "LOCCITY" VARCHAR2(255), "SALEDATE1" VARCHAR2(255), "SALEPRICE1" VARCHAR2(255), "RECPTNO1" VARCHAR2(255), "BOOK1" VARCHAR2(255), "PAGE1" VARCHAR2(255), "DOCFEE1" VARCHAR2(255), "GRANTEE1" VARCHAR2(255), "GRANTOR1" VARCHAR2(255), "RMKPUBLIC1" VARCHAR2(255), "SALEDATE2" VARCHAR2(255), "SALEPRICE2" VARCHAR2(255), "RECPTNO2" VARCHAR2(255), "BOOK2" VARCHAR2(255), "PAGE2" VARCHAR2(255), "DOCFEE2" VARCHAR2(255), "GRANTEE2" VARCHAR2(255), "GRANTOR2" VARCHAR2(255), "RMKPUBLIC2" VARCHAR2(255), "SALEDATE3" VARCHAR2(255), "SALEPRICE3" VARCHAR2(255), "RECPTNO3" VARCHAR2(255), "BOOK3" VARCHAR2(255), "PAGE3" VARCHAR2(255), "DOCFEE3" VARCHAR2(255), "GRANTEE3" VARCHAR2(255), "GRANTOR3" VARCHAR2(255), "RMKPUBLIC3" VARCHAR2(255), "SALEDATE4" VARCHAR2(255), "SALEPRICE4" VARCHAR2(255), "RECPTNO4" VARCHAR2(255), "BOOK4" VARCHAR2(255), "PAGE4" VARCHAR2(255), "DOCFEE4" VARCHAR2(255), "GRANTEE4" VARCHAR2(255), "GRANTOR4" VARCHAR2(255), "RMKPUBLIC4" VARCHAR2(255), "SALEDATE5" VARCHAR2(255), "SALEPRICE5" VARCHAR2(255), "RECPTNO5" VARCHAR2(255), "BOOK5" VARCHAR2(255), "PAGE5" VARCHAR2(255), "DOCFEE5" VARCHAR2(255), "GRANTEE5" VARCHAR2(255), "GRANTOR5" VARCHAR2(255), "RMKPUBLIC5" VARCHAR2(255), "SALEDATE6" VARCHAR2(255), "SALEPRICE6" VARCHAR2(255), "RECPTNO6" VARCHAR2(255), "BOOK6" VARCHAR2(255), "PAGE6" VARCHAR2(255), "DOCFEE6" VARCHAR2(255), "GRANTEE6" VARCHAR2(255), "GRANTOR6" VARCHAR2(255), "RMKPUBLIC6" VARCHAR2(255), "SALEDATE7" VARCHAR2(255), "SALEPRICE7" VARCHAR2(255), "RECPTNO7" VARCHAR2(255), "BOOK7" VARCHAR2(255), "PAGE7" VARCHAR2(255), "DOCFEE7" VARCHAR2(255), "GRANTEE7" VARCHAR2(255), "GRANTOR7" VARCHAR2(255), "RMKPUBLIC7" VARCHAR2(255), "SALEDATE8" VARCHAR2(255), "SALEPRICE8" VARCHAR2(255), "RECPTNO8" VARCHAR2(255), "BOOK8" VARCHAR2(255), "PAGE8" VARCHAR2(255), "DOCFEE8" VARCHAR2(255), "GRANTEE8" VARCHAR2(255), "GRANTOR8" VARCHAR2(255), "RMKPUBLIC8" VARCHAR2(255), "SALEDATE9" VARCHAR2(255), "SALEPRICE9" VARCHAR2(255), "RECPTNO9" VARCHAR2(255), "BOOK9" VARCHAR2(255), "PAGE9" VARCHAR2(255), "DOCFEE9" VARCHAR2(255), "GRANTEE9" VARCHAR2(255), "GRANTOR9" VARCHAR2(255), "RMKPUBLIC9" VARCHAR2(255), "SALEDATE10" VARCHAR2(255), "SALEPRICE10" VARCHAR2(255), "RECPTNO10" VARCHAR2(255), "BOOK10" VARCHAR2(255), "PAGE10" VARCHAR2(255), "DOCFEE10" VARCHAR2(255), "GRANTEE10" VARCHAR2(255), "GRANTOR10" VARCHAR2(255), "RMKPUBLIC10" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "EAGLE" ("ID", "ACCOUNTNO", "PARCELNUMBER", "OWNERGRANTEE", "OWNERADDRESS2", "OWNERADDRESS3", "CITY", "STATE", "ZIPCODE", "BUILDINGTYPE", "SUBDIVISION", "BLOCK", "LOT", "CONDO", "UNITNO", "LEGALDESCRIPTION", "TAXAREA", "TOTALACRES", "TOTALACTVALUE", "ACTLANDVALUE", "ACTIMPSVALUE", "TOTALASSDVALUE", "ASSDLANDVALUE", "ASSDIMPVALUE", "RESBLDGCOUNT", "FIRSTRESSTORIES", "FIRSTRESYEARBUILT", "FIRSTRESBATHS", "FIRSTRESBEDROOMS", "FIRSTRESROOMS", "FIRSTRESGARAGECAPACITY", "FIRSTRESSFHEATED", "COMMBLDGCOUNT", "SECTION", "TOWNSHIP", "RANGE", "STREETNO", "STREETALPHA", "STREETDIR", "STREETNAME", "STREETSUFFIX", "BUILDINGNO", "LOCCITY", "SALEDATE1", "SALEPRICE1", "RECPTNO1", "BOOK1", "PAGE1", "DOCFEE1", "GRANTEE1", "GRANTOR1", "RMKPUBLIC1", "SALEDATE2", "SALEPRICE2", "RECPTNO2", "BOOK2", "PAGE2", "DOCFEE2", "GRANTEE2", "GRANTOR2", "RMKPUBLIC2", "SALEDATE3", "SALEPRICE3", "RECPTNO3", "BOOK3", "PAGE3", "DOCFEE3", "GRANTEE3", "GRANTOR3", "RMKPUBLIC3", "SALEDATE4", "SALEPRICE4", "RECPTNO4", "BOOK4", "PAGE4", "DOCFEE4", "GRANTEE4", "GRANTOR4", "RMKPUBLIC4", "SALEDATE5", "SALEPRICE5", "RECPTNO5", "BOOK5", "PAGE5", "DOCFEE5", "GRANTEE5", "GRANTOR5", "RMKPUBLIC5", "SALEDATE6", "SALEPRICE6", "RECPTNO6", "BOOK6", "PAGE6", "DOCFEE6", "GRANTEE6", "GRANTOR6", "RMKPUBLIC6", "SALEDATE7", "SALEPRICE7", "RECPTNO7", "BOOK7", "PAGE7", "DOCFEE7", "GRANTEE7", "GRANTOR7", "RMKPUBLIC7", "SALEDATE8", "SALEPRICE8", "RECPTNO8", "BOOK8", "PAGE8", "DOCFEE8", "GRANTEE8", "GRANTOR8", "RMKPUBLIC8", "SALEDATE9", "SALEPRICE9", "RECPTNO9", "BOOK9", "PAGE9", "DOCFEE9", "GRANTEE9", "GRANTOR9", "RMKPUBLIC9", "SALEDATE10", "SALEPRICE10", "RECPTNO10", "BOOK10", "PAGE10", "DOCFEE10", "GRANTEE10", "GRANTOR10", "RMKPUBLIC10") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133) C098158!SPRINT SPECTRUM LP DBA SPRINT PCSATTN ANDY SIMMONDS PO BOX 8430 KANSAS CITYMO 64113-8430SC103 Q2111380>612300C098296SAN ISABEL TELECOMPROPERTY TAX C/O ROBERT LANE5300 DTC PARKWAY STE 255GREENWOOD VILLAGECO80111SC029B16500000V478500C098315T-MOBILE FKA VOICESTREAMATTN: TAX DEPT12920 SE 38TH STBELLEVUEWA980067C 16631001482300C851850AMERICAN AIRLINES INCC/O TAX DEPT MD 5657 PO BOX 619616 DFW AIRPORTTX 75261-9616SC070*)6264140RC1816600P000153COMCAST OF COLORADO VII, LLCTAX DEPT PO BOX 173838DENVERCO 80217-38382CABLE TV BUSINESS FURNITURE, FIXTURES & EQUIPMENTSC1034,32514350I\=729160VAILP000666VAIL ASSOCIATES INCC/O CARL GILDAMIESTERPO BOX 7VAILCO81658VAIL MOUNTAIN RECREATION AREA FURNITURE, FIXTURES & EQUIPMENT AT EAGLES NEST, GAME CREEK, BLUE MOON BAR, TERMINAL PIZZA, SHOOTING STAR & YOUNGER GENERATIONSC025([23390590O!G6783270P001657MARRIOTT / VAIL RESORTSC/O CARL GILDAMIESTERPO BOX 7VAILCO816586HOTEL/MOTEL RESORT & RESTAURANT FURNITURE & EQUIPMENTSC202#3263430_@[946390715W LIONSHEADCIRVAIL P002190VAIL ASSOCIATES INCC/O CARL GILDAMIESTERPO BOX 7VAILCO81658VAIL MOUNTAIN RECREATION AREA FURNITURE, FIXTURES & EQUIPMENT AT GOLDEN PEAK INCLUDING TV 8, TRAILS END, YOUNGER GENERATION, SNOWELL, SALLY HANSEN SHOP & BELLA RIVA BAKERYSC103 RG11248170G3261970 P002217 LODGE AT VAILC/O THE LODGE AT VAIL174 E GORE CREEK DRVAILCO81657cHOTEL, RESTAURANT & RETAIL SHOP FURNITURE, FIXTURES & EQUIPMENT TO INCLUDE MICKEYS & THE FUR CLUBSC103 G2241270AdG649970174 GORE CREEKDRVAIL P004037COMCAST OF COLORADO VII, LLCTAX DEPT PO BOX 173838DENVERCO 80217-38382CABLE TV BUSINESS FURNITURE, FIXTURES & EQUIPMENTSC001&52437005G1520670140METCALFRDAVON P005169VAIL VALLEY JET CENTER0871 COOLEY MESA RDGYPSUMCO81637LEAGLE COUNTY AIRPORT FIXED BASE OPERATIONS FURNITURE, FIXTURES & EQUIPMENTSC070=1221660$+Q354280871 COOLEY MESARDGYPSUM P005346VAIL ASSOCIATESC/O CARL GILDAMIESTERPO BOX 7VAILCO81658BEAVER CREEK RECREATION AREA FURNITURE, FIXTURES & EQUIPMENT AT THE GOLF COURSE & CLUB HOUSE, POSTE MONTANE UNIT C2 & C4, VEHICLE MAINTENANCE SHOP & OFFICES, VILLAGE RESTAURANTS & RETAIL SHOPS INCLUDING BC SPORTS, EDGEWISE, LEGENDS & SADDLE RIDGE CLUB HOUSESC043"6331830T?1836230P005384CITY MARKET #426C/0 DILLON REAL ESTATE CO INC PO BOX 5567DENVERCO 80217-5567.GROCERY STORE FURNITURE, FIXTURES & EQUIPMENTSC001S?32826250Ra 819610260 BEAVER CREEKPLAVONP008849 GORSUCH LTD263 E GORE CREEK DRVAILCO81657AHYATT REGENCY C-1 & C-2 2105-241-20-002/003 2105-241-20-013/014SC043 ,G1094370 JG317370136ETHOMASPL BEAVER CREEKP008888VAIL CASCADE HOTEL & CLUBC/O DELOITTE & TOUCHE LLP6363 N STATE HWY 161 STE 800IRVINGTX 75038-22625RESTAURANT & LODGING EQUIPMENT, FIXTURES & FURNITURESC125Tb=18397606$5335301300 WESTHAVENDRVAILP009045"EAGLE CABLEWORKS DBA CENTURY/EAGLE(CABLEWORKS - CO RASH # 102-06-0000001370 PO BOX 260888PLANOTX 75026-08882CABLE TV BUSINESS FURNITURE, FIXTURES & EQUIPMENTSC013F=3691360[1070490766CASTLEDREAGLEP009588VAIL ASSOCIATES INCC/O CARL GILDAMIESTERPO BOX 7VAILCO81658BEAVER CREEK MOUNTAIN RECREATION AREA FURNITURE, FIXTURES & EQUIPMENT AT SPRUCE SADDLE, BEANOS RETAIL CAMP, TRAPPERS CABIN, TATORS & GRUNDIS CAMPSC036Gb27709700 ; 8035810P020087WAL-MART STORES #01-1199PROPERTY TAX #05551301 SE 10TH ST BENTONVILLEAR 72716-0555GWAL-MART SUPER CENTER STORE FURNITURE, FIXTURES & EQUIPMENT #01-1199SC1304.Q2514580I]729230171YODERAVEAVONP020772HYATT REGENCY BEAVER CREEK&C/O CRESCENT REAL ESTATE PROP TAX DEPT777 MAIN ST STE 2100FT WORTHTX76102BEAVER CREEK HOTEL -cCONDO: BEAVER CREEK HOTEL UNIT:- DESC:HOTEL & UNITS CONDO OFFICE, FURNITURE, FIXTURES & EQUIPMENTSC043 .)3114540[!903220100ETHOMASPL BEAVER CREEKP020870EAGLE MATERIALS INC3811 TURTLE CREEK BLVD 1100DALLASTX75219UWALLBOARD MANUFACTURING & GYPSUM ROCK MILLING PLANT FURNITURE, FIXTURES & EQUIPMENTSC018 W[24098690cW6988620740HWY 6GYPSUMP022801"BEAVER CREEK RESORT CO OF COLORADO PO BOX 5390AVONCO816207HOMEOWNERS ASSOCIATION FURNITURE, FIXTURES & EQUIPMENTSC043/<31465950+442513026118-CAVONDALELN BEAVER CREEKP023433COMCAST OF COLORADO VII, LLCTAX DEPT PO BOX 173838DENVERCO 80217-38382CABLE TV BUSINESS FURNITURE, FIXTURES & EQUIPMENTSC001 2262510B>656130AVONP023438VAIL ASSOCIATES INCC/O CARL GILDAMIESTERPO BOX 7VAILCO81658USEASONS AT AVON ADMINISTRATION & MANAGEMENT OFFICES FURNITURE, FIXTURES & EQUIPMENTSC001F5=36952601071630137 BENCHMARKRDAVONP023787 US BANCORP EQUIPMENT FINANCE INC13010 SW 68TH PARKWAYPORTLANDOR97223LEASED EQUIPMENTSC029)3171540\b3919750GYPSUMP024075STAG GULCH PARTNERS PO BOX 988EDWARDSCO81632BCORDILLERIA GOLF COURSE MAINTENANCE FACILITY PRO SHOP & CLUBHOUSESC035[1079020 312920 CREATE UNIQUE INDEX "EAGLE_PK" ON "EAGLE" ("ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ANALSTATS IS "EAGLE" [BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"EAGLE_PK"',NULL,NULL,NULL,25,1,25,1,1,1,0,6); END; ALTER TABLE "EAGLE" ADD CONSTRAINT "EAGLE_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "EAGLE" QBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"EAGLE"',NULL,NULL,NULL,25,5,217,6); END; ANALSTATS TS "EAGLE" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C11A'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,25&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1m); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ID"', NULL ,NULL,NULL,25,.04,0,srec,3,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '43303938313538'; SREC.MAXVAL := '50303234303735'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I348861978578721000000000000000000000,416361281903397000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ACCOUNTNO"', NULL ,NULL,NULL,25,.04,0,srec,8,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PARCELNUMBER"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '414D45524943414E204149524C494E455320494E43'; SREC.MAXVAL := '57414C2D4D4152542053544F524553202330312D31313939'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339066533553798000000000000000000000,453054218677340000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"OWNERGRANTEE"', NULL ,NULL,NULL,20,.05,0,srec,24,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '323633204520474F524520435245454B204452'; SREC.MAXVAL := '5441582044455054'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I260714143668715000000000000000000000,437478274805519000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"OWNERADDRESS2"', NULL ,NULL,NULL,14,.0714285714285714,4,srec,19,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3038373120434F4F4C4559204D455341205244'; SREC.MAXVAL := '504F20424F582038343330'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I250370436900184000000000000000000000,416988614864607000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"OWNERADDRESS3"', NULL ,NULL,NULL,16,.0625,2,srec,15,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41564F4E'; SREC.MAXVAL := '5641494C'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339249866195347000000000000000000000,447861693634957000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"CITY"', NULL ,NULL,NULL,15,.0666666666666667,0,srec,8,6); END; ANALSTATS TS "EAGLE" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4152'; SREC.MAXVAL := '5741'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339162453392263000000000000000000000,453048183316767000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1|); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STATE"', NULL ,NULL,NULL,6,.166666666666667,0,srec,3,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '36343131332D38343330'; SREC.MAXVAL := '3938303036'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I281442613066868000000000000000000000,297100553746653000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ZIPCODE"', NULL ,NULL,NULL,17,.0588235294117647,0,srec,8,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BUILDINGTYPE"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SUBDIVISION"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BLOCK"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1l); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"LOT"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '42454156455220435245454B20484F54454C'; SREC.MAXVAL := '42454156455220435245454B20484F54454C'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I344096255456029000000000000000000000,344096255456029000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"CONDO"', NULL ,NULL,NULL,1,1,24,srec,2,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '202020202D'; SREC.MAXVAL := '202020202D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I166805081839554000000000000000000000,166805081839554000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"UNITNO"', NULL ,NULL,NULL,1,1,24,srec,2,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '42454156455220435245454B204D4F554E5441494E2052454352454154494F4E'; SREC.MAXVAL := '57414C4C424F415244204D414E55464143545552494E4720262047595053554D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I344096255456029000000000000000000000,453054228258143000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"LEGALDESCRIPTION"', NULL ,NULL,NULL,18,.0555555555555556,4,srec,74,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '37'; SREC.MAXVAL := '5343323032'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I285576327219416000000000000000000000,432323537025688000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"TAXAREA"', NULL ,NULL,NULL,14,.0714285714285714,0,srec,6,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"TOTALACRES"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C402085B15'; SREC.MAXVAL := 'C41C4762'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1079020,27709700&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"TOTALACTVALUE"', NULL ,NULL,NULL,25,.04,0,srec,6,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '31363530303030'; SREC.MAXVAL := '36323634313430'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255522010192953000000000000000000000,281402445314543000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ACTLANDVALUE"', NULL ,NULL,NULL,4,.25,21,srec,3,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '31303739303230'; SREC.MAXVAL := '36333331383330'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255400476977031000000000000000000000,281422489119662000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ACTIMPSVALUE"', NULL ,NULL,NULL,21,.0476190476190476,4,srec,8,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C3201E15'; SREC.MAXVAL := 'C409043B0B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(312920,8035810&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1y); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"TOTALASSDVALUE"', NULL ,NULL,NULL,25,.04,0,srec,6,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '31383136363030'; SREC.MAXVAL := '363132333030'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255562259963674000000000000000000000,281381845681576000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ASSDLANDVALUE"', NULL ,NULL,NULL,4,.25,21,srec,2,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '31303730343930'; SREC.MAXVAL := '393436333930'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255400474196535000000000000000000000,297019900409522000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"ASSDIMPVALUE"', NULL ,NULL,NULL,21,.0476190476190476,4,srec,7,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := '80'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RESBLDGCOUNT"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESSTORIES"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1z); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESYEARBUILT"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1v); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESBATHS"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1y); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESBEDROOMS"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1v); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESROOMS"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESGARAGECAPACITY"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1y); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"FIRSTRESSFHEATED"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := '80'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"COMMBLDGCOUNT"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SECTION"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"TOWNSHIP"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RANGE"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '313030'; SREC.MAXVAL := '383731'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255399904680983000000000000000000000,291888038786114000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STREETNO"', NULL ,NULL,NULL,13,.0769230769230769,12,srec,3,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3131382D43'; SREC.MAXVAL := '3131382D43'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I255420834923710000000000000000000000,255420834923710000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STREETALPHA"', NULL ,NULL,NULL,1,1,24,srec,2,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '45'; SREC.MAXVAL := '57'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I358268483238903000000000000000000000,451729826692530000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STREETDIR"', NULL ,NULL,NULL,2,.5,22,srec,2,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41564F4E44414C45'; SREC.MAXVAL := '594F444552'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339249866277863000000000000000000000,463722139736937000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STREETNAME"', NULL ,NULL,NULL,12,.0833333333333333,12,srec,6,6); END; ANALSTATS TS "EAGLE" }DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '415645'; SREC.MAXVAL := '5244'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339249049773891000000000000000000000,427147546252904000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"STREETSUFFIX"', NULL ,NULL,NULL,6,.166666666666667,13,srec,3,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BUILDINGNO"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41564F4E'; SREC.MAXVAL := '5641494C'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339249866195347000000000000000000000,447861693634957000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"LOCCITY"', NULL ,NULL,NULL,5,.2,9,srec,5,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC1"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC2"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC3"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC4"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC5"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC6"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC7"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC8"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC9"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEDATE10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"SALEPRICE10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RECPTNO10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"BOOK10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"PAGE10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"DOCFEE10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTEE10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"GRANTOR10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; ANALSTATS TS "EAGLE" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EAGLE"','"RMKPUBLIC10"', NULL ,NULL,NULL,0,0,25,srec,0,6); END; TABLE "EMP" CREATE TABLE "EMP" ("EMPNO" NUMBER(4, 0) NOT NULL ENABLE, "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9), "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUMBER(7, 2), "DEPTNO" NUMBER(2, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "EMP" ("EMPNO", "ENAME", "JOB", "MGR", "HIREDATE", "SAL", "COMM", "DEPTNO") VALUES (:1, :2, :3, :4, :5, :6, :7, :8)    O(KING PRESIDENTw 3 McBLAKEMANAGERO(w3NSCLARKMANAGERO(w 3 LCJONESMANAGERO(wLNYSCOTTANALYSTLCw PFORDANALYSTLCw JFSMITHCLERKPw  KdALLENSALESMANMcwLWARDSALESMANMcw 3M7MARTINSALESMANMcw  3O-TURNERSALESMANMcw OMADAMSCLERKNYw  PJAMESCLERKMcw  3P#MILLERCLERKNSw ALTER TABLE "EMP" ADD PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ANALSTATS TS "EMP" NBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"EMP"',NULL,NULL,NULL,14,5,37,6); END; ANALSTATS TS "EMP" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C24A46'; SREC.MAXVAL := 'C25023'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 7369,7934&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1|); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"EMPNO"', NULL ,NULL,NULL,14,.0714285714285714,0,srec,4,6); END; ANALSTATS TS "EMP" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4144414D53'; SREC.MAXVAL := '57415244'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I338883673419062000000000000000000000,453054701071074000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1|); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"ENAME"', NULL ,NULL,NULL,14,.0714285714285714,0,srec,6,6); END; ANALSTATS TS "EMP" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '414E414C595354'; SREC.MAXVAL := '53414C45534D414E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I339086497213261000000000000000000000,432285038678150000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1j); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"JOB"', NULL ,NULL,NULL,5,.2,0,srec,8,6); END; ANALSTATS TS "EMP" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C24C43'; SREC.MAXVAL := 'C25003'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 7566,7902&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"MGR"', NULL ,NULL,NULL,6,.166666666666667,1,srec,4,6); END; ANALSTATS TS "EMP" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '77B40C11010101'; SREC.MAXVAL := '77B7010C010101'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(2444591,2445347&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"HIREDATE"', NULL ,NULL,NULL,13,.0769230769230769,0,srec,8,6); END; ANALSTATS TS "EMP" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C209'; SREC.MAXVAL := 'C233'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(800,5000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1z); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"SAL"', NULL ,NULL,NULL,12,.0833333333333333,0,srec,4,6); END; ANALSTATS TS "EMP" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C20F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,1400&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1m); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"COMM"', NULL ,NULL,NULL,4,.25,10,srec,2,6); END; ANALSTATS TS "EMP" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C10B'; SREC.MAXVAL := 'C11F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(10,30&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EMP"','"DEPTNO"', NULL ,NULL,NULL,3,.333333333333333,0,srec,3,6); END; TABLE "HELP_TABLE" CREATE TABLE "HELP_TABLE" ("PAGE_ID" NUMBER, "HELP_TEXT" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING NOCOMPRESS INSERT INTO "HELP_TABLE" ("PAGE_ID", "HELP_TEXT") VALUES (:1, :2) 7This is the help text for page 1 in the application....KThis is the help text for another page in the application - this is page 2.QI'm up to page 3 in the application. I really enjoy typing this help text - not.;OK, it's now getting boring typing all of these help pages.-How many of these am I going to have to type?BYou know how we developers like doing documentation....not really!OK, I'm officially bored now! CREATE UNIQUE INDEX "HELP_TABLE_PK" ON "HELP_TABLE" ("PAGE_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ALTER TABLE "HELP_TABLE" ADD CONSTRAINT "HELP_TABLE_PK" PRIMARY KEY ("PAGE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FLOW_1" LOGGING ENABLE ENDTABLE METRICSUsynonyms METRICEU 7 METRICSUviews METRICEU 7 METRICSUstored procedures ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = PLSQL CREATE FORMAT71 FUNCTION "CUSTOM_AUTH" CREATE Ffunction custom_auth (p_username in VARCHAR2, p_password in VARCHAR2) return BOOLEAN is  l_password varchar2(4000); $ l_stored_password varchar2(4000);  l_expires_on date;  l_count number; begin 8-- First, check to see if the user is in the user table Kselect count(*) into l_count from demo_users where user_name = p_username; if l_count > 0 then ? -- First, we fetch the stored hashed password & expire date D select password, expires_on into l_stored_password, l_expires_on 1 from demo_users where user_name = p_username;  < -- Next, we check to see if the user's account is expired  -- If it is, return FALSE 9 if l_expires_on > sysdate or l_expires_on is null then  H -- If the account is not expired, we have to apply the custom hash -- function to the password 7 l_password := custom_hash(p_username, p_password);  H -- Finally, we compare them to see if they are the same and return  -- either TRUE or FALSE + if l_password = l_stored_password then  return true; else  return false; end if;  else  return false; end if; else : -- The username provided is not in the DEMO_USERS table  return false; end if; end; CREATE FORMAT71 FUNCTION "CUSTOM_HASH" CREATE Ffunction custom_hash (p_username in varchar2, p_password in varchar2) return varchar2 is  l_password varchar2(4000); = l_salt varchar2(4000) := 'ETBR30M7KG5UATKF095ACQCDAX2ZIP'; begin  L-- This function should be wrapped, as the hash algorhythm is exposed here. J-- You can change the value of l_salt or the method of which to call the F-- DBMS_OBFUSCATOIN toolkit, but you much reset all of your passwords -- if you choose to do this.  ?l_password := utl_raw.cast_to_raw(dbms_obfuscation_toolkit.md5 H (input_string => p_password || substr(l_salt,10,13) || p_username ||  substr(l_salt, 4,10))); return l_password; end; ALTER SESSION SET "_LOAD_WITHOUT_COMPILE" = NONE ALTER FUNCTION "CUSTOM_AUTH" COMPILE REUSE SETTINGS TIMESTAMP '2007-06-24:22:40:36' ALTER FUNCTION "CUSTOM_HASH" COMPILE REUSE SETTINGS TIMESTAMP '2007-05-10:22:31:44' METRICEU 9 METRICSUoperators METRICEU 9 METRICSUAnalyze cluster statements METRICEU 9 METRICSUreferential integrity constraints TABLE "EMP" ALTER TABLE "EMP" ADD FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE ENDTABLE TABLE "EMP" ALTER TABLE "EMP" ADD FOREIGN KEY ("MGR") REFERENCES "EMP" ("EMPNO") ENABLE ENDTABLE TABLE "DEMO_ORDERS" ALTER TABLE "DEMO_ORDERS" ADD CONSTRAINT "DEMO_ORDERS_USER_ID_FK" FOREIGN KEY ("USER_ID") REFERENCES "DEMO_USERS" ("USER_ID") ENABLE NOVALIDATE ENDTABLE TABLE "DEMO_ORDERS" ALTER TABLE "DEMO_ORDERS" ADD CONSTRAINT "DEMO_ORDERS_CUSTOMER_ID_FK" FOREIGN KEY ("CUSTOMER_ID") REFERENCES "DEMO_CUSTOMERS" ("CUSTOMER_ID") ENABLE NOVALIDATE ENDTABLE TABLE "DEMO_ORDER_ITEMS" ALTER TABLE "DEMO_ORDER_ITEMS" ADD CONSTRAINT "DEMO_ORDER_ITEMS_PRODUCT_ID_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "DEMO_PRODUCT_INFO" ("PRODUCT_ID") ON DELETE CASCADE ENABLE NOVALIDATE ENDTABLE TABLE "DEMO_ORDER_ITEMS" ALTER TABLE "DEMO_ORDER_ITEMS" ADD CONSTRAINT "DEMO_ORDER_ITEMS_FK" FOREIGN KEY ("ORDER_ID") REFERENCES "DEMO_ORDERS" ("ORDER_ID") ON DELETE CASCADE ENABLE NOVALIDATE ENDTABLE METRICEU 15 METRICSUtriggers TABLE "DEMO_USERS" CREATE FORMAT92TRIG TRIGGER "BI_DEMO_USERS" BEFORE insert on "DEMO_USERS" for each row begin begin  for c1 in ( - select DEMO_USERS_SEQ.nextval next_val  from dual ) loop $ :new.USER_ID := c1.next_val;  :new.admin_user := 'N'; :new.created_on := sysdate;  end loop; end; end; ALTER TRIGGER "BI_DEMO_USERS" ENABLE ENDTABLE TABLE "DEMO_USERS" CREATE FORMAT92TRIG TRIGGER "DEMO_USERS_T1" BEFORE !insert or update on "DEMO_USERS" for each row begin ):NEW.user_name := upper(:NEW.user_name); end; ALTER TRIGGER "DEMO_USERS_T1" ENABLE ENDTABLE TABLE "DEMO_CUSTOMERS" CREATE FORMAT92TRIG TRIGGER "INSERT_DEMO_CUST" BEFORE INSERT ON demo_customers FOR EACH ROW DECLARE  cust_id number; BEGIN  SELECT demo_cust_seq.nextval  INTO cust_id  FROM dual;  :new.CUSTOMER_ID := cust_id; END; ALTER TRIGGER "INSERT_DEMO_CUST" ENABLE ENDTABLE TABLE "DEMO_PRODUCT_INFO" CREATE FORMAT92TRIG TRIGGER "INSERT_DEMO_PROD" #BEFORE INSERT ON demo_product_info FOR EACH ROW DECLARE  prod_id number; BEGIN  SELECT demo_prod_seq.nextval  INTO prod_id  FROM dual;  :new.PRODUCT_ID := prod_id; END; ALTER TRIGGER "INSERT_DEMO_PROD" ENABLE ENDTABLE TABLE "DEMO_ORDER_ITEMS" CREATE FORMAT92TRIG $TRIGGER "INSERT_DEMO_ORDER_ITEMS" BEFORE insert on "DEMO_ORDER_ITEMS" for each row begin declare  order_item_id number; begin Bselect demo_order_items_seq.nextval into order_item_id from dual; %:new.ORDER_ITEM_ID := order_item_id; end; end; ALTER TRIGGER "INSERT_DEMO_ORDER_ITEMS" ENABLE ENDTABLE TABLE "DEMO_ORDER_ITEMS" CREATE FORMAT92TRIG TRIGGER "UPDATE_ORDER_TOTAL" 6after insert or update or delete on demo_order_items begin  9-- Update the Order Total when any order item is changed  &update demo_orders set order_total = : (select sum(unit_price*quantity) from demo_order_items = where demo_order_items.order_id = demo_orders.order_id); end; ALTER TRIGGER "UPDATE_ORDER_TOTAL" ENABLE ENDTABLE TABLE "DEMO_ORDER_ITEMS" CREATE FORMAT92TRIG 'TRIGGER "DEMO_ORDER_ITEMS_GET_PRICE" :before insert or update on demo_order_items for each row declare  l_list_price number; begin G-- First, we need to get the current list price of the order line item <select list_price into l_list_price from demo_product_info & where product_id = :new.product_id;  X-- Once we have the correct price, we will update the order line with the correct price !:new.unit_price := l_list_price;  end; ALTER TRIGGER "DEMO_ORDER_ITEMS_GET_PRICE" ENABLE ENDTABLE TABLE "EAGLE" CREATE FORMAT92TRIG trigger "bi_EAGLE" ) before insert on "EAGLE"  for each row begin  if :new."ID" is null then 9 select "EAGLE_SEQ".nextval into :new."ID" from dual; end if; end; ALTER TRIGGER "bi_EAGLE" ENABLE EXECUTE DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('"BDB"', '"bi_EAGLE"', FALSE); ENDTABLE TABLE "HELP_TABLE" CREATE FORMAT92TRIG trigger "BI_HELP_TABLE" / before insert on "HELP_TABLE"  for each row begin " if :NEW."PAGE_ID" is null then D select "HELP_TABLE_SEQ".nextval into :NEW."PAGE_ID" from dual; end if; end; ALTER TRIGGER "BI_HELP_TABLE" ENABLE ENDTABLE METRICEU 24 METRICSUindextypes METRICEU 24 METRICSUbitmap, functional and extensible indexes METRICEU 24 METRICSUposttables actions METRICEU 24 METRICSUmaterialized views METRICEU 24 METRICSUsnapshot logs METRICEU 24 METRICSUjob queues METRICEU 24 METRICSUrefresh groups and children METRICEU 24 METRICSUdimensions METRICEU 24 METRICSUPost-inst procedural actions METRICEU 24 METRICSUpost-schema procedural objects and actions METRICEU 40 METRICSUstatistics TABLE "DEMO_CUSTOMERS" ANALCOMPUTE TS "DEMO_CUSTOMERS" ANALYZE TABLE "DEMO_CUSTOMERS" ESTIMATE STATISTICS TABLE "DEMO_IMAGES" ANALCOMPUTE TS "DEMO_IMAGES" ANALYZE TABLE "DEMO_IMAGES" ESTIMATE STATISTICS TABLE "DEMO_ORDERS" ANALCOMPUTE TS "DEMO_ORDERS" ANALYZE TABLE "DEMO_ORDERS" ESTIMATE STATISTICS TABLE "DEMO_ORDER_ITEMS" ANALCOMPUTE TS "DEMO_ORDER_ITEMS" ANALYZE TABLE "DEMO_ORDER_ITEMS" ESTIMATE STATISTICS TABLE "DEMO_PAGE_HIERARCHY" ANALCOMPUTE TS "DEMO_PAGE_HIERARCHY" ANALYZE TABLE "DEMO_PAGE_HIERARCHY" ESTIMATE STATISTICS TABLE "DEMO_PRODUCT_INFO" ANALCOMPUTE TS "DEMO_PRODUCT_INFO" ANALYZE TABLE "DEMO_PRODUCT_INFO" ESTIMATE STATISTICS TABLE "DEMO_STATES" ANALCOMPUTE TS "DEMO_STATES" ANALYZE TABLE "DEMO_STATES" ESTIMATE STATISTICS TABLE "DEMO_USERS" ANALCOMPUTE TS "DEMO_USERS" ANALYZE TABLE "DEMO_USERS" ESTIMATE STATISTICS TABLE "DEPT" ANALCOMPUTE TS "DEPT" ANALYZE TABLE "DEPT" ESTIMATE STATISTICS TABLE "EAGLE" ANALCOMPUTE TS "EAGLE" ANALYZE TABLE "EAGLE" ESTIMATE STATISTICS TABLE "EMP" ANALCOMPUTE TS "EMP" ANALYZE TABLE "EMP" ESTIMATE STATISTICS ENDTABLE METRICEU 51 METRICSUEnable enforce constraints TABLE "DEMO_CUSTOMERS" ALTER TABLE "DEMO_CUSTOMERS" ENABLE CONSTRAINT "DEMO_CUST_CREDIT_LIMIT_MAX" ENDTABLE TABLE "DEMO_ORDERS" ALTER TABLE "DEMO_ORDERS" ENABLE CONSTRAINT "DEMO_ORDER_TOTAL_MIN" ALTER TABLE "DEMO_ORDERS" ENABLE CONSTRAINT "DEMO_ORDERS_USER_ID_FK" ALTER TABLE "DEMO_ORDERS" ENABLE CONSTRAINT "DEMO_ORDERS_CUSTOMER_ID_FK" ENDTABLE TABLE "DEMO_ORDER_ITEMS" ALTER TABLE "DEMO_ORDER_ITEMS" ENABLE CONSTRAINT "DEMO_ORDER_ITEMS_PRODUCT_ID_FK" ALTER TABLE "DEMO_ORDER_ITEMS" ENABLE CONSTRAINT "DEMO_ORDER_ITEMS_FK" ENDTABLE METRICEU 57 METRICEUG0 EXIT EXIT