Answer Posted / 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

What do you understand by oracle forms and why are they required?

1019

---

difference between global n context sensitive segments?

2678

---

Explain the different levels at which oracle form services interact.

1061

---

What do we mean by record group in oracle forms?

1076

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1979

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2128

---

how do u compile a form i.e .fmb file in Unix or in dos

4573

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2329

---

a text item is there what r the different types of triggers associated with it

2016

---

Is it possible to execute a dynamic sql from forms?

1076

---

In what sequence do triggers get fired by oracle forms?

966

---

all steps of bitmap report?

2355

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1906

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1303

---

did u p prepared complex report

2004

---