Answer / tulsi

PROCEDURE name (parameter list.....)
is
local variable declarations

BEGIN
Executable statements.
Exception.
exception handlers

end;

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

What are pl/sql packages?

0 Answers  

---

What is an intersect?

0 Answers  

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

What is the difference between left join and left outer join?

1 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  

---

Can we create table inside stored procedure?

0 Answers  

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

What is dba in sql? : SQL DBA

0 Answers  

---