Oracle Hardening Exercises

Write a simple query statement

1. Display all the information of the Department table

Select * FROM Dept;

2. Show department number, department name

Selectdeptno,dname from Dept;

3. Displays the following fields and string connections: Employee name, "1 month Salary:", salary. For example: Amy's 1 month Salary: 8000

Select ename| | ' The one-month salary is: ' | | Sal Fromemp;

4. Show employee name, work hours, work

Selectename,hiredate,job from EMP;

5. Show Employee Name: Alias name, annual salary (13 months salary): Alias is annual salary. Note: Aliases are case-sensitive

Select Ename "Name", (SAL+NVL (comm.,0)) *13 "Annualsalary" from EMP;

6. Display the employee name and job name as a string

Select concat (ename,job) from EMP;

7. Displays the following fields and string connections: Employee name, "s job is", job name. Example: Amy ' sjob is MANAGER Note: Single quotation marks are required to show

Select concat (concat (ename "job is"), job) from EMP;

8. Display the department number and job name in the employee table, and ask to remove duplicate values

Select distinct deptno,job from EMP;

Oracle Hardening Exercises