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.
