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 .

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

How to Declare Fixed Length String Value In PL SQL

0 Answers  

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

what is a database lock ? : Sql dba

0 Answers  

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

What are the uses of sysdate and user keywords?

0 Answers  

What is procedure and function?

0 Answers  

What is compute?

0 Answers  

What is the best partition size for windows 10?

0 Answers