What is pragma restrict_reference in oracle 9i?

What is pragma restrict_reference in oracle 9i? When do we use it?

Pragma restrict_reference is used to check for violations of any rules applied, at compile time. It’s used in functions to obey some purity check rules to control side effects. This particular pragma asserts that a particular function does not read/write database tables or package variables.

Eg:
PRAGMA RESTRICT_REFERENCES function_name RNDS/RNPS/WNDS/WNPS/TRUST
Why can't we assign not null constraint as table level constraint?
Not null constraint - Not NULL is a column level constraint to ensure that any value in that column is not null...
Use of between page triggers in REPORTS - oracle
The between-page trigger is used for creating conditional formatting, eg: retrieving information...
Delete all duplicate records using subquery - oracle
Delete all duplicate records using subquery - Query: DELETE from table1 where rowid not in (select MAX(rowid) from table1 GROUP BY column_name);...
Post your comment

Related Content

Follow us

▲