Tutorial 72 : Bulk Collect with LIMIT Clause in Pl Sql

Hi Friends,

Here we are learning about Pl Sql Bulk Collect with LIMIT Clause. Hope the concept and example would be clear to you.

For any confusion and doubt, let me know in comment box.

Blog Link :

Application Link :

Link (Bulk Collect in Pl Sql || FETCH INTO Statement with Bulk Collect) :

Link (Bulk Collect in Pl Sql || SELECT INTO Statement with Bulk Collect) :

Thanks,
Happy Coding.

[dhavalpandya]

Very good explanation sir. I have a question here that how to know what value we should give in LIMIT Clause like limit 100 or limit 500?
How we decide this ?

[srinukunta]

tell me disadvantages of limit and solution