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
What are sql indexes?
What's the procedure?
What is a temporal data type?
What is an inconsistent dependency?
What is flag in sql?
Which table is left in left join?
What is the execution plan in sql?
what is online transaction processing (oltp)? : Sql dba
what is a primary key? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Who is the owner of mysql database?
What are tables and fields in the database?
what is the difference between primary key and unique key? : Sql dba
What is a natural join?
Why is stored procedure faster than query?