Oracle SQL select dynamic partition

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.