"Sailing the full mastery of SQL skills"

Directory

Eight. Regular expressions

8.1. Introduction to Regular expressions

8.2. Oracle SQL pattern matching function

8.2.1. Pattern matching function

8.2.2. Pattern matching Options

8.3. Operators in an Oracle regular expression

8.3.1. POSIX operators

8.3.2. Perl Regular Expression Extended characters

8.3.3. character clusters and meanings

8.3.4. Operator Precedence

8.4. Regular expression instances

8.4.1. regexp_like function

8.4.2. Regexp_replace function

8.4.3. regexp_substr function

8.4.4. regexp_instr function

8.4.5. Regexp_count function

8.5. Supplementary cases

8.5.1. Superfluous's SQL case

Nine. Common simple functions

9.1. Introduction and classification of functions

9.1.1.1. Introduction to SQL Functions

9.1.1.2. SQL function classification

9.2. Introduction to Common functions

9.2.1. Numeric functions

9.2.1.1. Abs function

9.2.1.2. ceil function

9.2.1.3. Floor function

9.2.1.4. mod functions

9.2.1.5. Sign function

9.2.1.6. TRUNC (number) function

9.2.2. Character functions

9.2.2.1. concat function

9.2.2.2. Initcap function

9.2.2.3. Nls_initcap function

9.2.2.4. LOWER | Nls_lower function

9.2.2.5. Lpad | Rpad function

9.2.2.6. TRIM | LTRIM | RTrim function

9.2.2.7. REPLACE | Translate function

9.2.2.8. substr function

9.2.3. Date-time functions

9.2.3.1. add_months | Months_between

9.2.3.1. current_date | Current_timestamp | Sysdate | Systimestamp

9.2.3.1. EXTRACT (DateTime) | ROUND (date) | Tranc (date)

9.2.3.1. To_char (DateTime) | To_dsinterval | To_timestamp

9.2.4. Comparison functions

9.2.4.1. Least function

9.2.4.2. Greatest function

9.2.5. Type Conversion Functions

9.2.5.1. Cast function

9.2.5.2. Convert function

9.2.5.3. To_char (Character|datetime|number)

9.2.6. Decose | Case

9.2.6.1. Decose function

9.2.6.2. Case expressions

9.2.7. Null value correlation function

9.2.7.1. Nvl function

9.2.7.2. NVL2 function

9.2.7.3. Coalesce function

9.2.7.4. Lnnvl function

9.2.7.5. Nanvl function

9.2.7.6. Nullif function

9.2.8. Aggregation functions

9.2.8.1. MIN | Max function

9.2.8.1. COUNT | Avg function

9.2.8.1. SUM | Median function

9.2.8.1. group_id | grouping function

9.2.8.1. CUBE | Rollup function

9.3. Supplementary cases

9.3.1. NAN and NANVL Introduction

9.3.2. Extract Time function

9.3.3. Interval,literals Introduction

10. Expressions and operators

10.1. Introduction to Expressions and operators

10.1.1. An Introduction to expressions

10.1.2. Introduction to Operators

10.2. Expressions and operator classifications

10.2.1. Classification of expressions

10.2.1.1. Simple expressions

10.2.1.2. Composite expressions

10.2.1.3. Case expressions

10.2.1.4. Column expressions

10.2.1.5. Cursor expressions

10.2.1.6. Date-Time expressions

10.2.1.7. function expressions

10.2.1.8. Interval expressions

10.2.1.9. Model expression

10.2.1.10. Scalar-Quantum query expressions

10.2.1.11. List of expressions

10.2.2. Operator classifications

10.2.2.1. Unary and two-dollar operators

10.2.2.2. Arithmetic operators

10.2.2.3. Join operators

10.2.2.4. Hierarchical query Operators

10.2.2.5. Set operator

10.2.2.6. Multiset operator

10.2.2.7. User-defined operators

10.2.2.8. Escape characters

Eleven. View (views)

11.1. Introduction to the View

11.1.1. Introduction to Views

11.1.2. Basic View Syntax

11.1.3. View classification

11.2. Create a view

11.2.1. Normal View

11.2.2. Editioning View

11.2.3. View with constraints

11.2.4. Updatable view

11.2.5. With CHECK option

11.2.6. Join View

11.2.7. Read-only View

11.2.8. Inline View

11.2.9. Specifying aliases when creating views

11.2.10. View using Virtual columns

11.2.11. DML statements and Join view

11.2.12. DML statement operation restrictions for Join view

11.2.13. How the database accesses the view

11.2.14. Basic materialized views

11.2.14.1. Introduction to basic materialized views

11.2.14.2. Basic materialized View syntax

11.2.14.3. Basic materialized View instances

11.2.14.4. Materialized view contains only joins

11.2.14.5. Nesting materialized views

11.2.14.6. Materialized views using alias lists

11.2.14.7. Limitations of materialized view query overrides

11.2.14.8. Materialized View Index

11.2.14.9. Registering materialized views

11.2.14.10. Cleaning up materialized view logs

11.2.14.11. Maintenance of materialized views

11.2.15. Advanced materialized views

11.2.15.1. Materialized View Partitioning

11.2.15.2. Materialized views and Models

11.2.15.3. Related views of materialized views

Part II: DML articles

Twelve. INSERT, UPDATE, DELETE, MERGE

12.1. DML Statement Introduction

12.2. DML syntax and instances

12.2.1. INSERT

12.2.1.1. Insert Syntax

12.2.1.2. single table Insert Instance

12.2.1.3. Instances of multiple table inserts

12.2.1.4. Limitations of multiple table insertions

12.2.2. UPDATE

12.2.2.1. Syntax for update

12.2.2.2. Instance of update

12.2.2.3. Considerations for Updating View

12.2.2.4. Considerations for updating Columns

12.2.2.5. Considerations for updating contained subqueries

12.2.2.6. Precautions for using returning

12.2.3. DELETE

12.2.3.1. Delete syntax

12.2.3.2. Instance of Delete

12.2.3.3. Limitations of Del_table_expression_clause

12.2.3.4. Precautions for using returning

12.2.4. MERGE

12.2.4.1. Merge syntax

Examples of 12.2.4.2. Merge

12.2.5. For update and ROWID

12.3. Supplementary cases

12.3.1. Considerations for using the merge statement

12.3.2. INSERT all use case

12.3.3. INSERT into optimization case

Part III: DDL Chapter

13. Constraint (Constraints)

13.1. Introduction and classification of constraints

13.1.1. Introduction to Constraints

13.1.2. Classification of constraints

13.2. Examples of constraints

13.2.1. NOT NULL constraint

13.2.2. UNIQUE constraints

13.2.2.1. UNIQUE Constraint definitions

13.2.2.2. Limitations of UNIQUE constraints

13.2.3. Primary key Constraint

13.2.3.1. Primary key Constraint definition

13.2.3.2. Limitations of the Primary key constraint

13.2.4. Foreign key Constraint

13.2.4.1. Foreign key Constraint definition

13.2.4.2. Limitations of the Foreign key constraint

13.2.4.3. Self-referential constraints

13.2.4.4. Parent key modification and foreign key relationships

13.2.4.5. indexes and foreign keys

13.2.5. Check constraints

13.2.5.1. Check Constraint definitions

13.2.5.2. Restrictions on Check constraints

13.2.6. State of the integrity constraint

13.2.7. When a database checks the validity of a constraint

13.2.8. Maintenance of constraints

13.3. Supplementary cases

13.3.1. Common modification statements for tables and constraints

13.3.2. Statements that export table constraints

The following three chapters are omitted, see the Cross-border section.

14. Design of the table

Supplementary cases

1. Oracle Design Development Specification

2. Zoning introduction and application in the project

3. Hash partition Usage Summary

4. Oracle External Tables

xv. Design of the Index

Supplementary cases

1. Null use of index issues

2. Oracle Text Index

3. Night Conversation Index

4. Night Conversation Index II

5. Why is it sometimes more efficient to scan a full-table peso primer

6. Some questions about the index

7. A detailed description of the function index

16. Sequence and other object design

Supplementary cases

1. How to reduce contention when generating primary keys using an index

This article is from the "srsunbing" blog, make sure to keep this source http://srsunbing.blog.51cto.com/3221858/1961976

"Sailing the full mastery of SQL skills"