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
Are subqueries better than joins?
Which are the different case manipulation functions in sql?
Why we use pl sql?
Enlist the data types that can be used in pl/sql?
What is sql engine in oracle?
Explain scalar functions in sql?
Explain what is a subquery ?
Is natural join and inner join same?
What is recursive stored procedure?
Does sql between include endpoints?
Do we need to rebuild index after truncate?
Does sql full backup truncate logs?
Can a foreign key be a duplicate?
Can you inner join the same table?
What are sql injection vulnerabilities?