I Have a table with a column as timestamp with timezone as shown below.
desc log_records: id number not null, event_id number not null, event_desc varchar2(2000), log_date timestamp with time zone
How do i suppose to group the records like
older than 300 days 12 rows older than 250 days 12831 rows older than 200 days 438121 rows
based on the current date in oracle