Example: Insert Ordered Entries - Teradata Vantage

You can achieve the same result with the following statement:

     INSERT INTO employee (10005,'Orebo B',300,,,,'Nov 17 1957',
     'M',,,18,);

Using this form, you do not specify column names for fields because you enter the field data in the same order as the columns are defined in the employee table. In all cases, a comma is required as a place marker for any field for which data is not specified.

For ANSI compliance, use the keyword NULL for nulls, for example, (10005, ‘Ore60B’, 300, NULL, NULL, NULL, ‘Nov 17 1957’, ‘M’, NULL, NULL, 18).