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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use join in subquery?

1020


Do foreign keys improve performance?

962


Which version of sql do I have?

993


What are different types of tables in sql?

939


Can %notfound return null after a fetch?

996


Can we join more than 2 tables in sql?

943


Why do we use triggers?

912


What does sign mean sql?

1017


Enlist the data types that can be used in pl/sql?

1001


What is the purpose of cursors in pl/sql?

1077


what is a database lock ? : Sql dba

1091


how can we know the count/number of elements of an array? : Sql dba

1003


What is file based approach?

874


What are the differences between implicit and explicit cursors?

999


Explain the working of foreign key?

972