What is the difference between SQL and PLSQL
Answers were Sorted based on User's Feedback
Answer / sunil bisht
SQL is the only language through which you create or modify
data and structures in Oracle. Although other tools will
connect with the database, they all use SQL to read and
modify data.
Oracle's PL/SQL is a programming lanuguage that extends SQL
to include procedural elements, such as loops and whatnot.
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / khan tauseef
SQL is structure Query Language whereas PL/SQL is Procedural
Language Structure Query Language.
SQL does not have Stored Procedures/Stored Functions whereas
PL\SQL has.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / g.sivanagaraju
SQL is a standard structured query language for all the Relational Databases using SQL we can INSERT,UPDATE,DELETE,RETRIEVE and MODIFY the structure of the database.
PLSQL is procedural level extension to the SQL. PLSQL uses Data Manipulation power of SQL and procedural power of some other languages.
PGA gets created by ORACLE SERVER while working in PLSQL environment unlike SQL, SGA.
We can perform complex level validations using PLSQL unlike SQL.
Is This Answer Correct ? | 4 Yes | 0 No |
Is sql harder than python?
what is a relationship and what are they? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
Can you selectively load only those records that you need? : aql loader
Explain table and field in sql?
How much does sqlite cost?
What are stored procedures used for?
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
how to enter binary numbers in sql statements? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Why query optimization is needed?
What normalization means?