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
What is the full meaning of mysql?
How can we find out which auto increment was assigned on Last insert?
What are the types of queries?
How do I select a database in mysql?
How do I rename a table in mysql?
What is truncate in mysql?
What is insert query in mysql?
change column name and make a unique column so we get no dupes.
What is the use of concat() in mysql?
What is difference between mysql mysqli and pdo?
What is an example of a delimiter?
all the queries used in sql
What is relational database in mysql?
How do you stop an access query?
How do stored procedures work?