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



plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one..

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

Is This Answer Correct ?    3 Yes 0 No

plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one..

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

Post New Answer

More Oracle Forms Reports Interview Questions

What are the different types of Coordinations of the Master with the Detail block?

2 Answers  


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

0 Answers   Convergys,


What are the three types of user exits available ?

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 do you understand by lov and how can it be used?

0 Answers  


What is an Alert ?

2 Answers  


i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how

1 Answers  


When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 Answers  


can i send the control file path as a parameter

1 Answers  


Which of the two views should objects according to possession?

1 Answers  


What is a physical page ? & What is a logical page ?

2 Answers   Techbooks,


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

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)