Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difrence between sql and pl/sql
- 21 Answers
- 28033 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 to update info already in a table and delete a row(s) from a table.
What mysql -u john -p command does?
Is mysql server free?
What is the data type for file in mysql?
What is csv?
How to get nth highest salary from table in a mysql?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is mysql and why it is used?
What is the use of procedure in mysql?
Why should I learn mysql?
What sql does mysql use?
What is limit in mysql?
What is dbms in mysql?
How do I copy a table in mysql?
How to return query output in html format?
