Originally posted by Natik
What is a practical application of PRAGMA RESTICT REFERENCES? Where could it be used practically?
Nowadays that pragma has lost its meaning. But if you still using Oracle 8.0 or 7.3 then you must use that pragma for *packaged* functions, if you want to cal those functions from inside SQL statements. That pragma actually tells SQL parser the "purity level" of the called function. For example purity level "WNDS" guaraties to the parser that this function does not make any changes to the database when called. You don't need this pragma specified for standalone functions and you don't need it for packaged functions if they are to be called only in PL/SQL expressions. And you don't need it at all in 8i and above.
What are the benifits of using a sub-block(nested block) in a procedure or a function. What would be a senario where this could be used?
The most common use of sub-blocks would be when you want to handle exceptions for that particular piece of code explicitely, rather than handeling them for the whole main block.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?