Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27127 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
Restore database (or database table) from backup.
How to see table's field formats or description of table .
What is auto increment in mysql?
Is blocked because of many connection errors mysql?
How to show table structure mysql?
What are the applications required to support mysql?
What is difference between mysql and mysqli?
What is mysql server?
What is blob and clob?
What are the functions of commit and rollback statements?
What is row level locking?
How many triggers are possible in mysql?
how to connect a php script with the mysql database?
What is bigint in mysql?
What are the differences between char and varchar data types?
