Answer / madhuri

SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.

PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.

Embedded sql are those statements which are written in host
programs like pro*c,java etc.

Answer / 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 ...

Answer / swapna

SQL is Structured Query Language used for DDL,DML.
PL/SQL is used for Cursors and Triggers .

Embeded SQL is used to embed SQL statements in
C,Cobol,Pascal,Foxpro like languages.

Embedded SQL - SQL statements are invoked from a host
environment like C/C++, Java or any other programming
languages.

how view used for security purposes?

3 Answers   Glam India,

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

What is file based approach?

0 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

Can we use joins in subquery?

0 Answers  

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

What is parallel hint?

0 Answers  

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---