how to insert multiple rows values(records or tuple) in oracle sql

How to insert multiple rows in oracle sql

We can insert multiple row values or tuple in a single run by using begin and end commands as shown below:

Syntax:

begin
insert into table_name values(column1_values,column2_values,....);
insert into table_name values(column1_values,column2_values,....);
insert into table_name values(column1_values,column2_values,....);
.....
commit;
end;
/


image
insertion of multiple rows in oracle sql







For example if we want to insert values in a table emp which has five columns defined we can insert
as shown below.

begin
insert into emp values(1000,'xxx',15000,'aaa',30);
insert into emp values(1001,'yyy',18000,'aaa',20);
insert into emp values(1002,'yyy',20000,'aaa',10);
commit;
end;
/


Explanation:The above query will insert three rows or tuple in emp table.
We can see using select command as--

select * from emp;

output:






I  hope you have understood  .However if you have any doubt comment below in comment section.

Comments

Post a Comment

Popular posts from this blog

how to compile multiple file in java using single command

Some times we need to compile multiple files with a single command. Though most programmer use IDe but sometimes we have command lines only. If your case is like that then you can use any of the following methods- 1. Specify all the files manually javac File1.java File2.java File3.java 2. Compile all .java file in the directory javac *.java This will compile all the Java files in the current directory.
Read more

Error http://172.0.0.1:8080/apex application not found in oracle 10g Solved

Error  http://172.0.0.1:8080/apex  application not found Solved Hello, if you are facing problem in logging in oracle 10g express edition with the error http://172.0.0.1:8080/apex  application not found  then the following steps may solved your problem:-  1. Reinstall the application. or  2. Just type the following  url in your browser and make bookmark and open from there whenever required. http://127.0.0.1:8080/apex/f?p=4550:11:3495439254482246::NO::: Hope this may help you. Thanks.
Read more

Ternary operator and Nested Ternary operator

Ternary operator  Ternary operator which is a conditional operator and, as the name suggests, it takes three operands (parts). Ternary operator is available in most languages, like, C, C++, Java, JavaScript, etc  Syntax:-  variable = condition ? expression1_if_true : expression2_if_false Explanation: condition: This is a boolean expression that evaluates to either true or false. expression1_if_true: This is the value or statement that is executed if the condition is true. expression2_if_false: This is the value or statement that is executed if the condition is false.  Ternary operator is nothing, just a concise way of writing an if-else statement, i.e. the same operation can be achieved using an if-else block as shown below.  if(condition){     variable = value_if_true  }else{     variable = value_if_false  } Example 1 :- C program find max number among two given numbers using ternary operator #include <stdio.h> int mai...
Read more