what is the difrence between sql and pl/sql
- 21 Answers
- 23910 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
What is mysql installer?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is the data source name for mysql?
How do you create a primary key?
How do I switch users in mysql?
How do you rename a table in mysql?
Where is mysql data stored linux?
What is ISAM?
Explain Access Control Lists.
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
How do I install and use mysql?
How to store values to array from mysql database in php?
How to show certain selected rows with the value "pcds".
What is the datatype for password in mysql?
Is mysqli secure?
