How to Insert multiple Rows in Teradata using SQL
we are creating a volatile table and trying to insert rows to the table.
\n\ncreate volatile table Example\n(\n ProductID VARCHAR(15),\n Price DECIMAL (15,2)\n)\non commit preserve rows;\n
\n\nThen we can insert into the above volatile table using standalone insert statements:
INSERT INTO Example Values('John Snow',4);
INSERT INTO Example Values('Kaleesi',400);
INSERT INTO Example Values('Little finger',400);
nVector
posted onEnjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment