--------------------------------------------------------
--  File created - Tuesday-June-16-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table SPTEST
--------------------------------------------------------

  CREATE TABLE "SCOTT"."SPTEST" 
   (	"TICKETID" NUMBER(10,0), 
	"STATUS" VARCHAR2(5 BYTE), 
	"PRIORITY" VARCHAR2(20 BYTE), 
	"FIELD1" NUMBER(10,0), 
	"FIELD2" NUMBER(10,0), 
	"CREATE_DATE" DATE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
REM INSERTING into SCOTT.SPTEST
SET DEFINE OFF;
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (100,'0','P4',null,10,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (101,'0','P3',15,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (102,'0','P2',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (103,'4','P1',8,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (104,'4','P2',10,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (105,'1','P4',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (106,'2','P3',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (107,'2','P2',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (108,'3','P4',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (109,'3','P2',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (110,'4','P3',null,5,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (111,'4','P4',null,4,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (112,'6','P2',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (113,'6','P3',null,null,to_date('14-JUN-15','DD-MON-RR'));
Insert into SCOTT.SPTEST (TICKETID,STATUS,PRIORITY,FIELD1,FIELD2,CREATE_DATE) values (114,'4','P2',5,null,to_date('14-JUN-15','DD-MON-RR'));