Answer / a.jyothsna

Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;

Answer / nishi

Declare section

---

declaring the variables

---

Begin section

---

executable statements

---

Exception section

---

exception handlers

---

end;

Answer / vijay_1994

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

What is t sql in sql server?

0 Answers  

---

How does a covering index work?

0 Answers  

---

What is sap sql anywhere?

0 Answers  

---

What are the two types of exceptions.

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

Which is better join or inner query?

0 Answers  

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---