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
Can we use join in subquery?
Do foreign keys improve performance?
Which version of sql do I have?
What are different types of tables in sql?
Can %notfound return null after a fetch?
Can we join more than 2 tables in sql?
Why do we use triggers?
What does sign mean sql?
Enlist the data types that can be used in pl/sql?
What is the purpose of cursors in pl/sql?
what is a database lock ? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
What is file based approach?
What are the differences between implicit and explicit cursors?
Explain the working of foreign key?