Oracle data change notificationHello Everyone,
I have a requirement to watch oracle database continuously and get notification as soon as changes happens in the database , Collect changed data ,create excel/cvs/xml file and dump in some folder. These files will be moved to other server using SFTP.
Some of these data will be converted into jason format and sent to cloud in the message format.
I am very new to oracle .
I am not sure which feature of oracle is best fit for above situation.
I am thinking "continues query change notification" will help but not sure .