What is the difference between sql/pl-sql/embeded sql?
Answer Posted / swapna
SQL is Structured Query Language used for DDL,DML.
PL/SQL is used for Cursors and Triggers .
Embeded SQL is used to embed SQL statements in
C,Cobol,Pascal,Foxpro like languages.
Embedded SQL - SQL statements are invoked from a host
environment like C/C++, Java or any other programming
languages.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is rownum?
What is primary and foreign key?
What are few of the schema objects that are created using PL/SQL?
How many types of triggers exist in pl/sql?
What is a native sql query?
Can you have more than one key in a database?
Write a sql query to find the names of employees that begin with ‘a’?
What is difference between sql and excel?
Explain sql data types?
how do you control the max size of a heap table? : Sql dba
What is the difference between clustered and non-clustered indexes?
what is a constraint? Tell me about its various levels. : Sql dba
what is a trigger in mysql? : Sql dba
What is multiple partition?
What is the difference between null value, zero, and blank space?