DevInline - Tech Blog

A database user having DBA role not able to create a table from package, it is hard to believe first but this is how it works. If a procedure (or a procedure inside a package) is executed roles are disabled automatically and so all grants associated…

Why Materialized views is preferred over views - It is commonly asked interview question for senior developer.In this post we will list out benefits of Materialized view over views. View  is static SELECT query stored as database object.The tables o…