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
Which table is left in left join?
What is a loop in sql?
What is insert command in sql?
What is use of package in pl sql?
What is the use of primary key?
How can you select unique records from a table?
Is left join same as join?
What is bind reference and how can it be created?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Why having clause is used in sql?
What do you mean by stored procedures?
How can I delete duplicate rows?
Write the alter statement to enable all the triggers on the t.students table.
Is a view faster than a stored procedure?