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 TABLE


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


Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

2 Basic Components of Oracle Objects

TABLE()Table functions are functions that produce a collection of rows, a nested table or a varray, that … can be queried like a physical database table or assigned to a PL/SQL collection variable. You can … use a table function like the name of a database table, in the FROM clause of a query, or like a

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on Temporary Tables Temporary tables cannot be partitioned, clustered, or index organized.…relational_properties The relational properties describe the components of a relational table … . column Specify the name of a column of the table. If you also specify AS subquery, then you can omit … column and datatype unless you are creating an index-organized table. If you specify AS subquery when … creating an index-organized

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Dropping Constraints You cannot drop a primary key or unique key constraint that is…an external table. This clause has no affect on the external data itself. The syntax and semantics of … the same as described for CREATE TABLE. See the external_table_clause (in CREATE TABLE ). PROJECT … table in subsequent queries. The default is PROJECT COLUMN REFERENCED, which means that the access … than the

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on List Subpartitioningthe list_values_clause, which is subject to the same requirements as at the table level. In the

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Notes on Composite PartitionsCREATE TABLE statement, NOCACHE is the default In an ALTER TABLE statement, the existing value is not … for this table are placed at the most recently used end of the least recently used (LRU) list in the … buffer cache when a full table scan is performed. This attribute is useful for small lookup tables … -organized

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on the Defining Query of a TableThe number of columns in the table must equal the number of expressions in the subquery. The column … . You cannot define a foreign key constraint in a CREATE TABLE statement that contains AS subquery … . Instead, you must create the table without the constraint and then add it later with an ALTER TABLE … statement.

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on Hash Partitioning… list_partitioning Use the list_partitioning clause to partition the table on lists of literal values

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Adding ColumnsYou cannot add a LOB column to a cluster table. If you add a LOB column to a hash-partitioned table … column with a NOT NULL constraint if table has any rows unless you also specify the DEFAULT clause. If … you specify this clause for an index-organized table, then you cannot specify any other clauses in … statement

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Adding List Partitionslist partition if you have already defined a DEFAULT partition for the table. Instead you must use … TABLE for more information and restrictions on list partitions "Working with Default List … value. Restriction on Coalescing Table Partitions If you update global indexes using the … partitioned table. If you want

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Moving TablesIf you specify MOVE, then it must be the first clause in the ALTER TABLE statement, and the only … , and the LOB_storage_clause. You cannot move a table containing a LONG or LONG RAW column. You cannot … MOVE an entire partitioned table (either heap or index organized). You must move individual … segments, even if you do not specify

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on List Partitioningamong all partitions of table. composite_partitioning Use the composite_partitioning clause to first … partition table by range, and then partition the partitions further into hash or list subpartitions … Partitioning You cannot specify composite partitioning for an index-organized table. Therefore, the … composite partitioning.

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Records in a Blocktable. You must first drop the bitmap index. You cannot specify this clause for an index-organized table … or a nested table. MINIMIZE Specify MINIMIZE to instruct Oracle Database to calculate the largest … number of records in any block in the table and to limit future inserts so that no block can contain … in

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Notes on Exchanging Partitions and Subpartitionscan be referencing either of the tables unless the referenced table is empty. When exchanging … between a partitioned table and the range partition of a composite-partitioned table: The partitioning key … of the partitioned table must be identical to the subpartitioning key of the composite-partitioned … table.

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Nested Table Column Properties You cannot specify the parallel_clause. You cannot specify…defaults to the tablespace of the containing table. LOB_storage_clause Use the LOB_storage_clause to … different from those of the table. For LOB_segname, specify the name of the LOB data segment. You cannot … when moving the table ( move_table_clause ). CHUNK integer Specify the number of bytes to be

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Dropping Columns Each of the parts of this clause can be specified only once in the…rename_column_clause Use the rename_column_clause to rename a column of table. The new column name … must not be the same as any other column name in table. When you rename a column, Oracle Database

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Notes on the parallel_clausereferential integrity constraint. If you define a bitmap index on table, then: If table is nonpartitioned … , then subsequent DML operations are executed serially. If table is partitioned, then the database … limits the degree of parallelism to the number of partitions accessed in the DML operation. If table

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Altering External TablesYou cannot modify an external table using any clause outside of this clause. You cannot add a LONG … , varray, or object type column to an external table, nor can you change the datatype of an external … table column to any of these datatypes. You cannot add a constraint to an external table. You cannot … modify

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on External Tables An external table cannot be a temporary table. You cannot specify constraints…driver for this external table. The opaque_format_spec lets you list the parameters and their values … opaque_format_spec. Field names specified in the opaque_format_spec must match columns in the table … the table definition. USING CLOB subquery lets you derive the parameters and their values through a … . CLUSTER Clause The

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Moving Table Partitions If partition is a hash partition, then the only attribute you…high end of a partitioned table (after the last existing partition). You can specify any create … -time physical attributes for the new partition. If the table contains LOB columns, then you can also … composite-partitioned table and do not describe the subpartitions, then the database assigns subpartition … names as described

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Dropping Table Partitions You cannot drop a partition of a hash-partitioned table. Instead,…-partitioned table. Oracle Database deletes any rows in the dropped subpartition. Oracle Database drops