Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> what use of Transaction
hi, I got a question
under Sql*Plus ,One statement looks like
> Set transaction
> use rollback segment rs_tmp
> sta delete.sql
What does these sql statement lines mean here? I understand
script 'delete.sql'
I do not know what the relationship between the transaction, rollback
segment, and sql script?
1.) Here rs_tmp is the name of rollback segment.
2.) delete.sql looks like:
delete from conv_price_list_items where prli_blgto_prclist_id in (select pk_prclist_id from price_lists where status='Removed');
commit;
delete from conv_price_list_items where conv_fl = 'Y' and loaded_dt <
sysdate -30;
commit;
delete from conv_products where conv_fl = 'Y' and loaded_dt < sysdate -30;
commit;
delete from conv_product_struct_items where conv_fl = 'Y' and loaded_dt <
sysdate -30;
commit;
thanks.
Bearice.
--
Posted via CNET Help.com
http://www.help.com/
Received on Wed Oct 27 1999 - 14:57:02 CDT
![]() |
![]() |