ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل chandu bacham
تاريخ النشر: 2015/10/07
Gayasuddin Mohammed
من قبل 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.

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟