what is the difrence between sql and pl/sql




Answers were Sorted based on User's Feedback



what is the difrence between sql and pl/sql..

Answer / rsr

I donot know about the people posting answer here with
correct sense or not. Beacuse many of candidate use this
forum as reference. This kind of answers will mis guide
them.

Is This Answer Correct ?    44 Yes 4 No

what is the difrence between sql and pl/sql..

Answer / m.balarami reddy

SQL is the strutctured query language but pl/sql is the
procedural language sql.difference is in pl/sql we can work
with data in the form by writing program which has
predefined structure. but sql does not have.

Is This Answer Correct ?    31 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / 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




what is the difrence between sql and pl/sql..

Answer / sandhya

Thanks for the reply and suggestions
But people Please dont talk jargunds.
Can someone comeup with an explanation understandable to a
lay man.
Thanks in advance!!!

Is This Answer Correct ?    5 Yes 1 No

what is the difrence between sql and pl/sql..

Answer / kalyana chakravarthy

SQL is structured query language which is used to retrive
data from the database. Before 1974 it is known as Gupta
SQL. In 1974 Relational solutions Inc(Now oracle
corporation) taken it as a native lang to retrive data.
Though it is structured quer language it is un structured
its like simple english language.

Pl/Sql is an extension for Sql. It is a structured 4th
generation language where one can execute more than one
select statement with conditional constructs like if, then
and else.

Is This Answer Correct ?    3 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / tushar matere

SQL is a structured query language.
Actually SQL is a set of rules defined by mr.Codd.
Any database like oracle,derby or sybase has to follow
these rules.We can say that database following maximum
codd's rule(there are 12 rules) is better than other like
oracle follows 11 rule so it is better than other.

there are different categories in SQL
MySql-->supports triggers and cursors
Pl/Sql-->supports procedures.
Tl/Sql-->supports transactions.
MSSql-->it is microsoft version of SQL.

Is This Answer Correct ?    2 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / dinesh joshi

1)SQL is executed one statement at a time. PL/SQL is
executed as a block of code.
2)SQL tells the database what to do (declarative), not how
to do it. In contrast, PL/SQL tell the database how to do
things (procedural).
3)SQL is used to code queries, DML and DDL statements.
PL/SQL is used to code program blocks, triggers, functions,
procedures and packages.
4)You can embed SQL in a PL/SQL program, but you cannot
embed PL/SQL within a SQL statement.

Is This Answer Correct ?    2 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / raghu

Its too bad .why professsional are behaving in this manner.

Please dont misguide && Dont waste time...

Is This Answer Correct ?    1 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / suman

Hello you people know nothing...but dont worry im here for u
sql is structered query language..it's structured in the sense that you cant change the predefined structure of the statements.even if you plan to do..
But if you plan to work on data using your own planning you must have to write sql in a programming way thats called planning sql or in short pl sql

Is This Answer Correct ?    1 Yes 0 No

what is the difrence between sql and pl/sql..

Answer / aditya

SQL Enter, Edit, Store & Retrieve by single command or
statement where as PL/SQL process all SQL statements one at
a time. With PL/SQL, an entire block of statements process
in a single command line.

SQL in a strucutred query language; where pl/sql is
procedures,function,variable,method all are present
1)SQL is executed one statement at a time. PL/SQL is
executed as a block of code.
2)SQL tells the database what to do (declarative), not how
to do it. In contrast, PL/SQL tell the database how to do
things (procedural).
3)SQL is used to code queries, DML and DDL statements.
PL/SQL is used to code program blocks, triggers, functions,
procedures and packages.
4)You can embed SQL in a PL/SQL program, but you cannot
embed PL/SQL within a SQL statement.
Actually this is the appropriate answer...

Is This Answer Correct ?    1 Yes 0 No

Post New Answer



More MySQL Interview Questions

What is a tinyint?

0 Answers  


How many columns can you create for an index?

0 Answers  


How do I flush privileges in mysql?

0 Answers  


Is postgresql better than mysql?

0 Answers  


How to delete a database from mysql server.

0 Answers  






Write a query to find duplicate rows in table?

0 Answers  


What is data types in mysql?

0 Answers  


What is procedural api?

0 Answers  


What do you need to connect php to mysql?

0 Answers  


What is innodb_buffer_pool_size?

0 Answers  


Why use mysql procedures?

0 Answers  


What are mysql functions?

0 Answers  






Categories