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 .

How many types of triggers exist in pl/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  

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

How do I know if I have sql express or standard?

0 Answers  

What is cte sql?

0 Answers  

What is memory optimized?

0 Answers  

What does the acronym acid stand for in database management?

0 Answers  

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

Does a user_objects view have an entry for a trigger?

0 Answers  

Are views faster than queries?

0 Answers  

Explain how can you save or place your msg in a table?

0 Answers