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
What do you mean by % and _ in the LIKE statement?
How will you export tables as an xml file in mysql?
How to copy data from one server to another using php?
What are the common mysql functions?
In which format data is stored in mysql database?
How do I free up space in mysql?
How do I rename a mysql database?
What is mysql workbench used for?
How you will Show unique records.
What is the use of mysqli_connect in php?
How can you count the total number of records of any table?
How can you export the table as an xml file in mysql?
How do I copy a table in mysql?
Can python connect to mysql?
How do you insert a table?