45. INSERT in Teradata

INSERT

We  can use INSERT to add a new row to a table.

Syntax :

INSERT INTO table_name [(col_name [, ..., col_name])]  VALUES (expression [, ..., expression]) ;

Example :

INSERT INTO emp(empid, ename) VALIES(101. 'Arun Kumar');