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....

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

0 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

what is hash join

1 Answers   NCR,

---

How do you use join?

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

Is sql developer case sensitive?

0 Answers  

---

what is unique key constraint? : Sql dba

0 Answers  

---

Are stored procedures compiled?

0 Answers  

---

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,

---