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
FLASHBACK TABLE → Purpose 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
DROP TABLE → Purpose 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
LOCK TABLE → Purpose 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.
CREATE TABLE → Purpose 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
ALTER TABLE → Purpose 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
TRUNCATE TABLE → Purpose 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
Selecting from the DUAL Table → DUAL 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
12 SQL Statements: ALTER TABLE to ALTER TABLESPACE → This chapter contains the following SQL statements: ALTER TABLE ALTER TABLESPACE
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.
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.
Table 7-7 OR Truth Table → OR 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;
Creating a Temporary Table → optional 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
Example: Creating a Table → When 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 … hr.departments (department_id)) TABLESPACE admin_tbs STORAGE ( INITIAL 50K); COMMENT ON TABLE hr.admin_emp IS … 'Enhanced employee
Table 35-1 DBA_2PC_PENDING → Column Description LOCAL_TRAN_ID Local transaction identifier in the format integer. integer. integer. Note: When the LOCAL_TRAN_ID and the GLOBAL_TRAN_ID for a connection are the same, the node is the global coordinator of the transaction. GLOBAL_TRAN_ID Global database identifier in the format global_db_nam e. db_hex_id. local_tran_id, where db_hex_id is an eight-character hexadecimal value used
Consider Using Table Compression → As your database grows in size, consider using table compression. Compression saves disk space … offset by reduced I/O requirements. Table compression is completely transparent to applications. It is … systems. You can specify compression for a tablespace, a table, or a partition. If specified at the … can occur while data is
Adding Table Columns → To 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
Chaining Pipelined Table Functions → To chain pipelined table functions tf1 and tf2 is to make the output of tf1 the input of tf2. For … example: SELECT * FROM TABLE(tf2(CURSOR(SELECT * FROM TABLE(tf1())))); The rows that tf1 pipes out … table functions are enabled for parallel execution, then each function runs in a different process (or … set of
Consider Parallelizing Table Creation → 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\".
Dropping Table Columns → You 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 … columns from
Overview of Table Functions → A table function is a user-defined PL/SQL function that returns a collection of rows (a nested … table or varray). You can select from this collection as if it were a database table by invoking the … table function inside the TABLE clause in a SELECT statement. For example: SELECT * FROM TABLE