Answer / madhuri

sql is a structured query language which executes one sql
statement at a time where as pl/sql is a programming
language which embedd set of sql statements as a block and
executes it.Main advantage of pl/sql over sql is,we can use
control structures,cursors,subprograms and exception
handling in this case.

Answer / prabhakar

sql is the structure query language and plsql is the
programming structure query language which through we
create the program in oracle and all the program excute in
the oracle.

sql simply crate,delete,update the query
plsql programming can also do.

Answer / anil kumar jampana

one more advantage with pl/sql over sql is network traffic.
pl/sql reduces network traffic. bz, here we embeding all
sql statements together....

Answer / rajesh.k

sql is a structure query language,in which we are retriving
the data through statements from the database,it cannot be
used for later application,,,
pl/sql is a programming language it has the
declare
variables;
begin
sql smts;
exceptions
end;
in plsql thru stored programs like proc,func we can use for
later applications,,

Answer / k.srikanth

SQL IS A STRUCTURE QUERY LANGUAGE
PL/SQL IS A PROCEDURE LANGUAGE.
SQL USED FOR AN DDL,DML,ALL STAMENTS.PL/SQL USED FOR AN ALL
SQL STATMENTS USED AND CURSORS.

Answer / anjali

Sql is a standalone set of commands. Pl sql is procedural extension to sql where we embed sql statements inside pl sql block so that we can achieve re-usability of code .

what is the difference between join and union? : Sql dba

0 Answers  

What is record type in pl sql?

0 Answers  

when is the use of update_statistics command? : Sql dba

0 Answers  

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

What are sql data types?

0 Answers  

Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.

2 Answers  

What is execute immediate?

0 Answers  

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

What is integrity in sql?

0 Answers  

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

Why use subqueries instead of joins?

0 Answers  

What does pl sql stand for?

0 Answers