Hello all.
New to Oracle and to SQL, was wondering how I could use partitioning in my select statements
Trying to use the most recent partition with rows of data.
Select *From my_table partition (" select from partition where table name = 'my_table and nvl(num_rows,0) <> 0")
basically have a number of partition in my table and would like to dynamically use the latest partition with data.