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


Please Help Members By Posting Answers For Below Questions

what is unique key constraint? : Sql dba

745


Explain locks? : Transact sql

740


Why is there a need for sqlcode and sqlerrm variables?

756


What is the difference between nvl function, ifnull function, and isnull function?

798


Are stored procedures faster than dynamic sql?

738






What is compute?

735


Can we use ddl statements in stored procedure sql server?

726


How does a covering index work?

693


What are the ways on commenting in a pl/sql code?

676


how to shut down the server with 'mysqladmin'? : Sql dba

737


Can you have more than one trigger on a table?

710


What are the types of keys?

671


What does closing a cursor do?

985


What is crud stand for?

746


What is nosql example?

780