What are the components of a PL/SQL block ?
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / nishi
Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Explain what is sql?
what is data integrity
what is the difference between truncate and delete statement? : Transact sql
How do I tune a sql query?
How do I start pl sql?
What is the purpose of the primary key?
What is the use of double ampersand (&&) in sql queries? Give an example
What is serial sql?
What is hibernate and its relation to sql?
select top 3 sal from each dept?
17 Answers IBM, TCS,
Explain the uses of a database trigger?
What is $$ in sql?