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

How do I truncate a word?

705


What is server name sql?

804


What are the advantages of indexing?

731


Why functions are used in sql?

706


What is the difference between delete and truncate commands?

693






How can we link a sql database to an existing android app?

735


What is sequence in sql?

722


what is a record in a database ? : Sql dba

768


Why we use pl sql?

714


What is sql not null constraint?

779


What is sql*loader and what is it used for?

748


Is sql easier than java?

737


What is the use of index in hive?

729


What is primary key and unique key?

767


How do I trace sql profiler?

708