課程大綱： Oracle SQL Advanced培訓
Control user access
User Management
System permissions and object
Granting
Receiving permission
Roles
Using the links
Managing schema objects
ALTER TABLE command
Adding, modifying, and deleting columns
Add, remove, turn off constraintów
Create indexes
Flashback operations
External tables
Operations on large data sets
MERGE command
DML operations of podzapytaniami
DML operations with RETURNING clause
INSERT command multi tables
Conditional expressions
CASE expression
DECODE expression
Generate reports by grouping related data
The GROUP BY clause
The HAVING clause
Aggregating data - ROLLUP and CUBE operators
Identification summaries - GROUPING function
Aggregating data - GROUPING SETS operator
Managing data in different time zones
Time zones
Variations TIMESTAMP
Differences between DATE and TIMESTAMP
Conversion operations
Advanced subqueries
Subqueries
Multi-column subqueries
The subquery in the FROM clause
Correlated subqueries
WITH clause - re-use query blocks
Join tables
Inequality in the WHERE clause and the FROM clause
Semijoin
Antijoin
The processing of hierarchical data
The tree structure
hierarchical Queries
Pseudo column
Sort data in a hierarchical query
Useful functions
Regular expressions
Simple and complex patterns
加入高級會員獲得助教答疑
