Answer / bighnaraj dalai

Pre-Query is Used For Doing Proper Validation Before Any Query Related Operation .
Example:=

DECLARE
V_Where VARCHAR2(50);
V_OrderBy VARCHAR(100);
BEGIN
V_Where := 'Deptno = '||:CONTROLBLOCK.QUERYDEPT;
V_OrderBy := :CONTROLBLOCK.DATASORTGROUP||' '||:CONTROLBLOCK.SORTORDERGROUP;
SET_BLOCK_PROPERTY ('EMPBLOCK', DEFAULT_WHERE, V_Where);
SET_BLOCK_PROPERTY ('EMPBLOCK', ORDER_BY, V_OrderBy);
END;


Post-Query is Used For Doing The Tax After validation is complete


Example:=
INSERT INTO SCOTT.QueryAudit@ORCL
VALUES(1, USER, USERENV('TERMINAL'), TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 'DD-MON-YYYY'), TO_DATE(TO_CHAR(SYSDATE, 'HH:MI:SS'), 'HH:MI:SS'));

Pre-Insert is doing the tax before insert into the database


Example:=
MESSAGE('Pre Insert Trigger Fired...');
MESSAGE(' ');
SELECT EmpIncr.NEXTVAL
INTO :EMPBLOCK.Empno
FROM SYS.DUAL;
:GLOBAL.GENEmpno := :EMPBLOCK.Empno;
Post-Insert is Fired After The Data Insert Into The database
The Pre-insert And Post-Insert Helps For No Null Value Taken Even We Take Any Sequence In my Coading Because If There is no Proper validation Then The Raise Form_Trigger_Failure Trigger Terminate The Application


Hiiii friend if you Want To Take The .FMB File For This Program Or any Related Query Then Contact To Me
My Email_Id := bighnaraj.dalai@gmail.com

Answer / sudipta santra

PRE-QUERY: BEFORE PARSING OF QUERY THIS TRIGGER IS FIRED.

POST-QUERY: AFTER PARSING OF THE QUERY AND BEFORE POST TO
THE DB, IT IS FIRED.

NOTE: THE VALUE CAN BE CHANGED AFTER FIRING PRE-QUERY BUT
THE VALUE CAN NOT BE CHANGED AFTER FIRING POST-QUERY.

PRE-INSERT: BEFORE INSERT IN THE DATA-BLOCK, IT IS FIRED.

POST-INSERT: AFTER INSERT INTO THE DATA BLOCK AND BEFORE
POST INTO THE DB IT IS FIRED.

NOTE: THE VALUE CAN BE CHANGED IN PRE-INSERT BUT NOT
POSSIBLE IN POST-INSERT.

difference between place holder and formula column

3 Answers   Cognizant, IBM, Microsoft,

---

I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 Answers  

---

What are the triggers available in the reports?

3 Answers  

---

Can we use bulk collect in oracle forms if yes then how?

1 Answers  

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

0 Answers  

---

What is trigger associated with the timer?

2 Answers  

---

what is difference between group above and group left report

0 Answers   Oracle,

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

0 Answers   Intelligroup, TTPL,

---

Error_Code is a package proecdure ?

1 Answers  

---

How many types of trigger can be used in a table at a time ?

7 Answers  

---

Can a sigle canvas be used by different blocks ?

2 Answers  

---

Is it possible to set a filter condition in a cross product group in matrix reports?

1 Answers  

---