Quick Search:
 
 Oracle PL/SQL: SELECT: Partition Select Jump to:  
Category: >> Oracle PL/SQL >> SELECT: Partition Select  

<< lastnext >>

Snippet Name: SELECT: Partition Select

Description: You can select rows from a single partition of a partitioned table by specifying the keyword PARTITION in the FROM clause.

The PARTITION keyword specifies the table, view, snapshot, or partition from which data is selected, or a subquery that specifies the objects from which data is selected.

Also see:
» TABLE: Using Select Statement With Data
» SELECT: Case insensitive search
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT or UNIQUE values
» SELECT: Get UNIQUE and DISTINCT values
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Language: PL/SQL
Highlight Mode: PHP
Last Modified: March 05th, 2009

SELECT DISTINCT <column_name_list>
FROM <table_name> PARTITION (<partition_name>);
 
 
-- This SQL statement assigns an alias FOR and retrieves rows 
-- from the NOV98 partition of the SALES table:
 
SELECT * FROM sales PARTITION (nov98) s
   WHERE s.amount_of_sale > 1000;
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org