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
How do I connect to mysql database?
How are mysql timestamps seen to a user?
How to delete a database from mysql server.
Explain the difference between delete and truncate.
How to store binary data in mysql?
How do I remove a user from mysql?
Is mysql free download?
How do I truncate all tables in mysql?
What is mysql and how it works?
Is mysql a server or database?
How to use case expression?
How to get nth highest salary from table in a mysql?
What is the maximum connection pool size?
What is datadir?
Explain the different types of constraints?