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 INTERVAL


1 to 20 of 1177 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

Interval Expressions

Interval ExpressionsAn interval expression yields a value of INTERVAL YEAR TO MONTH or INTERVAL DAY TO SECOND … be the value of an INTERVAL column or a compound expression that yields an interval value. Datetimes … yield interval values are valid in an interval expression. Both leading_field_precision

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

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be checked.

SQL Reference, 10g Release 1 (10.1)

Literals

Interval LiteralsAn interval literal specifies a period of time. You can specify these differences in terms of years … interval literals, YEAR TO MONTH and DAY TO SECOND. Each type contains a leading field and may … TO MONTH interval considers an interval of years to the nearest month. A DAY TO MINUTE interval

Packages and Types Reference, 10g Release 1 (10.1)

41 DBMS_JOB

INTERVAL ProcedureThis procedure changes how often a job runs.

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

OCI Date, Datetime, and Interval Functions

interval (IN)The input interval.

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

OCI Date, Datetime, and Interval Functions

interval (OUT)Interval result.

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

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be converted.

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

11 Object-Relational Datatypes in OCI

Interval FunctionsThe following functions operate exclusively on interval data. In some cases it is necessary to … specify the type of interval involved. Possible types include: SQLT_INTERVAL_YM - interval year to month … SQLT_INTERVAL_DS - interval day to second See the individual function descriptions for more … information about

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

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be converted.

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

OCI Date, Datetime, and Interval Functions

interval (IN)The input interval.

Globalization Support Guide, 10g Release 1 (10.1)

4 Datetime Datatypes and Time Zone Support

Interval DatatypesInterval datatypes store time durations. They are used primarily with analytic functions. For … example, you can use them to calculate a moving average of stock prices. You must use interval datatypes … to determine the values that correspond to a particular percentile. You can also use interval … datatypes to update historical

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

Interval Y M Class

operator-()interval to be compared. second The second interval to be compared.

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

Interval Y M Class

setNull()This method sets the interval to NULL. Syntax void setNull();

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

Interval Y M Class

getYear()This method returns the year component of the interval. Syntax int getYear() const;

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

Interval Y M Class

operator+()IntervalYM &first, const IntervalYM &second); Parameter Description first The first interval to be compared. second The second interval to be compared.

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

Interval Y M Class

operator*()This method multiplies the interval by a factor and returns the result. Syntax const IntervalYM … operator*( const IntervalDS &interval const Number &value); Parameter Description interval Interval to … be multiplied. val Value by which interval is to be multiplied.

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

Interval Y M Class

operator=()This method assigns the specified value to the interval. Syntax const IntervalYM& operator=( const

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

Interval Y M Class

operator<()operatorbool operator Parameter Description first The first interval to be compared. second The second interval to be compared.

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

Interval Y M Class

fromText()This method initializes the interval to the values in inpstr. The string is interpreted using the … ); Parameter Description inpStr Input string representing a year month interval of the form 'year-month

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

Interval Y M Class

toText()This method returns the string representation of the interval. Syntax string toText( unsigned int