Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE EXTERNAL TABLE StatementUse the CREATE EXTERNAL TABLE statement to define an external source that is not part of your database to load and unload data for your database.
External Table Examples The examples in this section illustrate different ways to load and unload data using external tables.
Loading Data from External Tables into HCL OneDB™To load data, you define the external data as an external table and then insert the data into the database.
Loading Between Tables That Have the Same SchemaYou can easily move data from an external table to a database table if the tables have the same schema.

Loading Between Tables That Have the Same Schema

You can easily move data from an external table to a database table if the tables have the same schema.

About this task

You can load data from one table to another table that has the same schema (for example, worldemp) with a simple INSERT statement.

INSERT INTO worldemp SELECT * FROM emp_ext;