Oracle FAQ (III)

Source: Internet
Author: User

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?

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.