Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Answer / p.rajasekar

When the referenced object's signature is changed the
procedure get invalidated or the referenced object is
changed or droped

Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Answer / rajesh

while the user don't have the sufficient privilege to
execute the procedure/package.or else while the owner of
the procedure/package alters the name of the
procedure/package it becomes invalidated....

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

What does closing a cursor do?

0 Answers  

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

What is schema in sql example?

0 Answers  

---

Is pl sql useful?

0 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

What is trigger types of trigger?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

How do I remove duplicates in two columns?

0 Answers  

---

How many parts of a pl sql block are optional?

0 Answers  

---