Answer Posted / 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....

differentiate between float and double. : Sql dba

558

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

552

---

when is the use of update_statistics command? : Sql dba

500

---

How to use transactions efficiently : transact sql

541

---

Explain constraints in sql?

571

---

---

Explain what is a subquery ?

655

---

How is data stored in sql?

549

---

How can I get the number of records affected by a stored procedure?

574

---

Can a foreign key be null?

588

---

What is pl sql block in dbms?

526

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

534

---

Which software is used for pl sql programming?

519

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

684

---

Why use triggers in sql?

500

---

What are the various levels of constraints?

659

---