If your standby database is out of sync from primary or some archive logs got deleted before it is being shipped or applied to standby ,then you can follow below method to sync standby database with p...

In earlier version we have used row_num filter in where clause to limit the number of rows getting fetched. In oracle 18c, the new command, SET ROWLIMIT command enables users to set a limit for the nu...