|
-
 Originally Posted by ebrian
Code:
select distinct
from partition ;
Am I missing something?
SQL> desc month_part;
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER
B NUMBER
C DATE
select partition_name from user_tab_partitions where table_name ='MONTH_PART'
APR10
MAY10
JUN10
SYS_P25
SYS_P21
SYS_P24
SYS_P22
SYS_P23
SQL> select distinct (c) from month_part partition SYS_P22;
select distinct (c) from month_part partition SYS_P22
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|