 Related Questions Latest Answer : Fires when Form Builder would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria. FORM AND BLOCK LEVELEXAMPLEIF Get_Application_Property(DATASOURCE) = 'DB2' ... Latest Answer : To writeDeclareT_filename Text_Io.File_Type;w_NewLine varchar2(200); BeginT_filename := Text_Io.Fopen('c:test.txt', 'W');Text_Io.Put_Line(T_filename,'this is test');Text_Io.Fclose(T_filename);End;To ReadBeginT_filename ... What is the correct sequence of firing triggers in Forms1) Pre-form2)Pre-block3)When-new-form4)When-validate-item5)Post-block Latest Answer : Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key. ... Read Answers (3) | Asked by : V Rajesh Nair Latest Answer : In the KEY-NEXT-ITEM trigger write the plsql codeselect enum,rowid into :ENUM,:ROWID from EMPLOYEE e where rowid Read Answers (3) | Asked by : nitin kumat I want to exchange the content of a text_box to another text box,then the value should get exchanged I want to exchange the content of a text_box to another text box,then the value should get exchanged with the mouse event trigger,how is it possible? Read Answers (1) | Asked by : BhaskarGouda 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
