drop table test purge

drop table test purge

create table test 
( 
id number, 
order_no varchar2(20 char), 
type varchar2(20 char), 
file_name varchar2(50 char), 
file_size number, 
created_date date 
)

begin 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (1,'ORDER 1','PDF','File#1',1024, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (2,'ORDER 2','PDF','File#2',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (3,'ORDER 3','PDF','File#3',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (4,'ORDER 4','PDF','File#4',1024, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (5,'ORDER 5','PDF','File#5',1024, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (6,'ORDER 6','PDF','File#6',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (7,'ORDER 7','PDF','File#7',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (8,'ORDER 8','PDF','File#8',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (9,'ORDER 9','PDF','File#9',512, TO_DATE('09/21/2017','MM/DD/YYYY')); 
Insert into TEST (ID,ORDER_NO,TYPE,FILE_NAME,FILE_SIZE,CREATED_DATE) values (10,'ORDER 10','PDF','File#10',2048, TO_DATE('09/21/2017','MM/DD/YYYY')); 
commit; 
end;