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
Can triggers stop a dml statement from executing on a table?
What packages are available to pl/sql developers?
Define select, insert, create, delete, update, drop keywords
How to run sql functions in pl/sql?
what is subquery? : Sql dba
What is dml and ddl?
Explain the difference in execution of triggers and stored procedures?
Is clustered index a primary key?
how many columns can be used for creating index? : Sql dba
How do I truncate a sql log file?
what are properties of a transaction? : Sql dba
What is a unique constraint?
What are sql functions? Describe the different types of sql functions?
What is a recursive join sql?
What is function and procedure?