The RESTRICT_REFERENCES pragma asserts that a user-defined subprogram does

What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?

Question Posted / m.nihar

4 Answers
11669 Views
Microsoft, Wipro, I also Faced
E-Mail Answers

Answer Posted / m.nihar

The RESTRICT_REFERENCES pragma asserts that a user-defined subprogram does not read or write database tables or package variables.Subprograms that read or write database tables or package variables are difficult to optimize, because any invocation of the subprogram might produce different results or encounter errors.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a new table in your schema?

1025

How to connect to the server with user account: sys?

968

How to start an oracle instance?

950

How to define a data source name (dsn) in odbc manager?

962

Explain coalesce function?

1116

Explain the difference between sql and oracle?

1020

What are the restrictions in a oracle read only transaction?

963

What is the difference between primary key and unique key and foreign key in oracle?

915

What is an Oracle Instance?

1067

How to create a temporary table in oracle?

1189

How to download oracle database 10g xe?

957

How to declare a local variable?

1045

What is an oracle table?

929

How to connect the oracle server as sysdba?

1008

How can you use check constraints for self referential integrity?

911