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 datatypes


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


Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Datatypesarguments. These datatypes define the domain of values that each column can contain or each argument … provides a number of built-in datatypes as well as several categories for user-defined types that can … be used as datatypes. The syntax of Oracle datatypes appears in the diagrams that follow. The text … of

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Numeric PrecedenceNumeric precedence determines, for operations that support numeric datatypes, the datatype Oracle … uses if the arguments to the operation have different datatypes. BINARY_DOUBLE has the highest … information on implicit conversion. In the context of other datatypes, numeric datatypes have lower … precedence than

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

BLOB DatatypeThe BLOB datatype stores unstructured binary large objects. BLOB objects can be thought of as bitstreams with no character set semantics. BLOB objects can store binary data up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage). If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB storage when creating

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

ROWID DatatypeThe rows in heap-organized tables that are native to Oracle Database have row addresses called rowids. You can examine a rowid row address by querying the pseudocolumn ROWID. Values of this pseudocolumn are strings representing the address of each row. These strings have the datatype ROWID. You can also create tables and clusters that contain actual columns having the ROWID datatype. Oracle Database

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Support for Daylight Saving TimesOracle Database automatically determines, for any given time zone region, whether daylight saving is in effect and returns local time values accordingly. The datetime value is sufficient for Oracle to determine whether daylight saving time is in effect for a given region in all cases except boundary cases. A boundary case occurs during the period when daylight saving goes into or comes out of effect.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Datetime and Interval ExamplesThe following example shows how to specify some datetime and interval datatypes. CREATE TABLE … datatypes do not have format models. Therefore, to adjust their presentation, you must combine character

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

UROWID DatatypeUROWID Dataty pe The rows of some tables have addresses that are not physical or permanent or were not generated by Oracle Database. For example, the row addresses of index-organized tables are stored in index leaves, which can move. Rowids of foreign tables (such as DB2 tables accessed through a gateway) are not standard Oracle rowids. Oracle uses universal rowids ( urowids ) to store the addresses

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Table 2-7 SQL/DS and DB2 Datatypes Converted to Oracle DatatypesSQL/DS or DB2 Datatype Oracle Datatype CHARACTER(n) CHAR(n) VARCHAR(n) VARCHAR(n) LONG VARCHAR LONG DECIMAL(p,s) ( a ) NUMBER(p,s) INTEGER SMALLINT NUMBER(38) FLOAT ( b ) NUMBER Notes: The DECIMAL datatype can specify only fixed-point numbers. For this datatype, s defaults to 0. The FLOAT datatype is a floating-point number with a binary precision b. The default precision for this datatype is 126

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

ANYDATAThis type contains an instance of a given type, with data, plus a description of the type. ANYDATA can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

SDO_TOPO_GEOMETRYThis type describes a topology geometry, which is stored in a single row, in a single column of object type SDO_TOPO_GEOMETRY in a user-defined table. The SDO_TOPO_GEOMETRY object type has the following definition: CREATE TYPE SDO_TOPO_GEOMETRY AS OBJECT ( tg_type NUMBER, tg_id NUMBER, tg_layer_id NUMBER, topology_id NUMBER) /

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

SI_FeatureListThe SI_FeatureList object type is a list containing up to four of the image features represented by the preceding object types ( SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, and SI_Texture ), where each feature is associated with a feature weight.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Table 2-1 Built-in Datatype Summary4 gigabytes. The sections that follow describe the Oracle datatypes as they are stored in Oracle … Database. For information on specifying these datatypes as literals, refer to \"Literals\". Character … Datatypes Character datatypes store character (alphanumeric) data, which are words and free-form … datatypes

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Table 2-2 Storage of Scale and PrecisionActual Data Specified As Stored As 123.89 NUMBER 123.89 123.89 NUMBER(3) 124 123.89 NUMBER(3,2) exceeds precision 123.89 NUMBER(4,2) exceeds precision 123.89 NUMBER(5,2) 123.89 123.89 NUMBER(6,1) 123.9 123.89 NUMBER(6,-2) 100.01234 NUMBER(4,5).01234.00012 NUMBER(4,5).00012.000127 NUMBER(4,5).00013.0000012 NUMBER(2,7).0000012.00000123 NUMBER(2,7).0000012 1.2e-4 NUMBER(2,5) 0.00012 1.2e-5 NUMBER(2,5)

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

TIMESTAMP WITH TIME ZONE DatatypeTIMESTAMP WITH TIME ZONE is a variant of TIMESTAMP that includes a time zone region name or a a time zone offset in its value. The time zone offset is the difference (in hours and minutes) between local time and UTC (Coordinated Universal Time—formerly Greenwich Mean Time). This datatype is useful for collecting and evaluating date information across geographic regions. Specify the TIMESTAMP WITH

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

NCLOB DatatypeThe NCLOB datatype stores Unicode data. Both fixed-width and variable-width character sets are supported, and both use the national character set. NCLOB objects can store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage) of character text data. If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

VarraysAn array is an ordered set of data elements. All elements of a given array are of the same datatype. Each element has an index, which is a number corresponding to the position of the element in the array. The number of elements in an array is the size of the array. Oracle arrays are of variable size, which is why they are called varrays. You must specify a maximum size when you declare the varray.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

ANYTYPEThis type can contain a type description of any named SQL type or unnamed transient type.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

ORDAudioThe ORDAudio object type supports the storage and management of audio data.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

SI_ColorThe SI_Color object type encapsulates color values.

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

NCHAR DatatypeThe NCHAR datatype is a Unicode-only datatype. When you create a table with an NCHAR column, you define the column length in characters. You define the national character set when you create your database. The maximum length of a column is determined by the national character set definition. Width specifications of character datatype NCHAR refer to the number of characters. The maximum column size