Skip to Main Content

Compare and get the new data inserted into table based on month

user12251389Sep 6 2018 — edited Sep 6 2018

I have FM_TBL table which has month_id column which is number data type and dates are stored in this in format 'YYYYMM'.

I want to compare the data from previous month and current month and based on this find out the number of new rows inserted into FM_TABLE in the current month.

I am not sure if we have predefined function in oracle to find out number of rows.

pastedImage_4.png

This post has been answered by Dom Brooks on Sep 6 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 4 2018
Added on Sep 6 2018
2 comments
122 views