Oracle FAQ (III)

After the database is upgraded, how can I determine whether the upgrade is successful?

Function rounding?

Returns a value rounded to the specified number of decimal places.
Number: value to be processed
The number of decimal places is set to select round (123.456, 0) from dual; return select round (123.456, 1) from dual; Return

What is the function?

Insert into sale values ('20170101', 'zhang Yi insert into sale values ('20170101', 'wang 'er insert into sale values ('20170101 ', 'Lee San insert into sale values ('123', 'zhao Si commit;
(1) rownum for query conditions equal to a certain value


ROWNUM ID NAME
-------------------------------------------------------------------
1 200001
ROWNUM ID NAME
-------------------------------------------------------------------

ROWNUM ID NAME
-------------------------------------------------------------------

NO ID NAME
-------------------------------------------------------------------
3 200003

ROWNUM ID NAME
-------------------------------------------------------------------


ROWNUM ID NAME
-------------------------------------------------------------------
1 200001


NO ID NAME
-------------------------------------------------------------------
2 200002

The operator must be placed at one end with fewer rows. Therefore, the operator should be placed at one end of the right table in the clause,

The operator must be placed at one end with fewer rows. Therefore, the operator should be placed at the end of the left table in the clause,

User (): connects to the database and accesses database objects. (The user is used to connect to the database to access the database ).

: A collection of database objects. The schema object is the logical structure of the database data. (Split database objects into different logical structures using the schema ).

Oracleimp/exp?