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 are the oracle DML commands possible through an update strategy?
What is the scope of a local variable?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is a package ? What are the advantages of package ?
What is a trigger and what are its types in oracle?
What is primefaces used for?
What is an oracle tablespace?
Can we store pictures in the database and if so, how it can be done?
What is the difference between 10g OEM and 11g OEM?
What is dual table oracle?
What happens to the current transaction if the session is ended?
Does oracle charge for java?
What are dml statements in oracle?
Which is better Oracle or MS SQL? Why?
What is a snapshot in oracle database?