What are the components of a PL/SQL block ?

Answer Posted / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of indexing?

755


What are aggregate functions in sql?

862


Which command is used to delete a trigger?

993


What are transaction and its controls?

758


what is a relationship and what are they? : Sql dba

772


Does mysql_real_escape_string prevent sql injection?

711


what is a materialized view? : Sql dba

778


What is microsoft t sql?

700


Is primary key an index?

727


How do you explain an index?

1008


What is the basic structure of an sql?

787


how many tables will create when we create table, what are they? : Sql dba

790


Which function is used to return remainder in a division operator in sql?

808


What kind of join is join?

723


how tsql statements can be written and submitted to the database engine? : Transact sql

730