Change the partitioning method for an Oracle table with: ALTER TABLE ... MODIFY PARTITION BY ... This can change The partition method (RANGE/LIST/HASH) The partition columns Add/remove subpartitioning Add the ONLINE clause to allow writes to continue while changing
1
6
17
Replies
Aggregate functions in #SQL report totals across many rows Common ones are COUNT, SUM, AVG, MAX, MIN Baraa Khatib Salkini explains how these work and how to use them to answer questions like How many orders are there? What's their total sales value? https://t.co/XzJDY1vagB
0
9
27