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
how to increment dates by 1 in mysql? : Sql dba
What is sql catalog?
Is left join faster than join?
Who is the owner of mysql database?
Which are the different case manipulation functions in sql?
What will you get by the cursor attribute sql%rowcount?
describe transaction-safe table types in mysql : sql dba
Do we need to rebuild index after truncate?
What is view? Can we update view
What is the difference between the sql*loader and import utilities? : aql loader
how can we optimize or increase the speed of a mysql select query? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is data abstraction in sql?
What are keys in sql?
What is the use of %rowtype?