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;

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is the non-clustered index in sql?

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

How many types of cursors are available in pl/sql?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

How many tables can a sql database have?

0 Answers  

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

What are analytic functions in sql?

0 Answers  

---