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
How to raise user-defined exception with custom sqlerrm ?
How does sql*loader handles newline characters in a record? : aql loader
Can we rollback truncate?
What are data types in pl sql?
What does count (*) mean?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is primary key in db?
Explain what is rdbms?
what are string data types? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how to enter numeric values as hex numbers? : Sql dba
Explain sql data types?
What are types of exception?
how to check server status with 'mysqladmin'? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba