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

what are the drivers in mysql? : Sql dba

549


What is the most restrictive isolation level? : Transact sql

554


how mysql optimizes distinct? : Sql dba

549


Differentiate between % rowtype and type record.

727


What is the difference between sum and count in sql?

516






Write a sql query to get the third highest salary of an employee from employee_table?

630


What are the 3 types of behavioral triggers?

657


what is cross join? : Sql dba

568


How many indexes can be created on a table in sql?

494


What are the sql versions?

514


what is csv? : Sql dba

570


how tsql statements can be written and submitted to the database engine? : Transact sql

529


Why is partition used in sql?

545


What is the need of merge statement?

549


How do you get column names only for a table (sql server)?

663