Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by chandu bacham
Date Posted: 2015/10/07
Gayasuddin Mohammed
by 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.