Knowledge about Oracle official documents

Knowledge about Oracle official documents

Although many Oracle DBAs have been familiar with Oracle for a long time, they are used to Baidu or Google if they cannot remember the syntax or find corresponding parameters. Although the official documentation has been downloaded, it is rarely used. As a DBA, I think it is one of the essential skills for qualified DBAs to understand the structure of official documents and the syntax of official documents, and quickly find the required knowledge points and related SQL commands, it is also an essential part of the Oracle OCM examination.

The following is a brief description of the syntax of the official document:

1. keywords and Parameters

The keyword is represented by a rectangle.

Case-insensitive copying

The parameter is represented by an ellipse.

Replace according to actual conditions

Drop role r3;

2. required, optional, or link

Required. The syntax search_string appears in the main line.

NAME can be used in parallel with the main line syntax.

Or link FORCE NOFORCE

[Abc]

[A | B]

3. Multiple Loops

{A | B}

Select col1, col2...

4. Clause

5. Endurance