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.

This post has been answered by Dom Brooks on Sep 6 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Oct 4 2018

Added on Sep 6 2018

#oracle, #sql, #sql-pl-sql

2 comments

111 views