I need help about TESTING script

From: wajim <wajim29_at_hotmail.com>
Date: Mon, 27 Aug 2007 12:54:37 -0700
Message-ID: <1188244477.138780.203600@d55g2000hsg.googlegroups.com>

Hi all, does somebody have an idea about TESTING this script?.....

This is my script (for data migation) :

--PH1_LOAD.sql

create or replace view myview2 as
select substr(cl.old_system_id,instr(cl.old_system_id,':')+1,4) as order_id,

                substr(cl.old_system_id,instr(cl.old_system_id,':')+6)
as item_id,
                c.customer_id as customer_id,
                p.product_id as product_id,
                ROUND(price.list_price-

(price.list_price*price.discount_available)/
100,2) as actual_price,

                cl.quantity as quantity,
                ROUND(price.list_price-

(price.list_price*price.discount_available)/
100*cl.quantity,2) as total,

                cl.order_date as order_date,
                cl.ship_date as ship_date,
                cl.old_system_id as old_sys_ref
from            PH1_CA_LOAD cl,
                PH1_SITE_MAP_LOAD sml,
                PH1_CA_PROD_CONV_LOAD prod,
                PH1_CA_PRICE_DATA_LOAD price,
                customer c,
                product p

where substr(cl.old_system_id,1,instr(cl.old_system_id,':')-1) = sml.site_code

                and c.name = sml.billing_customer
                and prod.description = p.description
                and cl.old_description = prod.old_code
                and prod.old_code = price.ca_product_code

/

prompt Insert all items in PH1_ITEM
insert all into
PH1_ITEM(order_id,item_id,customer_id,product_id,actual_price,quantity,tota­ l,order_date,ship_date,old_sys_ref)
values(order_id,item_id,customer_id,product_id,actual_price,quantity,total,­ order_date,ship_date,old_sys_ref)
select * from myview1
/

insert all into
PH1_ITEM(order_id,item_id,customer_id,product_id,actual_price,quantity,tota­ l,order_date,ship_date,old_sys_ref)
values(order_id,item_id,customer_id,product_id,actual_price,quantity,total,­ order_date,ship_date,old_sys_ref)
select * from myview2
/

*My question is : what example of TEST PROCEDURE can I make BEFORE AND
AFTER PH1_LOAD script?
and I should update results in TEST TABLE SUITE like this:
(test_id NUMBER(8),

phase_number            NUMBER(2),
task_number                     NUMBER(2,1),
solution_number         NUMBER(1),
test_name                       VARCHAR2(50),
test_desc                       VARCHAR2(200),
before_total            NUMBER(8),
after_total                     NUMBER(8),
result                  VARCHAR2(4) )

Thanks a lot.... Received on Mon Aug 27 2007 - 14:54:37 CDT