Currently I am using Bentley Map to display the Oracle spatial data to the user. As my company wants to migrate to ESRI, I need to find a method to display the Oracle spatial data in ArcMap, so that the users can view/edit the data in ArcMap Window. Also I will apply some spatial filters while retrieving the data. For example, get data which fall inside a particular boundary. So, can you suggest me what are all the methods ESRI provides for achieving this process.
Have you gone through the help topics? Simply go to this link and use the Search using Oracle as the keyword search
Here are a few
Dan pointed out some great topics for you to look into (which likely will answer your question). Do you have ArcGIS or have you tried to use Oracle Spatial Data within an ArcGIS environment yet?
If not, you could get a trial of ArcGIS to test it out. It may be the appropriate next step to take: