Inserting Multiple rows in oracle database | Tutorial 3
Inserting Multiple row in oracle database
Syntax :
INSERT ALL
INTO TABLE_NAME( COL2, COL1,....) VALUES ( COL2DATA,CO1DATA, ....),
INTO TABLE_NAME( COL2ii, COL2ii,....) VALUES ( CO1iiDATA, COL2iiDATA, ....),
............................................................................................................
...........................................................................................................
SELECT * FROM DUAL;
Example of inserting into employee table:
insert all
into employee ( id, name, age, location) values ( 3, 'Nawaraj', 23, 'Kathmandu')
into employee ( id, name, age, location) values ( 4, 'Ram', 13, 'Biratnagar')
select * from dual;
Note: abc is user in oracle database not a table
Please like, share and subscribe channel
On this page of the site you can watch the video online Inserting Multiple rows in oracle database | Tutorial 3 with a duration of hours minute second in good quality, which was uploaded by the user ItskhojNepal 14 October 2021, share the link with friends and acquaintances, this video has already been watched 232 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
