Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 27932 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 create a primary key?
What is mysql community server?
Which statement is used in a select query for partial matching?
What are aggregate functions in mysql?
How do I create a new database in mysql?
What is the maximum connection pool size?
What is data types in mysql?
What is current version of mysql?
How do I find the database name in mysql?
Is mysql a database?
What is memory table?
Is mysql relational?
How many rows can mysql handle?
What is max connections in mysql?
What is the difference between is null & is not null?
