what is the difrence between sql and pl/sql
- 21 Answers
- 21229 Views
- Wipro, I also Faced
- E-Mail Answers
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
How to return query output in xml format?
I want to start and stop mysql on windows? How do I do that?
How to decrement dates by 1 in mysql?
Is mariadb faster than mysql?
What is mysqli_free_result?
How to use 'mysql' to run sql statements?
How can we get total number of records by query in mysql?
How do I rename a mysql database?
How to create a new table in mysql?
How to filter data from a mysql database table with php?
How do you stop an access query?
How do I restore a database in mysql workbench?
What is the use of mysqli_fetch_assoc?
What is default schema in mysql?
How database are managed?
