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.

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What are crud methods?

0 Answers  

---

Explain polymorphism in pl/sql.

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

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

0 Answers  

---

What is a sql schema used for?

0 Answers  

---

What is field delimiter?

0 Answers  

---

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---