Answer / sanjeev verma

A Storeprocedure is a Set of transactionl SQL statements
which will do some operation. Storedprocedure is
precomplied . When we use sp's in our application it will
reduce network traffic because we need to just call the sp
from our appliaction by using the name of the sp and the
parameters, and no need of writing queries in the code.

A package is a collection of storedprocedures. A package
should have a declaration part and a body part. The
declaration part is used to declarte the stored procedures
and the body part is used to implement the storedprocedures.

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

what is hash join

1 Answers   NCR,

---

How many tables can a sql database have?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

What is auto increment in sql?

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

What are the uses of sysdate and user keywords?

0 Answers  

---

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---