Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27129 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
How do I edit a table in mysql?
What is the datatype for password in mysql?
What is the difference between unix timestamps and mysql timestamps?
What is a delimiter in mysql?
What is schema in mysql?
Is mysql same as sql?
How to delete a table.
What is tee command in mysql?
How would concatenate strings in mysql?
What is csv?
Can we rename database in mysql?
What is meant by decimal (5,2)?
What is a definer?
How do I start mysql server?
How do I view data in mysql workbench?
