Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql and plsql
- 6 Answers
- 10965 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 14 Yes | 1 No |
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.
| Is This Answer Correct ? | 7 Yes | 2 No |
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....
| Is This Answer Correct ? | 4 Yes | 0 No |
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,,
| Is This Answer Correct ? | 4 Yes | 1 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 .
| Is This Answer Correct ? | 0 Yes | 0 No |
What is java sql drivermanager?
what is sub-query? : Transact sql
Is left join faster than inner join?
What is Highwatermark?
What is left join example?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
What's the difference between a primary key and a clustered index?
What is dynamic sql in pl sql?
what is a composite key ? : Sql dba
What is sql profiling in oracle?
How can the performance of a trigger be improved?
What is mutating sql table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
