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
Write a query to display even rows in student table using mysql?
What are date and time data types in mysql?
How do I rename a mysql database?
Is mysql a server or database?
Why mysql is so popular?
What is the purpose of mysql database?
What is default schema in mysql?
How do I save in mysql?
Can we store images in mysql database?
Where is the mysql config file?
What is difference between mysql_connect and mysql_pconnect?
What is mysql sleep process?
What does the file with the extension: frm, myd, and myi contain?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
How we can create index in mysql?