what is the difrence between sql and pl/sql
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
Explain timestamp?
How many ways we can retrieve the date in result set of mysql using php?
What is difference between schema and table?
How to show table structure 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 the difference between the primary and unique key in mysql?
How do I save in mysql?
What is procedures in mysql?
How to connect html form to mysql database using php?
Does insert statement lock the table?
How can I create table in mysql?
What are stored procedures and functions?
Explain the difference between mysql and mysql interfaces in php?
How do I start mysql in mysql workbench?
How do I start mysql manually?