Index of Oracle SQL with SQL Developer 18.2 Part I
Section
Section Name
Page
Part I
One
Introduction to SQL
2
- Definition
3
- Usage of SQL
4
- What is SQL used for ?
5
- Who uses SQL ?
6
- Definition of a Database
7
- What is SQL Developer ?
8
Two
The SQL Developer Interface
9
- Introduction
10
- SQL Developer Connections
12
- Connections
14
- Worksheet
15
- Toolbar and Menus
16
Three
Connections
17
- Viewing Objects
18
- Viewing Object Structure
19
- Table Structure
20
- Column Structure
22
- Data Default
27
- The Number Datatype
28
- The Varchar2 Datatype
29
- The Date Datatype
30
- Large Objects
31
- The BLOB Datatype
32
- The CLOB Datatype
33
- Object Details Dialog
34
Four
Object Details Dialog
35
- Introduction
36
- Columns Tab
37
- Columns Tab (Resizing columns)
38
- Columns Tab (Moving columns)
39
- Columns Tab (Sorting columns)
40
- Columns Tab (Filter)
41
- Columns Tab (Icons)
42
- Columns Tab (Right Click)
43
- Data Tab
44
- Data Tab (Single Record View)
45
- Data Tab (Count Rows)
47
- Data Tab (Viewing Blobs and Clobs)
48
- Data Tab (Viewing Blobs)
49
- Model Tab
51
- Constraints Tab
54
- Grants Tab
55
- Statistics Tab
56
- Triggers Tab
57
- Flashback Tab
58
- Dependencies Tab
59
- Details Tab
60
- Partitions Tab
61
- Indexes Tab
62
- SQL Tab
63
- Exercise One
65
Five
Limiting Records in the Data Tab
76
- Introduction
77
- Usage
78
- Using Varchar2 and Dates
79
- Case Sensitivity
80
- Limiting Dates
81
- Invalid Identifier
82
- Invalid Number
83
- Direct Comparison
84
- Value Comparison
86
- Column Comparison
88
- Range Comparison
89
- List Comparison
92
- Wildcard Comparison
95
- Null Values
99
- Combining Filters
100
- AND Filters
101
- OR Filters
102
- Complex Filters
103
- Exercise Two
104
Six
Ordering Records in the Data Tab
114
- Ordering Records in the Data Tab – Introduction
115
- Ordering Records in the Data Tab – Examples
116
Seven
SQL Worksheet
117
- Introduction
118
- Opening in SQL Developer
119
- Creating an SQL Statement
120
- Executing an SQL Statement
122
- Formatting the SQL Statement
123
- SQL Syntax
124
- Labelling Selected Columns (Column Aliases)
126
- Using Literals
130
- Database Variables and Sys.DUAL
131
- Saving the SQL to a File
133
- Opening and Executing a File
135
- Commenting Out Lines
136
- Identifying Amended Files
138
- SQL History
139
- Miscellaneous Commands
140
- Query Result Buttons
141
- Find / Highlight
146
- Searching the Output
147
- Searching the Output
148
- Exercise Three
149
Eight
Manipulating SQL Output
155
- Introduction
156
- Functions
157
- Upper and Lower
160
- Round
161
- Ceil and Floor
163
- Count
164
- Using '*' in Selections
165
- Sum
166
- To_Char
167
- To_Char (Number Examples)
168
- To_Char (Date Examples)
170
- Substr
172
- Substr Examples
173
- Decode
174
- Combining Functions
176
- Concatenating Columns
177
- Performing Mathematics
179
- Performing Mathematics
180
Nine
Snippets
181
- Introduction
182
- Topography
183
- Using Snippets with the SQL Worksheet
184
- Adding User Defined Snippets
187
- Editing User Defined Snippets
191
- Exercise Four
192
Ten
Limiting Data in the SQL Worksheet
201
- The Where Clause
202
- Using Functions within the Where Clause
204
- Using Lower with a Where Clause
205
- Using Substr with a Where Clause
206
- Using NVL with a Where Clause
207
- Using To_Date with a Where Clause
208
- Using Trunc with a Where Clause
211
- Using Trunc with a Number
212
- Using Trunc with a Date
213
- Sub-Queries with a Where Clause
214
- Exists with a Where Clause
216
- Correlated Sub-Queries
218
- Table Aliases
219
- Advanced IN Sub-Queries
220
Eleven
Ordering Data in the SQL Worksheet
222
- Introduction
223
- Advanced Techniques
224
- Advanced Techniques
225
- Using Decode in Order By
226
- Exercise Five
228
Twelve
Aggregating Values in SQL Worksheet
233
- Introduction
234
- Using Group By
236
- Using Where with Group By
238
- Using Having with Group By
240
- Using Rollup to Total Grouping
242
- Exercise Six
247
Thirteen
Joining Tables in an SQL Statement
250
- Introduction
251
- Linking Tables in an SQL Statement
253
- Linking Tables using ANSI SQL/86
257
- Linking Tables in an SQL Statement
258
- Cartesian Products in an SQL Statement
259
- Problems with Joining Tables in SQL
261
- Linking Tables using ANSI SQL/99
264
- Natural Join using ANSI SQL/99
265
- Cross Join using ANSI SQL/99
267
- Join using ANSI SQL/99
268
- Join On using ANSI SQL/99
269
- Outer Joins using ANSI SQL/99
270
- Left Outer Join using ANSI SQL/99
271
- Right Outer Join using ANSI SQL/99
272
- Full Outer Join using ANSI SQL/99
273
- Multiple Joins using ANSI SQL/99
274
- Exercise Seven
275
Fourteen
Query Builder in the SQL Worksheet
278
- Introduction
279
- Invoking Query Builder
280
- Query Builder Topography
282
- Selecting Tables
286
- Checking Links
287
Fifteen
Using Views
288
- Using Views – Database Views
289
- Using Views – Materialized Views
290
Sixteen
Merging Tables in an SQL Statement
291
- Merging Tables in SQL
292
- Using Union to Merge Tables in SQL
293
- Using Union All to Merge Tables in SQL
294
- Using Intersect to Merge Tables in SQL
295
- Using Minus to Merge Tables in SQL
296
- Knowledge Check
297
- Knowledge Check - Union
298
- Knowledge Check - Union All
299
- Knowledge Check - Intersect
300
- Knowledge Check - Minus
301
- Using the Merge Syntax in SQL
302
Seventeen
Regular Expressions in Oracle SQL
304
- Introduction
305
- Using REGEXP_LIKE in Where Clauses
308
- Case Sensitivity
310
- Line Anchors
312
- Using the Dot (Any Character)
314
- Counting Characters {Intervals}
318
- Character Lists
322
- Excluding Character Lists
328
- Alternatives to Character Lists
329
- Class Shorthands
332
- Or Patterns (Alternatives)
333
- Or Patterns with Character Lists
334
- Using the Question Mark (Optional)
335
- Using the Plus sign (Mandatory)
338
- Using the Star sign (Optional)
341
- Backreferencing
342
- POSIX
344
- Using POSIX in Oracle - [:upper] example
346
- Using POSIX in Oracle - [:digit] example
347
- Using POSIX in Oracle – Character equivalents
348
- Using Regexp_count in SQL
349
- Using Regexp_replace in SQL
353
- Using Regexp_instr in SQL
355
- Using Regexp_substr in SQL
357
- Using Regular Expressions in Oracle
359
Eighteen
Exporting Data in SQL Developer
360
- Introduction
361
- File Types
363
- Exporting to CSV
364
- Exporting to Delimited
366
- Exporting to Excel
367
- Exporting to Excel.xml
369
- Exporting to Fixed
371
- Exporting to HTML
373
- Insert
376
- Json
378
- Insert
379
- Loader
380
- Loader (ldr)
381
- Loader (ctl)
382
- PDF
383
- Text
385
- XML
387
Nineteen
SQL Developer Help Facility
389
- Introduction
390
- Search and Table of Contents
391
- Start Page
392
- Data Miner
393
- Check for Updates
394
- About
395
- Exercise Eight
396