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
what is mysql optimization in brief?
How can I remotely connect to mysql database?
What are date and time data types?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
Why do we need mysql?
Is Mysql query is case sensitive?
What is the use of count function in mysql?
How do I run mysql without installing?
What is mysqli procedural?
If we use sum function in mysql, does it return sum of that row or for that column?
How do I start mysql client?
What is 'mysqldump'?
How to create trigger in mysql workbench?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How many mysql connections can handle?