Question regarding specifying batch size in oracle

[shylaja]

Hi
I have a question regarding specifying batch size option in oracle.
Using the batch size option we limit the number of rows retrieved or inserted in the database.
In MSSQL using the bcp utility specifying the -b option we can specify the batch size.
Similarly how can we specify the batch size in oracle .
If anybody has some idea please help.

Thanks in Advance
Shylaja

 

[sem]

It depends on the client type (pl/sql, pro*c, oci, jdbc). What tool do you use and what is your specific task?

Regards, Dima