Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

How do you create a new session while open a new form?

1 Answers  


What is a Layout Editor?

2 Answers  


What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,


Is it possible to attach same library to more than one form?

1 Answers  


hiding item in report how like that properly,thats manually but at runtime i want to do

1 Answers  






.fmb will be in which folder

2 Answers  


What is the usage of the confine mode in Layout Editor ?

2 Answers   Convergys,


What is a list item?

1 Answers  


Name of the functions used to get/set canvas properties?

1 Answers  


To execute row from being displayed that still use column in the row which property can be used?

1 Answers  


what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 Answers  


List the Types of Items?

1 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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 (509)
  • 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)