Re: combining several SQL statements to run sequentially??????

george lewycky wrote:

> 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;

Seems pretty sequential to me - what's parallel?

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel