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
Can't connect mysql server on localhost?
What are numeric data types?
What is mvcc in mysql?
Can mysql scale horizontally?
How do you name a table?
How to drop an existing table in mysql?
How to convert character strings to dates?
How do I start mysql client?
What is query design?
How do I show columns in mysql?
What is the purpose of using a heap table?
How to get nth highest salary from table in a mysql?
Which is better sqlite or mysql?
How can you create and drop view in mysql?
Tell us something about heap tables?