Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 28745 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 latest version of mysql?
What can I do with mysql?
How can you move the master database
How to use 'mysql' to run sql statements?
Differentiate CHAR_LENGTH and LENGTH?
How to delete a column and add a new column to database
Is mysql good for big data?
What is regexp?
What are the other commands to know the structure of a table using mysql commands except explain command?
Does mysql scale well?
What are the mysql database files stored in system ?
What is slow query log in mysql?
Where is mysql used?
Where is mysql password stored?
How many columns can a table have?
