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 17346 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

LOCK TABLE

LOCK TABLEPurpose Use the LOCK TABLE statement to lock one or more tables, table partitions, or table … access to a table or view by other users for the duration of your operation. Some forms of locks can be … placed on the same table at the same time. Other locks allow only one lock for a table.

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

TRUNCATE TABLE

TRUNCATE TABLEPurpose Caution: You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE … statement to retrieve the contents of a table that has been truncated. Use the TRUNCATE TABLE … statement to remove all rows from a table. By default, Oracle Database also performs the following tasks

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

CREATE TABLE

CREATE TABLEPurpose Us e the CREATE TABLE statement to create one of the following types of tables: A … relational table, which is the basic structure to hold user data. An object table, which is a table that uses … an object type for a column definition. An object table is explicitly defined to hold object

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

DROP TABLE

DROP TABLEPurpose Use the DROP TABLE statement to move a table or object table to the recycle bin or to … remove the table and all its data from the database entirely. Caution: Unless you specify the PURGE … clause, the DROP TABLE statement does not result in space being released back to the tablespace for use

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

ALTER TABLE

ALTER TABLEPurpose Use the ALTER TABLE statement to alter the definition of a nonpartitioned table, a … partitioned table, a table partition, or a table subpartition. For object tables or relational tables with … object columns, use ALTER TABLE to convert the table to the latest

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

FLASHBACK TABLE

FLASHBACK TABLEPurpose Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of … human or application error. The time in the past to which the table can be flashed back is dependent … on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier … state

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

Selecting from the DUAL Table

Selecting from the DUAL TableDUAL is a table automatically created by Oracle Database along with the data dictionary. DUAL is in … , DUMMY, defined to be VARCHAR2(1), and contains one row with a value X. Selecting from the DUAL table is … expression from any table, but the value will be returned as many times as there are rows in the table

Database Administrator's Guide, 11g Release 1 (11.1)

Researching and Reversing Erroneous Table Changes

Researching and Reversing Erroneous Table Changesthe option of using Oracle Flashback Table, described in \"Recovering Tables Using Oracle Flashback … Table\". Note: You must be using automatic undo management to use Oracle Flashback features. See

Database Administrator's Guide, 11g Release 1 (11.1)

Recovering Tables Using Oracle Flashback Table

Recovering Tables Using Oracle Flashback TableRecovering Tables Using Oracle Flash back Table Oracle Flashback Table enables you to restore a … table to its state as of a previous point in time. It provides a fast, online solution for recovering a … table that has been accidentally modified or deleted by a user or application. In many cases … , Oracle Flashback

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

SQL Statements: ALTER TABLE to ALTER TABLESPACE

12 SQL Statements: ALTER TABLE to ALTER TABLESPACEThis chapter contains the following SQL statements: ALTER TABLE ALTER TABLESPACE

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

Logical Conditions

Table 7-6 AND Truth Table: SELECT * FROM employees WHERE hire_date 2500 ORDER BY employee_id; Table 7-7 shows the results of applying OR to two expressions.

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

Logical Conditions

Table 7-5 NOT Truth Table-- TRUE FALSE UNKNOWN NOT FALSE TRUE UNKNOWN Table 7-6 shows the results of combining the AND condition to two expressions.

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

Logical Conditions

Table 7-7 OR Truth TableOR TRUE FALSE UNKNOWN TRUE TRUE TRUE TRUE FALSE TRUE FALSE UNKNOWN UNKNOWN TRUE UNKNOWN UNKNOWN For example, the following query returns employees who have a 40% commission rate or a salary greater than $20,000: SELECT employee_id FROM employees WHERE commission_pct =.4 OR salary > 20000 ORDER BY employee_id;

Database Administrator's Guide, 11g Release 1 (11.1)

Redefining Tables Online

Online Table Redefinition Examplesdescriptions of all DBMS_REDEFINITION subprograms. Example Description Example 1 Redefines a table by adding … single table partition, moving it to a different tablespace. Example 1 This example illustrates online … redefinition of the previously created table hr.admin_emp, which at this point only contains columns … : empno,

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tables

Parallelizing Table CreationWhen you specify the AS SELECT clause to create a table and populate it with data from another … table, you can utilize parallel execution. The CREATE TABLE...AS SELECT statement contains two parts: a … in the CREATE TABLE...AS SELECT statement An ALTER SESSION FORCE PARALLEL DDL statement is … one of the tables

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Tables

Adding Table ColumnsTo add a column to an existing table, use the ALTER TABLE...ADD statement. The following statement … alters the hr.admin_emp table to add a new column named bonus: ALTER TABLE hr.admin_emp ADD (bonus … NUMBER (7,2)); If a new column is added to a table, the column is initially NULL unless you specify

Database Administrator's Guide, 11g Release 1 (11.1)

Loading Tables

Error Logging Table FormatThe error logging table consists of two parts: A mandatory set of columns that describe the error … . For example, one column contains the Oracle error number. Table 18-1 lists these error description … names match the column names from the table being inserted into (the \"DML table\"). The number of … columns

Database Administrator's Guide, 11g Release 1 (11.1)

Analyzing Tables, Indexes, and Clusters

Creating a CHAINED_ROWS TableTo create the table to accept data returned by an ANALYZE...LIST CHAINED ROWS statement, execute … table named CHAINED_ROWS in the schema of the user submitting the script. Note: Your choice of script to … execute for creating the CHAINED_ROWS table is dependent upon the compatibility level of your … database and the type of table

Database Administrator's Guide, 11g Release 1 (11.1)

Scheduler Architecture

The Job TableThe job table is a container for all the jobs, with one table per database. The job table stores

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tables

Example: Creating a TableWhen you issue the following statement, you create a table named admin_emp in the hr schema and … store it in the admin_tbs tablespace: CREATE TABLE hr.admin_emp ( empno NUMBER(5) PRIMARY KEY, ename … (department_id)) TABLESPACE admin_tbs STORAGE ( INITIAL 50K); COMMENT ON TABLE hr.admin_emp IS 'Enhanced … employee table';