Record Insertion

Q:3
Insert data in the fields EmpNo, Name, Designation, Department and BasicPay. 
(at least 5 records)


SQL> INSERT INTO EMPLOYEE(EMPNO,NAME,DESIGNATION,DEPARTMENT,BASICPAY)
  2  VALUES(&EMPNO,'&NAME','&DESIGNATION','&DEPARTMENT',&BASICPAY);
Enter value for empno: 1
Enter value for name: SAYAN
Enter value for designation: MANAGER
Enter value for department: FINANCE
Enter value for basicpay: 50000
old   2: VALUES(&EMPNO,'&NAME','&DESIGNATION','&DEPARTMENT',&BASICPAY)
new   2: VALUES(1,'SAYAN','MANAGER','FINANCE',50000)

1 row created.


SQL> /
Enter value for empno: 2
Enter value for name: THOMAS KUTTY
Enter value for designation: SALESMAN
Enter value for department: SALES
Enter value for basicpay: 10000
old   2: VALUES(&EMPNO,'&NAME','&DESIGNATION','&DEPARTMENT',&BASICPAY)
new   2: VALUES(2,'THOMAS KUTTY','SALESMAN','SALES',10000)

1 row created.


SQL> /
Enter value for empno: 4
Enter value for name: JIJI JOHNSON
Enter value for designation: ACCOUNTANT
Enter value for department: ACCOUNTS
Enter value for basicpay: 30000
old   2: VALUES(&EMPNO,'&NAME','&DESIGNATION','&DEPARTMENT',&BASICPAY)
new   2: VALUES(4,'JIJI JOHNSON','ACCOUNTANT','ACCOUNTS',30000)

1 row created.


SQL> /
Enter value for empno: 5
Enter value for name: MURUGAN R
Enter value for designation: SENIOR MANAGER
Enter value for department: IT
Enter value for basicpay: 60000
old   2: VALUES(&EMPNO,'&NAME','&DESIGNATION','&DEPARTMENT',&BASICPAY)
new   2: VALUES(5,'MURUGAN R','SENIOR MANAGER','IT',60000)

1 row created.