The same values that you specify appear kov the list no matter which database portlet uses the LOV. All LOVs can be defined as static or dynamic. Select an application.
Any database portlet built using the column can use the LOV. Available options include: Icons the default displays each LOV as a large icon. Follow the on-screen instructions.
Related topics. The LOV also makes the entry field easier to use because the end user clicks the mouse to select a value rather than type it. To edit an LOV, click the name.
Oracle Portal developers can use LOVs when creating database portlets to pre-select the possible values in an entry field. The Application home appears.
Dynamic lists are based on a SQL query you write that selects values from a table. It contains all values in the column.
Click the Shared Components icon. EMP table. Static lists are based on predefined pairs of display values and return values.
Under User Interface, select Lists of Values. The wizards also allow the developer to choose a format for displaying the LOV; for example, as a radio button group or check boxes.
For example, you can change the default display by making a selection from View list. The Lists of Values appears.
To edit an LOV, click the appropriate icon. The database portlet build wizards contain steps that prompt an Oracle Iss developer to optionally choose an LOV for a column in the table or view on which the database portlet is based.
Details displays each LOV as a line in a report. Related topics Lists of Values LOVs enable end users to choose entry field values in a form or database portlet customization form. To create a new LOV, click Create.