combining several SQL statements to run sequentially??????
Date: 23 Dec 2003 12:07:05 -0800
Message-ID: <68aecc05.0312231207.4e11e1c_at_posting.google.com>
Hi everyone
How can I have 2 or more SQL statements run sequentially.
This is needed to synchronize a reference table which is later
used in a PL/SQL program that I wrote also.
I'm trying to automate the processes.
Below are the SQL statements that I would like to run together
using SQL*Plus, TOAD, etc ??
Any ideas ??
Thanks & Happy Holidays
George
select count(*) from george_xref;
/
INSERT INTO GEORGE_XREF GEO
select
TRX_NUMBER,
TRX_DATE,
CUSTOMER_TRX_ID,
BILL_TO_CUSTOMER_NUMBER,
substr(bill_to_customer_name,1,25) CUSTOMER_NAME,
PRINTING_ORIGINAL_DATE,
PRINTING_LAST_PRINTED,
PRINTING_OPTION,
PRINTING_PENDING,
PRINTING_COUNT
FROM AR_INVOICE_HEADER_V
WHERE TRX_NUMBER IN
(SELECT TRX_NUMBER FROM AR_INVOICE_HEADER_V MINUS
SELECT TRX_NUMBER FROM GEORGE_XREF);
/
delete from george_xref
where bill_to_customer_number = 1404
/
commit;
Received on Tue Dec 23 2003 - 21:07:05 CET