I've been stuck in a bit of an awkard position. I've been using Microsoft development products all my working life, including SQL Server, and I've now been asked to write an application which is going to have to interface with an Oracle database.
The DB in question is powering a bought-in application but I need to be able to read and modify the data for other purposes. Before I can do this though I need to get to look at the tables and relationships of the data so I can construct effective queries to retrieve and modify the data that I need.
I've been to have a look at the Oracle server in question (it's running Windows Server 2003) to see if I can find some sort of graphical interface to allow me to explore the tables and the data in them. In SQL Server I'd use Enterprise manager for this, so I presumed the Oracle Enterprise manager did the same job. However, it doesn't seem to - I can't get a visual listing of table names and without them I can't construct queries to look at the data, let alone find a GUI tool to dump it for me. I'm not even sure I can see the database I'm supposed to be working with.
Can any of you kind people possibly enlighten me as to how I can get a table listing and/or point me at a good introduction to the Oracle toolset so I can start to get to grips with this beast?