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 unique key constraint? : Sql dba
Explain locks? : Transact sql
Why is there a need for sqlcode and sqlerrm variables?
What is the difference between nvl function, ifnull function, and isnull function?
Are stored procedures faster than dynamic sql?
What is compute?
Can we use ddl statements in stored procedure sql server?
How does a covering index work?
What are the ways on commenting in a pl/sql code?
how to shut down the server with 'mysqladmin'? : Sql dba
Can you have more than one trigger on a table?
What are the types of keys?
What does closing a cursor do?
What is crud stand for?
What is nosql example?