what is the difrence between sql and pl/sql
- 21 Answers
- 24015 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / aditya
SQL Enter, Edit, Store & Retrieve by single command or
statement where as PL/SQL process all SQL statements one at
a time. With PL/SQL, an entire block of statements process
in a single command line.
SQL in a strucutred query language; where pl/sql is
procedures,function,variable,method all are present
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.
Actually this is the appropriate answer...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can mongodb replace mysql?
How to delete a column and add a new column to database
What is bdb (berkeleydb)?
How do I clear the command in mysql?
How to write optimized query in mysql?
What is database url for mysql?
What is the difference between truncate and delete in mysql?
What is localhost in mysql?
List the different types of normalization?
Is mysql free for commercial use?
How to use case expression?
What is the difference between timestamp and datetime in mysql?
What is a left join mysql?
What mysql means?
Why we use mongodb instead of mysql?
