Results for ROUND


1 to 20 of 282 results. Prev  Next
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

ROUND

number_expAn expression that identifies the number to round. roundvalue A value that specifies the basis for … rounding. When the round type is MULTIPLE: number_exp is rounded to the nearest multiple of … roundvalue. roundvalue can be an integer or decimal number.   When the round type is DECIMAL: roundvalue … ROUND to

DML Reference, 10g Release 1 (10.1)

ROUND

ROUND (for dates and time)ROUND (for numbers) ROUND (for dates and time) When a DATETIME expression is specified as an … argument, the ROUND function returns a date and time value rounded to a specified date format. When you do … not specify a format, the date and time value is rounded to the nearest day. Return Value DATETIME Syntax ROUND( datetime_exp, 

DML Reference, 10g Release 1 (10.1)

ROUND

ROUNDDepending on the syntax you specify, the ROUND function performs a numeric operation or a date and … time operation. Because the syntax for the ROUND function differs for each type of operation, there are two topics for the ROUND function:

DML Reference, 10g Release 1 (10.1)

ROUND

ROUND (for numbers)When a number is specified as an argument, the ROUND function returns the number rounded to the … second number. Return Value DECIMAL (when the round type is MULTIPLE) NUMBER (when the round type is … DECIMAL) Syntax ROUND( number_exp roundvalue ) [ MULTIPLE |DECIMAL] Arguments

DML Reference, 10g Release 1 (10.1)

ROUND

datetime-expnumber should be rounded. Table 21-1 Format Models for ROUND for Dates and Time Format Model … -YY, then this statement: SHOW ROUND ('27-OCT-92','year') returns this value: 01-JAN-93

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Numb er Class

round()parameter specified. Syntax const Number round( int decPlace) const; Parameter Description decPlace The number of digits to the right of the decimal point.

SQL Reference, 10g Release 1 (10.1)

ROUND (number)

ROUND (number)Syntax round_number::= Description of the illustration round_number.gif Purpose ROUND returns n … 0 places. The argument integer can be negative to round off digits left of the decimal point. n can … example rounds a number to one decimal point: SELECT ROUND(15.193,1) "Round" FROM DUAL; Round

SQL Reference, 10g Release 1 (10.1)

ROUND (date)

ROUND (date)Syntax round_date::= Description of the illustration round_date.gif Purpose ROUND returns date … the nearest day. The date expression must resolve to a DATE value. See Also: "ROUND and TRUNC Date … to the first day of the following year: SELECT ROUND (TO_DATE ('27-OCT-00'),'YEAR') "New Year" FROM DUAL; New Year --------- 01-JAN-01

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

LOB Function Round TripsTable C-2 lists the server round trips incurred by the OCILob*() calls. Note: To minimize the … number of round trips, you can use the data interface for LOBs. You can bind or define character data for … For calls whose number of round trips is "0 or 1", if LOB buffering is on, and the request can be … satisfied in the client,

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Relational Function Round TripsThe number of server round trips required by OCI relational functions are listed in Table C-1 … : Table C-1 Server Round Trips for Relational Operations   Function # of Server Round Trips OCIBreak() 1

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Describe Operation Round TripsThe number of server round trips required by OCIDescribeAny(), OCIAttrGet(), and OCIParamGet() are … listed in Table C-4: Table C-4 Server Round Trips for Describe Operations Function # of Server … Round Trips OCIDescribeAny() 1 round trip to get the REF of the type descriptor object OCIAttrGet() 2 … round

SQL Reference, 10g Release 1 (10.1)

ROUND and TRUNC Date Functions

ROUND and TRUNC Date FunctionsTable 7-13 lists the format models you can use with the ROUND and TRUNC date functions and the … units to which they round and truncate dates. The default model, 'DD', returns the date rounded or … truncated to the day with a time of midnight. Table 7-13 Date Format Models for the ROUND and TRUNC Date

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Overview of Server Round TripsThis appendix provides information about server round trips incurred during various OCI calls. This

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Other Local FunctionsThe functions listed in Table C-7 are local and do not require a server round trip: Table C-7 … call does make one round trip to fetch the type descriptor object. OCIAttrSet()   OCIBindByName

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Object and Cache Function Round TripsTable C-3 lists the number of server round trips required for the object and cache functions. These … the application have been loaded. Table C-3 Server Round Trips for Object and Cache Functions …   Function # of Server Round Trips OCIObjectNew() 0 OCIObjectPin() 1; 0 if the desired object is already in

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

C OCI Function Server Round TripsThis appendix provides information about server round trips incurred during various OCI calls. This … particular task in an application. This appendix contains these topics: Overview of Server Round Trips … Relational Function Round Trips LOB Function Round Trips Object and Cache Function Round Trips

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Datatype Mapping and Manipulation Function Round TripsThe number of round trips for the datatype mapping and manipulation functions are listed in Table C … number of server round trips. For example, OCINumberAdd(), OCINumberPower(), and OCINumberFromText … () all incur zero server round trips. Table C-5 Server Round Trips for Datatype Manipulation Functions …   Function

Programmer's Guide, 10g Release 1 (10.1)

C OCI Function Server Round Trips

Any Type and Data Function Round TripsThe number of server round trips required by Any Type and Data functions are listed in Table C-6 … . The functions not listed do not generate any round trips. Table C-6 Server Round Trips for Any Type … and Data Functions   Function # of Server Round Trips OCIAnyDataAttrGet() 0; 1 if the type

Programmer's Guide, 10g Release 1 (10.1)

Introduction to More Relational Functions

Server Round trips for LOB FunctionsFor a table showing the number of server round trips required for individual OCI LOB functions … , refer to Appendix C, "OCI Function Server Round Trips".

Programmer's Guide, 10g Release 1 (10.1)

Introduction to the Relational Functions

Server Round Trips for LOB FunctionsFor a table showing the number of server round trips required for individual OCI LOB functions … , refer to Appendix C, "OCI Function Server Round Trips".





Was this page helpful?

Integrated Cloud Applications & Platform Services