Answer / jprakash025

no its not compile .wt are the procedure or fun etc..
declare in the specification section .must define in the
package body .

Answer / rabindra nath das

i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w
------------------------------------------------------
Ans:-It will show you 'Warning: Package Body created with compilation errors.'
PLS-00323: subprogram or cursor'4thpackage name' is declared in a package specification and must be defined in the package body

because in package specification you are define 4 package
so you need to define 4 package under package body.

Answer / ayan

Procedures that are defined in package spec are public
procedures but procedures those are in package body but not
in package spec are private procedure. we cannot call
private procedure using
package_name.private_procedure_name.Private procedure
should be called from any public procedure.

Answer / jprakash025

yes it s complie

What is a join query?

0 Answers  

---

Is join an inner join?

0 Answers  

---

what is a composite key ? : Sql dba

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

---

What are the parts of a basic sql query?

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

what is explain plan?

4 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---