Answer Posted / bhaskar gouda

First of all ,it is a compiler directive,This is introduced
to avoid the side affect of the function in a package .it
comes in 4 flavors.RNDS,WNDS,RNPS,WNPS.
each out of the above 4 can be implemented against the
packaged function.

If you want the function not to alter the contents of any
database table than you can use WNDS.similarly if you want
the function not to read the contents of any database table
you can use RNDS.If you want the function not to alter any
variables within another package than you can use WNPS.If
you want the packaged function not to read the variables
within another package than you can use RNPS.


Thanks-Bhaskar Gouda

What are the differences between char and nchar in oracle?

1143

---

What is oracle instant client?

1067

---

How to rename an index in oracle?

1169

---

Explain the use of show option in imp command.

1148

---

What is the max number of columns in an oracle table?

1046

---

How to create tables for odbc connection testing?

1206

---

How to load a large xml file?

1106

---

What is a connect identifier?

1084

---

What happens if the imported table already exists?

1077

---

What do database buffers contain?

1083

---

How to delete a column in an existing table?

1130

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2297

---

What is sequence?

1136

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

---

What is the data type of dual table?

1064

---