```
BEGIN 
  dbms_stats.set_table_prefs 
    ( ownname => 'SALES_MART', 
      tabname =>  SELECT DISTINCT (table_name) 
                  FROM all_part_tables 
                  WHERE OWNER = 'SALES_MART', 
      pname   => 'INCREMENTAL', 
      pvalue  =>'TRUE' 
    ); 
END;

```

> 
> ORA-06550: line 5, column 16: PLS-00103: Encountered the symbol
>  "SELECT" when expecting one of the following:
> 
> 
> ( - + case mod new not null continue avg count current exists max min
>  prior sql stddev sum variance execute forall merge time timestamp
>  interval date pipe
> 
> 
> & - + ; / at for mod remainder rem and or group having intersect minus
>  order start union where connect || multiset
> 
> 
>