D2k

Home » D2k

An Example of Pre-Query and Post-Query Triggers in Oracle Forms With Using Display_Item to Highlight Dynamically

Example is given for Pre-Query and Post-Query triggers in Oracle Forms, with using Display_Item built-in in Post-Query triggers to highlight fields dynamically. This is the screen shot below for this example: You can also download this form from the following link: Query.fmb The example is based on HR schema departments table. In this example Department No. …

An Example of Pre-Query and Post-Query Triggers in Oracle Forms With Using Display_Item to Highlight Dynamically Read More »

Why And When To Use Pre-Update and Pre-Insert Triggers In Oracle Forms

Whenever we commit after entering data in Oracle Forms, many triggers fires during this event and also Pre-Update and Pre-Insert triggers fires just before inserting or updating the record into table. We can write Pre-Update and Pre-Insert triggers on particular block to just allow the process or to stop the process by using "Raise Form_Trigger_Failure" …

Why And When To Use Pre-Update and Pre-Insert Triggers In Oracle Forms Read More »

Example of Get_File_Name Function in Oracle Forms

Displays the standard open file dialog box where the user can select an existing file or specify a new file. Syntax FUNCTION GET_FILE_NAME (directory_name VARCHAR2, file_name VARCHAR2, file_filter VARCHAR2, message VARCHAR2, dialog_type NUMBER, select_file BOOLEAN; Returns VARCHAR2 See also: A Practical example of Get_File_Name built-in Parameters directory_name Specifies the name of the directory containing the file …

Example of Get_File_Name Function in Oracle Forms Read More »