Specify a formula for a view
- To specify a FORMULA , select a column from the selection grid and click Formula.
- Click to select a column, operator, or function.
- Double-click to add the selection to the clause. The clause is constructed in the Clause box below.
- Click OK when you are done constructing the formula.
- To avoid duplicate column names, you should rename the column name to something different. Click on the column
name of the column that you want to rename and specify a new name.
You may now:
- View or edit the SQL used to create the view
- Establish some selection criteria
If you want to do none of these, click OK to create your new view.