Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain when we are using
pre-query,post-query,pre-insert and post-insert?plz explain
with one example
- 2 Answers
- 15871 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Is it possible to execute a dynamic sql from forms?
How to create Drill down report?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
What do you understand by lov and how can it be used?
What is the difference between BPA AND Contract What are documents and test cases u followed
what are bind variables?
What is a canvas in oracle forms?
What is an SQL FORMS ?
where do u put the report file
Explain master-detail relationship with some examples.
What is a matrix report and how many minimum groups are required to prepare the same?
What is responsibility and how u attach How to create user and how u attach with responsibility.
Is it possible to have multiple layouts in a report?
How can we expand Parameter Form Canvas on Reports 6i?
