Shulou(Shulou.com)06/01 Report--

Catalogue

eight。 Regular expression

8.1. Brief introduction of regular expression

8.2. Oracle Sql pattern matching function

8.2.1. Pattern matching function

8.2.2. Pattern matching option

8.3. Operators in Oracle regular expressions

8.3.1. POSIX operator

8.3.2. Perl regular expression extension character

8.3.3. Character cluster and meaning

8.3.4. Operation priority of operator

8.4. Regular expression instance

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 case

8.5.1. A superfluous SQL case

nine。 Commonly used simple functions

9.1. Introduction and classification of functions

9.1.1.1. Brief introduction of SQL function

9.1.1.2. SQL function classification

9.2. Brief introduction of commonly used functions

9.2.1. Numeric function

9.2.1.1. ABS function

9.2.1.2. CEIL function

9.2.1.3. FLOOR function

9.2.1.4. MOD function

9.2.1.5. SIGN function

9.2.1.6. TRUNC (number) function

9.2.2. Character function

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 function

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 function

9.2.4.1. LEAST function

9.2.4.2. GREATEST function

9.2.5. Type conversion function

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 expression

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. Aggregate function

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 case

9.3.1. Introduction to NAN and NANVL

9.3.2. EXTRACT time function

9.3.3. Introduction to INTERVAL,LITERALS

ten。 Expressions and operators

10.1. Introduction to expressions and operators

10.1.1. Introduction to expression

10.1.2. Introduction to operator

10.2. Classification of expressions and operators

10.2.1. Expression classification

10.2.1.1. Simple expression

10.2.1.2. Compound expression

10.2.1.3. CASE expression

10.2.1.4. Column expression

10.2.1.5. Vernier expression

10.2.1.6. Date-time expression

10.2.1.7. Function expression

10.2.1.8. Interval expression

10.2.1.9. Model expression

10.2.1.10. Scalar quantum query expression

10.2.1.11. Expression list

10.2.2. Operator classification

10.2.2.1. Unary and binary operators

10.2.2.2. Arithmetic operator

10.2.2.3. Concatenation operator

10.2.2.4. Hierarchical query operator

10.2.2.5. SET operator

10.2.2.6. Multiset operator

10.2.2.7. User-defined operator

10.2.2.8. Escape character

eleven。 View (VIEWS)

11.1. Brief introduction to View

11.1.1. Brief introduction to View

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. Specify an alias when creating a view

11.2.10. Views use virtual columns

11.2.11. DML statement and Join view

11.2.12. Restrictions on the operation of Join view by DML statements

11.2.13. How the database accesses the view

11.2.14. Basic materialized view

11.2.14.1. A brief introduction to basic materialized View

11.2.14.2. Basic materialized view syntax

11.2.14.3. Basic materialized view instance

11.2.14.4. Materialized view contains only joins

11.2.14.5. Nested materialized view

11.2.14.6. Materialized views use aliases list

11.2.14.7. Restrictions on query rewriting of materialized views

11.2.14.8. Materialized view index

11.2.14.9. Register materialized view

11.2.14.10. Clean up the materialized view log

11.2.14.11. Maintenance of materialized view

11.2.15. Advanced materialized view

11.2.15.1. Materialized view partition

11.2.15.2. Materialized views and Models

11.2.15.3. Dependent views of materialized views

Part two: DML

twelve。 INSERT 、 UPDATE 、 DELETE 、 MERGE

12.1. Brief introduction of DML sentence

12.2. DML syntax and examples

12.2.1. INSERT

12.2.1.1. INSERT syntax

12.2.1.2. Instance of a single table insert

12.2.1.3. Instances of multiple table inserts

12.2.1.4. Restrictions on multiple table inserts

12.2.2. UPDATE

12.2.2.1. Syntax of UPDATE

12.2.2.2. An example of UPDATE

12.2.2.3. Considerations for updating VIEW

12.2.2.4. Considerations for updating columns

12.2.2.5. Update considerations for including subqueries

12.2.2.6. Considerations for using returning

12.2.3. DELETE

12.2.3.1. Syntax of DELETE

12.2.3.2. An example of DELETE

12.2.3.3. Limitations of del_table_expression_clause

12.2.3.4. Considerations for using returning

12.2.4. MERGE

12.2.4.1. Syntax of MERGE

12.2.4.2. An example of MERGE

12.2.5. For update and ROWID

12.3. Supplementary case

12.3.1. Considerations for using MERGE statements

12.3.2. INSERT ALL use case

12.3.3. Optimization case of INSERT INTO

Part III: DDL

thirteen。 Constraint (Constraints)

13.1. Introduction and classification of constraints

13.1.1. An introduction to constraints

13.1.2. Classification of constraints

13.2. Instance of constraint

13.2.1. NOT NULL constraint

13.2.2. UNIQUE constraint

13.2.2.1. UNIQUE constraint definition

13.2.2.2. Limitations of UNIQUE constraint

13.2.3. Primary key constraint

13.2.3.1. Primary key constraint definition

13.2.3.2. Limitations of Primary key constraint

13.2.4. Foreign key constraint

13.2.4.1. Foreign key constraint definition

13.2.4.2. Limitations of Foreign key constraint

13.2.4.3. Self-referential constraint

13.2.4.4. The relationship between parent key modification and foreign key

13.2.4.5. Index and foreign key

13.2.5. Check constraint

13.2.5.1. Check constraint definition

13.2.5.2. Limitations of Check constraint

13.2.6. Status of integrity constraints

13.2.7. When does the database check the validity of constraints

13.2.8. Maintenance of constraints

13.3. Supplementary case

13.3.1. Common modification statements for tables and constraints

13.3.2. Statements that export table constraints

The following three chapters are omitted, as detailed in the "Cross-border" section.

fourteen。 Design of the watch

Supplementary case

1. Oracle design and development specification

two。 Zoning introduction and its application in the project

3. Summary of HASH partition usage

4. Oracle external table

fifteen。 Design of index

Supplementary case

1. The problem of using index in NULL

2. Oracle text index

3. Night talk index

4. Night talk Index II

5. Why full table scans are sometimes more efficient than index scans

6. Some questions about the index

7. On the detailed explanation of function Index

sixteen。 Sequence and other object design

Supplementary case

1. How to reduce contention when using indexes to generate primary keys

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.