Creating User-Defined Tables

Use this dialog box to define one or more user-defined tables in order to create a virtual “view” of the data from your database.

See About User-Defined Tables and User-Defined Table Examples.

  To access the User-Defined Table Dialog Box:

  1. Highlight the name of the appropriate data source in the Source Navigator.

  2. Select New, then User Defined Table.

  3. Define the new user-defined table:

    • Connection—Select the data source to which the table will be added.

    • Table name—Enter a name for the table.

    • Table definition—Enter the SQL statement to create the user-defined table using the SQL syntax required by the data source. This statement defines the names of the tables in the virtual view and can include any number of source column names. It becomes the basis for a logical table in the data source.

      Note:

      Oracle recommends including the full path when specifying database tables.