Write a program that will check the salary of an employee in the Emp table.

 

Write a program that will check the salary of an employee in the Emp table. Write the program such that it displays the employee number, name, job, salary, and department name, if the salary of the employee is greater than 3000. Also – Write a program that will check the prime number from 1 to 10 and then displays the number with appropriate message.

 

There is the Employee Table:

       

SQL> DESC Employee Name Null? Type —————————————– ——– ————– EMPID NUMBER(5) ENAME VARCHAR2(30) DESIGNATION VARCHAR2(30) SALARY NUMBER COMMISSION NUMBER DEPTNO NUMBER

       

And the Department Table:

       

SQL> DESC Department Name Null? Type —————————————– ——– ———————– DEPTNO NOT NULL NUMBER(5) DEPTNAME VARCHAR2(30)

       

The data in the Employee table is:

   

SQL> SELECT * FROM EMPLOYEE 2 ; EMPID ENAME DESIGNATION ———- —————————— ————————— SALARY COMMISSION DEPTNO ———- ———- ———- 1 Woodard Data Administrator 40000 4000 123 2 Smith Manager 80000 0 123

   

The data in the Department table is:

       

SQL> SELECT * FROM DEPARTMENT 2 ; DEPTNO DEPTNAME ———- —————————— 123 Baker