Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is the difference between sql/pl-sql/embeded sql?

Answers were Sorted based on User's Feedback



What is the difference between sql/pl-sql/embeded sql?..

Answer / madhuri

SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.

PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.

Embedded sql are those statements which are written in host
programs like pro*c,java etc.

Is This Answer Correct ?    10 Yes 2 No

What is the difference between sql/pl-sql/embeded sql?..

Answer / siragam manjunath reddy

Both sql and pl/sql are languages used to acess data with in
oracle data base....sql writtens querys by using ddl,dml,dcl
etc...where plsql uses cursors,triggers,procedures etc..
In sql querys process at a time where as in plsql it done
step by step or recoed by record ...

Is This Answer Correct ?    3 Yes 0 No

What is the difference between sql/pl-sql/embeded sql?..

Answer / 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

More SQL PLSQL Interview Questions

What is anonymous block in sql?

0 Answers  


What is data abstraction in sql?

0 Answers  


how to check myisam tables for errors? : Sql dba

0 Answers  


What are expressions?

0 Answers  


What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  


I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,


What is the difference between a query and a report?

0 Answers  


Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  


Why do we need a foreign key?

0 Answers  


Is a foreign key always unique?

0 Answers  


What is rownum in sql?

0 Answers  


What are the types pl/sql code blocks?

0 Answers  


Categories