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

How to store only time; not date and time?

1018

---

How to add a new column to an existing table with a default value?

1016

---

When system tablespace is created?

1041

---

What is a parameter file in oracle?

1134

---

How can we find out the current date and time in oracle?

1088

---

How to save query output to a local file?

1026

---

What privilege is needed for a user to insert rows to tables in another schema?

1014

---

What are the parameters that we can pass through a stored procedure?

1064

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

---

What happens if variable names collide with table/column names?

1191

---

What is the minimum client footprint required to connect c# to an oracle database?

1092

---

How do we get field details of a table?

978

---

How would you go about verifying the network name that the local_listener is currently using?

2049

---

Where is the export dump file located?

1156

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---