Difference between procedure and function.

Difference between procedure and function.
A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable.

Read More

Difference between database triggers and form triggers?

Difference between database triggers and form triggers?
Database triggers are fired whenever any database action like INSERT, UPATE, DELETE, LOGON LOGOFF etc occurs. Form triggers on the other hand are fired in response to any event that takes place while working with the forms, say like navigating from one field to another or one block to another and so on.

Read More

Differentiate between TRUNCATE and DELETE.

Differentiate between TRUNCATE and DELETE.
The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data

Read More

Function Purity Level

Function Purity Level
The function purity level defines what structures the function reads or modifies.Purity levels
WNDS - 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 variables
Syntax:
PRAGMA RESTRICT_REFERENCES (function_name, WNDS [, WNPS] [, RNDS] [, RNPS])Tells the compiler the purity level you believe your function meets or exceeds

Read More

Subquery Factoring

Subquery Factoring
Subquery 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 execution.

Read More

Difference between Post database commit and Post-form commit

Difference between Post database commit and Post-form commit
Post-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 transactions.

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 expire;

Read More

ORACLE BOOKS

plsql books

1.Oracle PL/SQL Best Practices by Steven Feuerstein second edition
2.Oracle PL/SQL Programming by Steven Feurstein
3.Oracle Pl/SQL by Scott Urman
4.Oracle JDeveloper 10g for Forms & PL / SQL Deve... by Peter Koletzke
5.Oracle Database 10g PL / SQL Programming by Scott Urman

forms and reports

1: Oracle Developer Advanced Forms and Reports by Peter Koletzke.
2.Oracle Reports 6i published by Pinnacle Software Solutions.
3.oracle 6i developer from bpb publication
4.Oracle Forms Developer -- The Complete Video Course Benjamin Rosenzweig, Baman Motivala
5.Oracle 6i developer from bpb publication

Read More