Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27803 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
What is mysql routine?
What data type is money?
What is database migration in mysql?
How do you rename a table?
How many types of indexes are there in mysql?
How do I show users in mysql?
How do I quit mysql?
How to convert character strings to dates?
How to include numeric values in sql statements?
How does mysql clustering work?
What is the maximum number of records in mysql table?
What does mysqli_fetch_assoc do?
Is pdo faster than mysqli?
How do you concatenate strings in mysql?
What is the difference between the primary and unique key in mysql?
