What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
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
Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
Can you tell me how to add new column in existing views?how?How is possible?
How to start an oracle instance?
How to start instance with a minimal initialization parameter file?
Why do we need oracle client?
What is max rowid in oracle?
Explain oracle’s server parameter file.
What is backup in Oracle?
When system tablespace is created?
What is flashback in Oracle?
How to create a new oracle data file?
What are the types of trigger in oracle?
How to create a table index?
What is the simplest tool to run commands on oracle servers?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What privilege is needed for a user to create indexes in oracle?