INSERT
Insert one or more records into a table.
Syntax
INSERT INTO table < [(column-list)] < VALUES (value-list)
| select statement >> [ON [INSTANCE] instance] [WITH options]
INSERT INTO
Required.
table
Required. The name of the table to insert data into, as defined in the
Omnidex environment catalog or as assigned to a table created with the
create table command.
[(column-list)]
Optional if all columns are referenced in the value-list, otherwise required.
value-list | select statement
Required. Specify a list of values to be inserted into the table or a
select statement that will return the results to be inserted into the
table.
[ON [INSTANCE] instance]
Optional. Specify the instance that this command will be executed on.
If omitted, the current instance will be used.
[WITH options]
Optional - Specify options to be used for this command.
Options
Example
>INSERT INTO CUSTOMERS (COMPANY, CONTACT) VALUES ('DISC',
'JOHN DOE')
Top
|