Re: How do oracle programmers send batches of SQL from inside a program?

From: Thomas Gagne <TandGandGAGNE_at_gmail.com>
Date: Fri, 19 Mar 2010 22:40:47 -0400
Message-ID: <rJOdncJH5MckqDnWnZ2dnUVZ_hydnZ2d_at_wow.com>

John Hurley wrote:
> <snip>
>
> Multiple sql statements in a batch? Why would you want to do that in
> oracle?
>

Performance. Do as much with a single trip to the database as possible to avoid going back and forth between client and server. Reduces network traffic. Received on Fri Mar 19 2010 - 21:40:47 CDT