what is the difrence between sql and pl/sql
- 21 Answers
- 23934 Views
- Wipro, I also Faced
- E-Mail Answers
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
What is horizontally scalable?
How do I rename a table in mysql?
Does adding an index lock a table?
What, if a table has one column defined as TIMESTAMP?
What is database url for mysql?
How would you enter characters as hex numbers?
How do I view mysql logs?
What is mysql command line?
Where is mysql used?
How do I completely remove mysql from windows?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
How do I copy a table in mysql?
What is InnoDB?
How to use 'mysql' to run sql statements?
How can you retrieve a particular number of records from a table?
