Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27915 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 a join? Explain the different types of mysql joins.
What is delimiter in mysql trigger?
What is a storage engine?
What is query log in mysql?
What is the command line end user interface - mysql?
How to load a csv file into a table
How to install mysql?
What is field in mysql?
What does mysql flush hosts do?
Where is mysql password stored?
Why do we use views instead of tables?
Can we write procedure in mysql?
What are the 3 main types of search queries?
How to calculate the difference between two time values?
How do you know the version of your mysql server?
