Home » SQL & PL/SQL » SQL & PL/SQL » PARTITION PROBLEM
PARTITION PROBLEM [message #422] Mon, 11 February 2002 12:21 Go to next message
lily
Messages: 44
Registered: September 2000
Member
Hi.

db: oracle 8.1.7
table: 'xxx'
columns (in 'xxx'table ) : 'a1', 'a2','a3','a4'.
data in column 'a1': 'NJ', 'CA', 'NY'

NB: column 'a1' contains 6000 rows for 'NJ'.

Now, I want to create a partition for column 'a1' which should only hold 'NJ'. How do I define this?
I am confused to use 'By Range'.

Please help.
lily.

Report message to a moderator

Re: PARTITION PROBLEM [message #475 is a reply to message #422] Thu, 14 February 2002 19:56 Go to previous message
vaidehi
Messages: 3
Registered: February 2002
Junior Member
select column_name from 'xxx' where
column_name='NJ';

Report message to a moderator

Previous Topic: Procedure to drop tables
Next Topic: Re: ORA-00937: not a single-group group function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 12 18:12:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.