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 difrence between sql and pl/sql

Answer Posted / antu

SQL is a data oriented language for selecting and
manipulating sets of data. PL/SQL is a procedural language
to create applications. You don't normally have a "SQL
application". You normally have an application that uses SQL
and a relational database on the back-end. PL/SQL can be the
application language just like Java or PHP can. SQL may be
the source of data for your screens, web pages and reports.
PL/SQL might be the language you use to build, format and
display those screens, web pages and reports.

Think of it like this: The code that makes your program
function is PL/SQL. The code that manipulates the data is
SQL DML. The code that creates stored database objects is
SQL DDL. DDL compiles the code that is written in PL/SQL.
PL/SQL may call SQL to perform data manipulation. The
commands that format the output of a tool are not related to
the SQL standard or to PL/SQL.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the full meaning of mysql?

955


How can we find out which auto increment was assigned on Last insert?

1075


What are the types of queries?

935


How do I select a database in mysql?

1044


How do I rename a table in mysql?

956


What is truncate in mysql?

929


What is insert query in mysql?

890


change column name and make a unique column so we get no dupes.

963


What is the use of concat() in mysql?

974


What is difference between mysql mysqli and pdo?

921


What is an example of a delimiter?

918


all the queries used in sql

2634


What is relational database in mysql?

909


How do you stop an access query?

895


How do stored procedures work?

1012