Re: [sqlalchemy] Oracle - How to select from a table partition? - SELECT FROM table PARTITION (p0)

On Wed, Mar 28, 2018 at 7:07 PM, Matthew Moisen wrote: > I have an Oracle partitioned table created like so: > > DROP TABLE foos; > > CREATE TABLE foos ( > bar VARCHAR2(10) > ) PARTITION BY HASH (bar) ( > PARTITION P0, > PARTITION P1, > PARTITION P2, >

[sqlalchemy] Oracle - How to select from a table partition? - SELECT FROM table PARTITION (p0)

I have an Oracle partitioned table created like so: DROP TABLE foos; CREATE TABLE foos ( bar VARCHAR2(10) ) PARTITION BY HASH (bar) ( PARTITION P0, PARTITION P1, PARTITION P2, PARTITION P3 ); CREATE TABLE hellos ( bar VARCHAR2(10) ); I want to be able to issue deep,