Details of this Paper

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

Description

solution


Question

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

 

Paper#69142 | Written in 18-Jul-2015

Price : $37
SiteLock