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
What is set operator oracle?
How to do paging with oracle?
What is ASM (Automatic Storage Management) in Oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Is oracle the best database?
How to use "startup" command to start default instance?
What is redo log?
Explain the use of consistent option in exp command.
Explain about integrity constraint?
How to best split csv strings in oracle 9i?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain an exception?
What is data block in Oracle?
Can group functions be mixed with non-group selection fields?
How to initialize variables with default values?