what is the difrence between sql and pl/sql
Answer Posted / dinesh joshi
1)SQL is executed one statement at a time. PL/SQL is
executed as a block of code.
2)SQL tells the database what to do (declarative), not how
to do it. In contrast, PL/SQL tell the database how to do
things (procedural).
3)SQL is used to code queries, DML and DDL statements.
PL/SQL is used to code program blocks, triggers, functions,
procedures and packages.
4)You can embed SQL in a PL/SQL program, but you cannot
embed PL/SQL within a SQL statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to get a list of all tables in a database?
How do I view a mysql database?
What is the use of count function in mysql?
What are mysql functions?
How can I create a database in mysql?
What is msql?
what is the procedure to configure the application of mysql?
What is mysql used for?
What is the purpose of -> in the mysql terminal?
Is mysql a database?
Can I use mysql for free?
What is longblob?
How can you change the name of any existing table by using the sql statement?
What is the datatype for password in mysql?
How much does mysql cost?