Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 28079 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 the hostname for mysql database?
How many queries can mysql handle?
How to list or view all databases from the mysql server.
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is 1nf 2nf 3nf?
What is mysql57?
Can we write procedure in mysql?
Can you tell few best practices to be followed for optimization in sql?
What are the differences between mysql vs sql server?
What is mysqladmin flush hosts?
What is the difference between myisam dynamic and myisam static in mysql?
How do I start and stop mysql server?
Is mysql a server?
What is a mysql server?
What is inner join in mysql?
