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

how is myisam table stored? : Sql dba

1094

---

Why do we use subquery?

1073

---

define data blocks ? : Sql dba

1042

---

What are the two types of exceptions in pl/sql?

1088

---

what are the differences between char and nchar? : Sql dba

1157

---

How can we debug in PL/SQL?

1175

---

Which is faster joins or subqueries?

1033

---

Does truncate need commit?

1001

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

---

What does select top 1 do in sql?

1138

---

Why do we use procedures in pl sql?

1068

---

Can a foreign key be null?

1142

---

What is the difference between local and global temporary table?

1083

---

Explain how exception handling is done in advance pl/sql?

1043

---

How do I get sql certification?

1015

---