944768 wrote:Good practice is to not use loops at all, unless you can really justify a need to, and in most cases there is little justification.
as Mr jeneesh said there are scenarios to use GTT,cursors and collection
1)please tel me senarios in general.
2)to loop cursor, i show there are many loops avialable.
please tel me which loop is used in which condition.( i mean good practice).