Function Purity Level

Function Purity LevelThe function purity level defines what structures the function reads or modifies.Purity levelsWNDS - Writes No Database State i.e. Function does not modify any database tables (No DML)RNDS - Reads No Database State i.e. Function does not read any tables (No select)WNPS - Writes No Package State i.e. Function does not modify any packaged variables (packaged variables are variables declared in a package specification)RNPS - Reads No Package State i.e. Function does not read any packaged variablesSyntax:PRAGMA RESTRICT_REFERENCES (function_name, WNDS [, WNPS] [, RNDS] [, RNPS])Tells the compiler the purity level you believe your function meets or exce...

Read More

Subquery Factoring

Subquery FactoringSubquery factoring, also known as the WITH clause, provides a convenient and flexible way to define subquries and in-line views. The primary purpose of subquery factoring is to reduce repeated table accesses by generating temporary data sets during subquery executi...

Read More

Difference between Post database commit and Post-form commit

Difference between Post database commit and Post-form commitPost-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in, issuing the command. The Post-database commit trigger fires after oracle forms issues the commit to finalized transactio...

Read More

altering user

SQL> ALTER USER username ACCOUNT LOCK;SQL> ALTER USER username ACCOUNT UNLOCK;To change the password for a user:SQL> alter user username identified by new_password;All at once:-- Expire, forces to change the password at first loginSQL> alter user username identified by password account lock password expi...

Read More