How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Datatypes → arguments. 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
Numeric Precedence → Numeric 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
BLOB Datatype → The 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
ROWID Datatype → The 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
Support for Daylight Saving Times → Oracle 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.
Datetime and Interval Examples → The 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
UROWID Datatype → UROWID 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
Table 2-7 SQL/DS and DB2 Datatypes Converted to Oracle Datatypes → SQL/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
ANYDATA → This 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.
SDO_TOPO_GEOMETRY → This 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) /
SI_FeatureList → The 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.
Table 2-1 Built-in Datatype Summary → 4 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
Table 2-2 Storage of Scale and Precision → Actual 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)
TIMESTAMP WITH TIME ZONE Datatype → TIMESTAMP 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
NCLOB Datatype → The 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
Varrays → An 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.
ANYTYPE → This type can contain a type description of any named SQL type or unnamed transient type.
ORDAudio → The ORDAudio object type supports the storage and management of audio data.
SI_Color → The SI_Color object type encapsulates color values.
NCHAR Datatype → The 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