|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : 1)On select fires first.On select fFires when Forms Developer would normally execute the open cursor, parse, and execute phases of a query, to identify 2)On fetch fires nextWhen a query is first opened, on-fetch fires immediately after the On-Select trigger ... Latest Answer : Using :system.last_query ... What is the correct sequence of firing triggers in Forms1) Pre-form2)Pre-block3)When-new-form4)When-validate-item5)Post-block How add the values at run time to the report parameter ?dname:ename :Suppose i select dname(sales) , How add the values at run time to the report parameter ?dname:ename :Suppose i select dname(sales) , who belongs to that dname those employee name add to the ename Read Answers (1) | Asked by : Thrimurthulu What are the triggers that fires at form level, block level and item level at the time of query execution and What is the heirerchy Read Answers (1) | Asked by : pushpendra Latest Answer : 1) Which trigger are created when master -detail rela?1) master delete property * NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details * ISOLATED a) on clear detailsb) on populate ... What is the business reason for using triggers and what sequence they get fired when control transfer from one text item to next text item ? we can restrict duplicate entries in the form cheak which coloum can be maintained uniquenessfor that coloumn item text write a trigger when_key_navigatedeclaree_empno number(5);cursor c is select * from View Question | Asked by : Ramesh i want to retrieve data from table where apply date field from table which likedate = sysdate,so i not got a data , what i doe.g.select date from abc where date = sysdate;this is right or wrong ,plz give Latest Answer : select app_date from application where app_date=sysdate;The above query is right but may not fetch record.sysdate defult format is = 'dd/mm/yyyy hh:mi:ss'app_date might format may be = 'dd/mm/yyyy'so please writeselect app_date from applicationwhere trunc(app_date)=trunc(sysdate) ... How many times pre query and post query fired when we fetch 10 record from a table ? Latest Answer : These two are Query based write, once U fires the query before the query Pre Query fires only one time when the query executed the 10 rows are executed which means post Query is also fires only one time ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
