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);
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too