Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27771 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 does the file with the extension: frm, myd, and myi contain?
Create table employee (eno int(2),ename varchar(10)) ?
What are string data types?
What is relational database in mysql?
How to convert numeric values to character strings?
What is the full meaning of mysql?
Explain the difference between procedure and function in mysql?
Write a query to fetch common records between two tables using mysql?
What is trigger in mysql with example?
Can varchar be primary key?
what is the difference between gui testing and database testing? : Mysql dba
How we can see all indexes defined for a table in mysql?
How do I connect to a mysql database?
In how many ways we can retrieve data in the result set of mysql using php?
What is sql vs mysql?
