Oracle PL SQL interview question | Oracle advantages of packages

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.

Pls explain about overloading

why dependent objects of standalone proc will be come invaild?

Hi, can you please upload what is table partition and types of partitions used in realtime projects?

Thank you Siva, great explanation as always !!!

Can you please make a vedio what is the uses of packages?

Please make videos on interview question based on packages, declaration of variables in package body or specification, debugging of package or PLSQL Code

Simply expalin what is performance tuning in PLSQL SQL and whatvare th tools and how it's done in ontime project

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.........

Nice explanation...

Nice explanation.
How to call a standalone procedure within the package body?

Thank you

Hi shiva,

Nice explanation.
What are the disadvatage of packages in oracle please share in comments only

Very informative...