Hi Team,
I want to sort the data based on long datatype.
I am using Oracle table to find the partition table information.
SELECT TABLE_NAME,
PARTITION_NAME,
high_value
FROM USER_TAB_PARTITIONS
WHERE TABLE_NAME='DETAIL_MICROWAVE_HIST'
Now I want to sort the value based on high_value.However when I am modifiying the query to this
SELECT TABLE_NAME,
PARTITION_NAME,
high_value
FROM USER_TAB_PARTITIONS
WHERE TABLE_NAME='DETAIL_MICROWAVE_HIST'
order by high_value
Getting this value
ORA-00997: illegal use of LONG datatype
00997. 00000 - "illegal use of LONG datatype"
*Cause:
*Action:
Error at Line: 54 Column: 1
How to overcome this error.
Thanks,
Tanmoy