Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Hi i am new to oracle what is different between oracle sql and plsql and oracle dba?

user-image
Question ajoutée par chandu bacham
Date de publication: 2015/10/07
Gayasuddin Mohammed
par Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

Oracle corporation's one of the DB products is Oracle RDBMS, DBMS, ORDBMS.

SQL - Structured query language - is used for querying, update and for any changes to data stored on Oracle RDBMS. SQL is almost same for any DB vendors like Oracle, Sybase, MS, etc with slight changes in their syntax's and keywords, but the concept is same.

PL/SQL - Procedural Language/SQL- it is used to write procedural code blocks using SQL statements and saved on Oracle server side, it has got its own advantages  like network traffic reduction, compiled and stored at server side, reuse of the code blocks like procedures, functions, etc.

DBA- Data Base Administration - It is for the administration of Data base server like taking care of data size, backups, server health checks, authorization, user access control like providing access based on type of user, etc.

My2 cents in simple terms. Thanks.