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
Which is faster mysql or mongodb?
How to find the unique values if the value in the column is repeated?
Explain % and _ inside like statement?
How do I tune a mysql query?
How do I know if mysql is running on windows?
How to set the time zone for MySQL to particular country time?
What is 'mysqld'?
How do I save in mysql?
What is pdo in mysql?
How is oracle different from mysql?
What is the use of mysqli_fetch_assoc?
What is the difference between mysql_connect and mysqli_connect?
How large can a mysql table be?
What is a trigger? How you can create a trigger in mysql?
What is the use of i-am-a-dummy flag in mysql?