The Define Column dialog box enables you to create a new column in your query based on values in another column. Defined columns appear in both the Data source panel and the Results window.
This dialog box contains:
Defined Columns |
Specifies the name of the column you want to create. |
List box |
Lists existing defined columns. |
Defined as |
Specifies the expression of the selected column. The expression typically consists of a function or operation and the database column(s) to be operated on. If the column name occurs in more than one table, remember to reference the table name as well, and separate it from the column name with a period. If the column name is unique, you can specify just the column name. |
Define |
Applies the definition to the column. |
Remove |
Deletes the selected column. |
Paste Column |
Displays the Paste Column dialog box. |
Paste Func |
Displays the Paste Function dialog box. |
The defined column is only a part of your query and will not modify the table definition saved in the database.
Copyright © 1984, 2005, Oracle. All rights reserved.