OraFAQ Forum: SQL & PL/SQL » How write SQL(select) with a partitioned table

Home » SQL & PL/SQL » SQL & PL/SQL » How write SQL(select) with a partitioned table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How write SQL(select) with a partitioned table [message #23304]

Wed, 27 November 2002 23:47

Jermi
Messages: 2
Registered: November 2002

Junior Member

Hello:
I have created the following test example:
> CREATE TABLE t_test
> (f1 NUMBER,
> f2 number)
> PARTITION BY RANGE(f1)
> (PARTITION t_test1000 VALUES LESS THAN (10000),
> PARTITION t_test2000 VALUES LESS THAN (100000),
> PARTITION t_test3000 VALUES LESS THAN (500000),
> PARTITION t_test_inf VALUES LESS THAN (MAXVALUE))
> /
IN t_test table have 1000000 rows,I think only select data in PARTITION(t_test3000),how write select?

Report message to a moderator

Re: How write SQL(select) with a partitioned table [message #23307 is a reply to message #23304]

Thu, 28 November 2002 11:26

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi try as below
select * from t_test_table partition (t_test1000);

sai

Report message to a moderator

Re: How write SQL(select) with a partitioned table [message #23311 is a reply to message #23307]

Fri, 29 November 2002 11:12

Su
Messages: 154
Registered: April 2002

Senior Member

I think the ORACLE 9.0 onwards it supports you giving only the partion name in an SQL SELECT, just like

select * from t_test1000);

Check it out.

Good luck :)

Report message to a moderator

Re: How write SQL(select) with a partitioned table [message #23322 is a reply to message #23311]

Sun, 01 December 2002 21:08

Jermi
Messages: 2
Registered: November 2002

Junior Member

I use oracle8.1.6 to run "select * from t_test partition (t_test1000);",it can triumphantly run.

You think the ORACLE 9 supports direct use partition name? But I think this fall short of SQL syntax!Oracle dare to do this thing?

Report message to a moderator

Previous Topic:	Re: regarding databaselinks
Next Topic:	A problem with infinite loop in trigger.....Pliz solve my problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 19:05:26 CDT 2024