The Select Form allows you to select input values from a list of values, and dynamically retrieve the selected values as defined in the paragraph.

1. Open the notebook in which you want to add the text input form.
2. In a SQL statement, define the Select form by using the syntax:
   ${formName=defaultValue,option1|option2...}.
   For example, run the SQL statement:
   SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = '${OBJ=INDEX,INDEX|TABLE|VIEW|SYNONYM}';
   
   In this example,
   • The form name is obj
   • The list of available values are INDEX, TABLE, VIEW, SYNONYM.
   • The table name is ALL_OBJECTS
   • The column name is OBJECT_TYPE
   Select any values from the drop-down list in the obj form. The selected value will be retrieved in the OBJECT_TYPE column in the ALL_OBJECTS table.