-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path26-DQL-Commands.sql
More file actions
138 lines (99 loc) · 4.21 KB
/
Copy path26-DQL-Commands.sql
File metadata and controls
138 lines (99 loc) · 4.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
/*
===============================================================================
Repository : 08-Oracle-SQL
Folder : Source-Code/26-DQL-Commands
File Name : 01-DQL-Commands.sql
Topic : Data Query Language (DQL)
Description : Practical examples demonstrating Oracle SQL DQL using
the SELECT statement for retrieving data from tables.
Author : Shaik Mahaboob Basha
License : MIT License
===============================================================================
*/
-- =============================================================================
-- NOTE
-- =============================================================================
-- This script assumes the EMP table already exists.
--
-- Execute the examples one by one to understand different ways of
-- retrieving data using the SELECT statement.
-- =============================================================================
-- =============================================================================
-- SECTION 1 : DISPLAY ALL COLUMNS
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 1 : Display All Records from EMP Table
PROMPT ============================================================
SELECT *
FROM EMP;
-- =============================================================================
-- SECTION 2 : DISPLAY SPECIFIC COLUMNS
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 2 : Display Employee ID, Name and Salary
PROMPT ============================================================
SELECT EMP_ID,
F_NAME,
SALARY
FROM EMP;
-- =============================================================================
-- SECTION 3 : DISPLAY EMPLOYEE NAME AND DEPARTMENT
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 3 : Display Employee Name and Department ID
PROMPT ============================================================
SELECT EMP_ID,
F_NAME,
DEPT_ID
FROM EMP;
-- =============================================================================
-- SECTION 4 : DISPLAY EMPLOYEE NAME AND JOB
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 4 : Display Employee Name and Job ID
PROMPT ============================================================
SELECT EMP_ID,
F_NAME,
JOB_ID
FROM EMP;
-- =============================================================================
-- SECTION 5 : DISPLAY EMPLOYEE CONTACT DETAILS
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 5 : Display Employee Contact Details
PROMPT ============================================================
SELECT F_NAME,
EMAIL,
PHONE_NUMBER
FROM EMP;
-- =============================================================================
-- SECTION 6 : DISPLAY EMPLOYEE SALARY DETAILS
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 6 : Display Salary Information
PROMPT ============================================================
SELECT EMP_ID,
F_NAME,
SALARY,
COMMISSION_PCT
FROM EMP;
-- =============================================================================
-- SECTION 7 : DISPLAY HIRE DETAILS
-- =============================================================================
PROMPT
PROMPT ============================================================
PROMPT Query 7 : Display Employee Hire Details
PROMPT ============================================================
SELECT EMP_ID,
F_NAME,
HIRE_DATE
FROM EMP;
-- =============================================================================
-- End of Script
-- =============================================================================