Copying table data

With 

Catalog Manager

, you can easily copy data from one table or view into another table or view.

The copy action functions within a range of sequential columns that begins with the first column in both the source and target tables or views.

To perform a copy action, the data formats in corresponding columns of each table must be compatible, as follows:

  • Any numeric data type is compatible with any other numeric data type.
  • CHAR, VARCHAR, and LONG VARCHAR data types are compatible.
  • All other data formats are compatible if the data type and length are identical.

This section contains the following topics:

Related topic

Browsing-and-editing-data

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*