PL/SQL

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

EMAIL ME For Solution:
topsolutions8@gmail.com