+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)
Uncategorized

STATIC AND NATIVE DYNAMIC SQL IN ORACLE DATABASE

In May 1994, Oracle introduced the Dynamic SQL concept in its Database version 7.1. With this it enabled developers to write the dynamic SQL through “DBMS_SQL” package. But, because of its “Not So Easy” syntaxes, the “Sluggish Performance” and “Unsupported User-Defined Types”, the DBMS_SQL library was not very successful. All these shortcomings raised the need […]

ROLE OF DATABASE ADMINISTRATOR

What is the role of Database Administrator? Database Administrators (DBAs) play a critical role in managing and maintaining databases, ensuring the smooth operation of systems that store and retrieve data. The key responsibilities are:- Database Administrators are responsible for the design, implementation, security, and performance of databases. Their role is crucial in ensuring that data […]

Scroll to top