A list of values is a single or multi column selection list displayed ina pop-up window
Latest Answer : An LOV is a scrollable popup window that provides the end user with either a single or multi-column selection List. ...
A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
Latest Answer : All LOVs are based on another Forms object called a record group. Record groups are logical objects, so they have no physical properties and are never displayed to the user. A record group is similar to a database table in that it stores an array ...
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list
Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list
Latest Answer : GET_PARAMETER_LISTDESTROY_PARAMETER_LISTCREATE_PARAMETER_LISTADD_PARAMETERDelete_parameterADD_LIST_ELEMENT(item, index, label, value) SET_PARAMETER_ATTR(List, key, paramtype, value) for a Date parameter defined at design timeGet_parameter_attr ...
A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.
Latest Answer : When you work in the Form Builder, you are creating binary files, and when you run an application, you are executing executable files. Forms stores its binary files with an .fmb extension and its executable files with an .fmx extension. The .fmx files ...
how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT
Latest Answer : 1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids and the match both vales. If both are equal then go ...