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


21 to 40 of 17346 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

Creating Tables

Creating a Temporary Tableoptional itineraries. Each itinerary is represented by a row in a temporary table. The application … wants to use, the application moves the row for that itinerary to a persistent table. During the … . The definition of a temporary table is visible to all sessions, but the data in a temporary table is … visible

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

Guidelines for Managing Tables

Consider Parallelizing Table CreationCREATE TABLE statement. Because multiple processes work together to create the table, performance of the … table creation operation is improved. Parallelizing table creation is discussed in the section \"Parallelizing Table Creation\".

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

Guidelines for Managing Tables

Consider Using Table CompressionAs your database grows in size to gigabytes or terabytes and beyond, consider using table … compression. Table compression saves disk space and reduces memory use in the buffer cache. Table compression … loading and DML. Table compression is completely transparent to applications. It is especially … can also be

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

Altering Tables

Dropping Table ColumnsYou can drop columns that are no longer needed from a table, including an index-organized table … data then re-create indexes and constraints. You cannot drop all columns from a table, nor can you … drop columns from a table owned by SYS. Any attempt to do so results in an error. See Also: Oracle … Database SQL

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

Altering Tables

Renaming Table ColumnsOracle Database lets you rename existing columns in a table. Use the RENAME COLUMN clause of the … ALTER TABLE statement to rename a column. The new name must not conflict with the name of any existing … column in the table. No other clauses are allowed in conjunction with the RENAME COLUMN clause. The … following statement renames

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

DBMS_REPAIR Examples

Examples: Building a Repair Table or Orphan Key TableThe ADMIN_TABLE procedure is used to create, purge, or drop a repair table or an orphan key table … . A repair table provides information about the corruptions that were found by the CHECK_OBJECT … to drive the execution of the FIX_CORRUPT_BLOCKS procedure. An orphan key table is used when the … DUMP_ORPHAN_KEYS

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

BETWEEN Conditions

Table 7-10 BETWEEN ConditionsType of Condition Operation Example [NOT] BETWEEN x AND y [ NOT ] ( expr2 less than or equal to expr1 AND expr1 less than or equal to expr3 ) SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;

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

Null Conditions

Table 7-9 Null ConditionsType of Condition Operation Example IS [NOT] NULL Tests for s. See Also: \"Nulls\" SELECT last_name FROM employees WHERE commission_pct IS NULL ORDER BY last_name;

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

Tuning PL/SQL Applications for Performance

Overview of Pipelined Table FunctionsPipelined table functions let you use PL/SQL to program a row source. You invoke the table function … as the operand of the table operator in the FROM list of a SQL SELECT statement. It is also … possible to invoke a table function as a SELECT list item; here, you do not use the table operator. A table

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

Graphic Syntax Diagrams

Table A-1 Syntax ParametersParameter Description Examples table The substitution value must be the name of an object of the

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

Arithmetic Operators

Table 4-2 Arithmetic OperatorsOperator Purpose Example + - When these denote a positive or negative expression, they are unary operators. SELECT * FROM order_items WHERE quantity = -1 ORDER BY order_id, line_item_id, product_id; SELECT * FROM employees WHERE -salary + - When they add or subtract, they are binary operators. SELECT hire_date FROM employees WHERE SYSDATE - hire_date > 365 ORDER BY hire_date; * / Multiply, divide.

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

Comparison Conditions

Table 7-2 Comparison ConditionsType of Condition Purpose Example = Equality test. SELECT * FROM employees WHERE salary = 2500 ORDER BY employee_id; != ^= ÿ= Inequality test. Some forms of the inequality condition may be unavailable on some platforms. SELECT * FROM employees WHERE salary != 2500 ORDER BY employee_id; > Greater-than and less-than tests. SELECT * FROM employees WHERE salary > 2500 ORDER BY employee_id; SELECT *

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

Redefining Tables Online

Features of Online Table RedefinitionOnline table redefinition enables you to: Modify the storage parameters of a table or cluster Move … a table or cluster to a different tablespace Note: If it is not important to keep a table available … for DML when moving it to another tablespace, you can use the simpler ALTER TABLE MOVE command. See

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

DBMS_REPAIR Examples

Example: Creating a Repair TableThe following example creates a repair table for the users tablespace. BEGIN … => dbms_repair.create_action, TABLESPACE => 'USERS'); END; / For each repair or orphan key table, a view is also … corresponds to the name of the repair or orphan key table and is prefixed by DBA_ (for example … , DBA_REPAIR_TABLE or DBA_ORPHAN_KEY_TABLE

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

Logical Conditions

Table 7-4 Logical Conditions' OR department_id = 10 ORDER BY employee_id; Table 7-5 shows the result of applying the NOT condition to an expression.

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

GRANT

Table 18-1 System Privileges… CREATE ANY CLUSTER Create a cluster in any schema. Behaves similarly to CREATE ANY TABLE. ALTER ANY … schema a domain index or an index on any table in any schema. ALTER ANY INDEX Alter indexes in any … view on any table in the database. Alter a refresh-on-demand materialized on any table in the database

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

IN Condition

Table 7-12 IN ConditionsType of Condition Operation Example IN Equal-to-any-member-of test. Equivalent to =ANY. SELECT * FROM employees WHERE job_id IN ('PU_CLERK','SH_CLERK') ORDER BY employee_id; SELECT * FROM employees WHERE salary IN (SELECT salary FROM employees WHERE department_id =30) ORDER BY employee_id; NOT IN Equivalent to != ALL. Evaluates to FALSE if any member of the set is NULL. SELECT * FROM employees WHERE

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

Set Operators

Table 4-4 Set OperatorsOperator Returns UNION All distinct rows selected by either query UNION ALL All rows selected by either query, including all duplicates INTERSECT All distinct rows selected by both queries MINUS All distinct rows selected by the first query but not the second

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

Loading Tables

Creating an Error Logging TableYou can create an error logging table manually, or you can use a PL/SQL package to automatically create one for you.

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

Creating Hash Clusters

Creating Single-Table Hash ClustersYou can also create a single-table hash cluster, which provides fast access to rows in a table … . However, this table must be the only table in the hash cluster. Essentially, there must be a one-to-one … mapping between hash keys and data rows. The following statement creates a single-table hash