Answer / umesh joshi

Package specification can be compiled without compiling
package body, whereas package body cannot be compile
without specification compilation

Answer / ajexpert

No.
Package body should contain the same number and type of
objects as declared in package specification

how to retrive only second row from table?

31 Answers   IBM,

---

What is sql clause?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

What is pl sql in oracle?

0 Answers  

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

how to use like conditions? : Sql dba

0 Answers  

---

How is data stored in sql?

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

how to include numeric values in sql statements? : Sql dba

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---