DWResource
Programmer
Hi All, I am learning some tricks, but still new as far as running a oracle query in batch is concerned.
Can anyone please let me know, how can I run a oracle query in batch mode. Meaning that if query has some inserts into a table then how can I add commit at end, fire a query and just forget about it ??
I am running the query using VPN connection. So how can query still keep running even if VPN connection is lost or oracle connection is down (Except DB being shut down)....??
Thanks in advance.....
Can anyone please let me know, how can I run a oracle query in batch mode. Meaning that if query has some inserts into a table then how can I add commit at end, fire a query and just forget about it ??
I am running the query using VPN connection. So how can query still keep running even if VPN connection is lost or oracle connection is down (Except DB being shut down)....??
Thanks in advance.....