Using Oracle partition tables in qlikview dynamically

Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I am using Qlikview 11.0, I am using ODBC connection to connect to Qlikview, now my requirement is I want to use a Oracle partitioned table to extract data, I am using the below commands to extract data from a oracle partitioned table, but it is giving me error "SQL Command Not Properly Ended", I am sharing the syntax as below, please help on how to use correct syntax for using Oracle partitioned tables.

select partition_name From

(

select Row_Number() OVER (Order by date_time desc) rno, partition_name,date_time

From user_tab_partitions where lower(table_name)='tab1'

)

where rno = 2;

LET var=Peek('partition_name');

select col1,col2,partition_date from tab1 partition ($(var));

topic Using Oracle partition tables in qlikview dynamically in QlikView

Using Oracle partition tables in qlikview dynamically