Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

interview Questions

994122Oct 6 2014 — edited Oct 7 2014

Hi all,

1)Difference between cursor for loop and for loop, which is faster?

2)Difference between global variable and static global variable?

3)How to access variable of nested procedure?

4)If we have both user exception and system exception, which will be handled first?

5)Difference between anonymous block and normal block?

Can you please explain more details on the above points? Explain 2,3,4,5 points at least 1 example.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2014
Added on Oct 6 2014
28 comments
6,015 views