You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for FLOOR


1 to 20 of 28 results. Previous page Prev  Next next page


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 47 of 177

FLOORSyntax floor::= Text description of floor Purpose FLOOR returns largest integer equal to or less … than n. Examples The following example returns the largest integer equal to or less than 15.7: SELECT FLOOR(15.7) "Floor" FROM DUAL; Floor ---------- 15

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 14 of 22

floor()This method returns the largest integer that is less than or equal to the Number object. Syntax const Number floor() const;

Objects for OLE, 9i Release 2 (9.2.0.2)

Floor (OraNumber) Method

Floor (OraNumber) MethodFeedback Floor (OraNumber) Method Applies To OraNumber Object Description Calculates the floor of an … OraNumber. Arguments none Usage OraNumber. Floor Remarks The result of the operation is stored in

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

COSHEXP FLOOR

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 78 of 134

result (OUT)The floor value of the input number.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 78 of 134

OCINumberFloor()Purpose Computes the floor value of an Oracle number.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-33000 to ORA-65535

ORA-33002 XSAGDNGL00 %a workspace object number number In AGGMAP %p, the FLOOR argument of %p must be…Cause: A floor argument greater than the ceiling argument was specified. Action: Adjust the floor … and ceiling arguments so that the floor is less than the ceiling.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-33000 to ORA-65535

ORA-36212 XSAGOP06 %a workspace object string In AGGMAP %p, you can only specify the MIN, MAX, FLOOR,…Cause: The user specified MIN, MAX, FLOOR, or CEILING when using an operator other than

Error Messages, 9i Release 2 (9.2.0.2)

ORA-33000 to ORA-65535

ORA-33054 XSAGDNGL26 %a workspace object number number In AGGMAP %p, a MIN argument of %p must be less…Cause: The user specified a MIN argument that was greater than or equal to the FLOOR argument. Action: Reduce the MIN argument.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 55 of 177

INSTRthe string " CORPORATE FLOOR ", beginning with the third character, for the string " OR ". It returns … the position in CORPORATE FLOOR at which the second occurrence of " OR " begins: SELECT INSTR … ('CORPORATE FLOOR','OR', 3, 2) "Instring" FROM DUAL; Instring ---------- 14 In the next example, Oracle … "FLOOR".

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 72 of 177

MODfunction with this formula: m - n * FLOOR(m/n) The following table illustrates the difference … between the MOD function and the classical modulus: m n MOD(m,n) Classical Modulus 11 4 3 3 11 -4 3 -1 -11 4 -3 1 -11 -4 -3 -3 See Also: FLOOR

Objects for OLE, 9i Release 2 (9.2.0.2)

Methods

Methods(OraNumber) Floor (OraNumber) HypCos (OraNumber) HypSin (OraNumber) HypTan (OraNumber) IsEqual (OraNumber

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Using SQL Trace and TKPROF

Avoiding the Read Consistency TrapFROM cq_names WHERE name = 'FLOOR'; call count cpu elapsed disk query current rows

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

Number Arithmetic FunctionsOCINumberFloor() get the floor value of a number OCINumberInc() increment a number OCINumberMod() get the

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 5 of 5

Enqueuing Through the Oracle JMS Administrative Interface: Example); position:= 1. FOR i IN 1..10 LOOP dbms_lob.write ( lob_loc => body, amount => FLOOR((LENGTH(bytes)+1 … )/2), offset => position, buffer => bytes); position:= position + FLOOR((LENGTH(bytes)+1)/2). END

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Allocating Data, 5 of 5

Using the Allocation Operators and Arguments: A minimum or maximum value for the allocation to assign to the target cells. A floor or ceiling … value so that if the allocated value is below the floor or above the ceiling value, then ALLOCATE

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Using SQL Trace and TKPROF

Avoiding the Schema Trapcq_names WHERE name = 'FLOOR'; call count cpu elapsed disk query current rows … name_id FROM cq_names WHERE name = 'FLOOR'; call count cpu elapsed disk query current rows

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Built-In FunctionsSQLCODE SQLERRM ABS ACOS ASIN ATAN ATAN2 BITAND CEIL COS COSH EXP FLOOR LN LOG MOD POWER ROUND SIGN SIN

Objects for OLE, 9i Release 2 (9.2.0.2)

OO4O Server Methods

OO4O Server MethodsFindPrevious Floor (OraNumber) FlushBuffer (OraLob) Methods G- M GetDatabaseFromPool GetChunk

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 64 of 134

OCI Number FunctionsOCINumberExp() Raises e to the specified Oracle number power OCINumberFloor() Computes the floor of a number