BEGIN
dbms_stats.delete_column_stats(
ownname=>'SH', tabname=>'SALES', colname=>'PROD_ID', col_stat_type=> 'HISTOGRAM');
END;
/
Partition by Expression
-
Oracle 26.1 now allows using an *Expression* in the Partitioning Clause.
In earlier releases, you could do this with a Virtual Column defined in the
ta...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu