Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between SQL and PLSQL

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


Please Help Members By Posting Answers For Below Questions

Can triggers stop a dml statement from executing on a table?

1093


What packages are available to pl/sql developers?

1057


Define select, insert, create, delete, update, drop keywords

1048


How to run sql functions in pl/sql?

1052


what is subquery? : Sql dba

1132


What is dml and ddl?

958


Explain the difference in execution of triggers and stored procedures?

1022


Is clustered index a primary key?

949


how many columns can be used for creating index? : Sql dba

946


How do I truncate a sql log file?

1074


what are properties of a transaction? : Sql dba

1094


What is a unique constraint?

1070


What are sql functions? Describe the different types of sql functions?

1142


What is a recursive join sql?

1070


What is function and procedure?

1030