Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Bulk Binds - Improve performance by reducing the overhead associated with context switches between the PL/SQL and SQL engines.



Mark said...

Excellent. Been back here about 20 times for reference.

Jaggy said...

Excellent stuff here. I am learning PL/SQL from this site and there is lotsa stuff to learn here ...

Deps said...

Wonderful!!!!! Im doing a project on migration from flat file to oracle. If u can give more tips on vill be of great help.


Parimal said...

Excellent... explaination with simple example

Bill said...

Great article!

I've also read that "nested tables" should be used with a "limit" clause - 1000 is a recommeded upper limit.

Does that apply only to SELECT INTO.... statements?

Thanks,
Bill

Example:

SELECT *
BULK COLLECT INTO l_table LIMIT 1000
FROM testing_table t
WHERE t.col20 = 'Valid';

Bill said...


Ignore that last question....that's for the forums!!! Sorry!

Bill

karthik said...

It was very valuable article

Thanks

suman said...

Nice

DO NOT ask technical questions here, that's what my forum is for!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)