How to insert multiple data in table using Oracle 12c Database?


Create Table
Create table Employee(
Empid Number(8) NOT NULL,
Ename varchar2(20) NOT NULL
);
Press Enter Key from Keyboard
Table was created.



Insert data into table
insert into Employee(Empid,Ename)values(&Empid,'&Ename'); Press Enter 
Enter value of Empid:11
Enter value of Ename:durgesh 
and press enter 
old 1:insert into Employee(Empid,Ename)values(&Empid,'&Ename')
new 1:insert into Employee(Empid,Ename)values(11,'durgesh')

OUTPUT:
1 row inserted.

Comments