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

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

What are aggregate functions in sql?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

How do you remove duplicate records from a table?

0 Answers  

---

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

What is the unique index?

0 Answers  

---

What is the use of partition by in sql?

0 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---