Oracle-Basic SQL statement Query

I,Basic SELECT statement

Select * from table name;

Slect field name from table name;

Select identifies which columns to select.
From identifies from which table to select.

 

II,Note:

The SQL language is case insensitive.
SQL statements can be written in one or more rows.
Keywords cannot be abbreviated or branch
Each clause is generally written by a branch.
Use indentation to improve statement readability.

 

III,Arithmetic Operators

Arithmetic Operators used by numbers and dates.

 

4. Use mathematical operators

 

5. Operator priority

The priority of multiplication and division is higher than that of addition and subtraction.
The same priority operator is executed from left to right.
The operation in parentheses is executed first.

6. Brackets

 

The priority of multiplication and division is higher than that of addition and subtraction.
The same priority operator is executed from left to right.
The operation in parentheses is executed first.