Please make videos on interview question based on packages, declaration of variables in package body or specification, debugging of package or PLSQL Code
Sir, if we recompile a stand alone procedure / function all related dependent objects of standalone procedure / function will be come invaild ? True ?How please explain.!
Hi Shiva, Kindly explain advantage of overloading in real time. Instead of creating 2 procedures with same name different datatype or parameters why can't we create new procedure with different name and so on. this is my doubt.........
Thank you, only disadvantage i see is loading into memory, incase if i am not going to use any other programs of the package except one, and that too only once for a session/transaciton.
Could you please confirm? Asking a lot of interview questions but not getting clarity? Can we create a package body without package specification or vice versa ?
Simply amazing information in such short video.
Thank you bro
Thank you Siva, great explanation as always !!!
Welcome bro
Thanks a ton Siva, great work !!
Thank you so much
Please make videos on interview question based on packages, declaration of variables in package body or specification, debugging of package or PLSQL Code
sure bro, will add itto upcoming list, please stay tuned
Sir, if we recompile a stand alone procedure / function all related dependent objects of standalone procedure / function will be come invaild ? True ?How please explain.!
Difference between Varchar and Nvarchar....with use cases.. please explain in detail? If possible make vedio on it
Hi Shiva,
Kindly explain advantage of overloading in real time. Instead of creating 2 procedures with same name different datatype or parameters why can't we create new procedure with different name and so on. this is my doubt.........
Hi shiva,
Nice explanation.
What are the disadvatage of packages in oracle please share in comments only
Thank you, only disadvantage i see is loading into memory, incase if i am not going to use any other programs of the package except one, and that too only once for a session/transaciton.
@@SivaAcademy Hi sir, when you say memory - which memory exactly? Cga?
why dependent objects of standalone proc will be come invaild?
Nice explanation...
Welcome
Could you please confirm? Asking a lot of interview questions but not getting clarity?
Can we create a package body without package specification or vice versa ?
Package body cannot be created without out specification, however specification can be created without body
Nice explanation.
How to call a standalone procedure within the package body?
Thank bro, replied via email
Hi, can you please upload what is table partition and types of partitions used in realtime projects?
Simply expalin what is performance tuning in PLSQL SQL and whatvare th tools and how it's done in ontime project
Thank you
You're welcome
Pls explain about overloading
sure, please stay tuned, will cover soon
Can you please make a vedio what is the uses of packages?
Please look into this
ruclips.net/video/Mje8pEtVe5I/видео.html
Advantages and uses are same?
Yes, because of these uses only package is preferred
Ok thank you
🙏
Very informative...
Welcome