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.

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

Why join is faster than subquery?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

Is oracle sql free?

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What are crud methods?

0 Answers  

---

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

1 Answers   Polaris,

---

Is left join faster than join?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---