what is sql and plsql

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to enter binary numbers in sql statements? : Sql dba

493


What are tuples in sql?

571


Is pl sql useful?

543


Why do we use sqlite?

536


What is an emotional trigger?

518






Is postgresql a server?

577


Enlist the advantages of sql.

573


Is pl sql a programming language?

550


Does sql*plus have a pl/sql engine?

572


What is sql and its types?

625


How do I run a sql query?

532


What is dynamic query?

542


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

553


Can you inner join the same table?

527


Can instead of triggers be used to fire once for each statement on a view?

541