This content has been marked as final. Show 3 replies
Don't use cursor..
Do it in plain SQL..
Thanks for replay Jeneesh.
will use direct SQL statement instead of cursor, so that can improve performance .
but here which way i should use to develop the code whether stand alone procedure or create one package with 8 functions(for each case one function) ?
There wont be much performance difference if you use a package or multiple function..
I would like to use Packages, anyhow..