what is the difrence between sql and pl/sql
Answer Posted / dinesh joshi
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.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a cursor? : Mysql dba
How do I install mysql on windows 10 64 bit?
What is mysql community edition?
How do I copy a table in mysql workbench?
Is foreign key indexed mysql?
Write a query to fetch common records between two tables using mysql?
What is memory table in mysql?
How do I install mysql workbench?
How to use count function in mysql?
What is pdo connection?
What are the two types of queries?
How to delete a trigger in mysql?
How many mysql connections can handle?
How you will Show unique records.
What is the difference between having and where clause in mysql? Explain