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 are sql injection vulnerabilities?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

What is t-sql? : Transact sql

0 Answers  

---

Does a primary key have to be a number?

0 Answers  

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

---

What is output spooling in sql*plus?

0 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

Can a foreign key be a duplicate?

0 Answers  

---

What is the maximum size of sqlite database?

0 Answers  

---

Does oracle use sql?

0 Answers  

---