Accessing Oracle database
-
Hi we have an Oracle 10g database that I would like to connect to, the database has been written by a 3rd party. I was wondering what free tools I can use to access the tables, etc. Something similar to SQL Server management studio would be nice. Also if I need to install something else Oracle related, dll or whatever, in order to connect to it. We have the server, database login, etc, just need to connect to it! Thanks
-
Hi we have an Oracle 10g database that I would like to connect to, the database has been written by a 3rd party. I was wondering what free tools I can use to access the tables, etc. Something similar to SQL Server management studio would be nice. Also if I need to install something else Oracle related, dll or whatever, in order to connect to it. We have the server, database login, etc, just need to connect to it! Thanks
Dangermouse99 wrote:
Something similar to SQL Server management studio would be nice.
Something like Sql Developer[^] perhaps?
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
Dangermouse99 wrote:
Something similar to SQL Server management studio would be nice.
Something like Sql Developer[^] perhaps?
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
Thanks, that looks good.
-
Thanks, that looks good.
No problem. Glad to help.
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
Hi we have an Oracle 10g database that I would like to connect to, the database has been written by a 3rd party. I was wondering what free tools I can use to access the tables, etc. Something similar to SQL Server management studio would be nice. Also if I need to install something else Oracle related, dll or whatever, in order to connect to it. We have the server, database login, etc, just need to connect to it! Thanks
I downloaded Oracle's ADO.net connector and added support for it in my database classes. That meant that I could access Oracle databases from my console and WinForms apps, including one that allows the user to enter ad hoc queries and view the schema.
-
Hi we have an Oracle 10g database that I would like to connect to, the database has been written by a 3rd party. I was wondering what free tools I can use to access the tables, etc. Something similar to SQL Server management studio would be nice. Also if I need to install something else Oracle related, dll or whatever, in order to connect to it. We have the server, database login, etc, just need to connect to it! Thanks
SQLTools[^] if you want it lightweight. TOra[^] is at the other end of the spectrum. Both are opensource. SQL Developer and Oracle Developer Tools for Visual Studio has already been mentioned. They are from Oracle and are supported, ... sort of. You will also need to install some version of the Oracle Client which is available in several versions such as the normal Client, Instant Client or Oracle Data Provider for Dotnet. Oracle Developer Tools for Visual Studio has the Client built in.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions