Hi every one.
I like to call my table partitions in select statement but unable to do so. I can select one partition at a time but unable to query multiple.
I am trying to run query in this manner.
select * from table partition( select partition_name from dab_tab_partitions
where table_owner = 'ABCD'
and table_name = 'Table Name'
and partition_position >= (select max(partition_position) - 4 from dba_tab_partitions
where table_owner = 'ABCD'
and table_name = 'Table Name'))
it gives me error, ORA:00933 SQL Command Not Properly Ended.