plz explain when we are using
pre-query,post-query,pre-insert and post-insert?plz explain
with one example
Answers were Sorted based on User's Feedback
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 |
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.
Is This Answer Correct ? | 2 Yes | 0 No |
How can a text file be attached to a report while creating in the report writer?
running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?
What is a Non Query Record Group?
how to hide the scroll bar in forms 6i
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
What is the built_in routine used to count the no of rows in a group?
What is an oracle report? List its various types.
How can we expand Parameter Form Canvas on Reports 6i?
Can a sigle canvas be used by different blocks ?
How do you reference a Parameter?
What are the built-ins used for finding object ID functions?