SQL> CREATE TABLE Employee(E_id number(3) primary key,F_name varchar2(10),L_name varchar2(10),Dept
varchar2(10),Salary number(10));
Table created.
SQL> INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary);
Enter value for e_id: 101
Enter value for f_name: Sujit
Enter value for l_name: Kar
Enter value for dept: BCA
Enter value for salary: 10000
old 1: INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary)
new 1: INSERT INTO Employee VALUES(101,'Sujit ','Kar','BCA',10000)
1 row created.
SQL> /
Enter value for e_id: 102
Enter value for f_name: Amit
Enter value for l_name: Das
Enter value for dept: CS
Enter value for salary: 8000
old 1: INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary)
new 1: INSERT INTO Employee VALUES(102,'Amit','Das','CS',8000)
1 row created.
SQL> /
Enter value for e_id: 103
Enter value for f_name: Amitabho
Enter value for l_name: Jana
Enter value for dept: ENG
Enter value for salary: 9000
old 1: INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary)
new 1: INSERT INTO Employee VALUES(103,'Amitabho','Jana','ENG',9000)
1 row created.
SQL> /
Enter value for e_id: 104
Enter value for f_name: Arindom
Enter value for l_name: Sahoo
Enter value for dept: BCA
Enter value for salary: 12000
old 1: INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary)
new 1: INSERT INTO Employee VALUES(104,'Arindom','Sahoo','BCA',12000)
1 row created.
SQL> /
Enter value for e_id: 105
Enter value for f_name: Deepjyoti
Enter value for l_name: Das
Enter value for dept: BCA
Enter value for salary: 20000
old 1: INSERT INTO Employee VALUES(&E_id,'&F_name','&L_name','&Dept',&Salary)
new 1: INSERT INTO Employee VALUES(105,'Deepjyoti','Das','BCA',20000)
1 row created.
SQL> SELECT *FROM Employee;
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
101 Sujit Kar BCA 10000
102 Amit Das CS 8000
103 Amitabho Jana ENG 9000
104 Arindom Sahoo BCA 12000
105 Deepjyoti Das BCA 20000
--Query 1--
SQL> SELECT *FROM Employee WHERE F_name LIKE 'Ami%';
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
102 Amit Das CS 8000
103 Amitabho Jana ENG 9000
--Query 2--
SQL> SELECT *FROM Employee WHERE F_name LIKE 'A%' AND L_name LIKE 'S%';
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
104 Arindom Sahoo BCA 12000
--Query 3--
SQL> SELECT *FROM Employee WHERE F_name NOT LIKE 'P,B,R%' ;
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
101 Sujit Kar BCA 10000
102 Amit Das CS 8000
103 Amitabho Jana ENG 9000
104 Arindom Sahoo BCA 12000
105 Deepjyoti Das BCA 20000
--Query 4--
SQL> SELECT *FROM Employee WHERE E_id=101;
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
101 Sujit Kar BCA 10000
--Quary 5---
SQL> SELECT *FROM Employee WHERE E_id=(SELECT MAX(E_id) FROM Employee);
E_ID F_NAME L_NAME DEPT SALARY
---------- ---------- ---------- ---------- ----------
105 Deepjyoti Das BCA 20000
-Quary 7---
SQL> SELECT MAX(Salary) FROM Employee UNION SELECT MIN(Salary) FROM Employee;
MAX(SALARY)
-----------
8000
20000
---Quary 6----
SQL> SELECT MAX(Salary) FROM Employee WHERE Salary < (SELECT MAX(Salary) FROM Employee);
MAX(SALARY)
-----------
12000
