Answer Posted / 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 |
Post New Answer View All Answers
What is cursor and why it is required?
How many row comparison operators are used while working with a subquery?
How do I find duplicates in the same column?
What are the differences between implicit and explicit cursors?
Why cross join is used?
what is recursive stored procedure? : Sql dba
What is cursor in pl sql with examples?
What is the difference between nvl function, ifnull function, and isnull function?
Can primary key be changed?
What is the usage of the distinct keyword?
Difference between table function and pipelined function?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is sql basics?
What is primary key and foreign key with example?
What does select top 1 do in sql?