Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 28095 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 you backup a database in mysql?
what is the difference between between and in operators in mysql?
How to make a column bigger and delete unique from table.
What is ibdata1?
What is the use of procedure in mysql?
How do I create a schema in mysql?
What is difference between mysql and mysql server?
What is unsigned in mysql?
How to find the unique values if the value in the column is repeated?
How to store values to array from mysql database in php?
What is the use of mysqli_query?
Why do we use the mysql database server?
Where is mysql installed on linux?
What is the difference between procedure and function in mysql?
Differentiate CHAR_LENGTH and LENGTH?
