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
What is definer in mysql trigger?
What is back end and front end?
How to find second highest salary from a table?
What causes mysql too many connections?
What is mysql slow query?
How do I change directories in mysql?
Describe mysql transaction properties.
Why do we use preparedstatement?
What ascii 31?
Can python connect to mysql?
What is datadir?
What is mysql primary key?
What are the indexes in mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Where MyISAM table will be stored and also give their formats of storage?