How to Insert multiple Rows in Teradata using SQL
we are creating a volatile table and trying to insert rows to the table.
create volatile table Example
(
ProductID VARCHAR(15),
Price DECIMAL (15,2)
)
on commit preserve rows;
Then 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 on 07 Aug 18Enjoy 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