SQL Developer is a free tool from Oracle which is great for database querying and extraction and the best thing is that it doesn’t just support Oracle it also supports Access, MySQL and SQL Server. Another hidden feature for all the novice SQL programmers is the Query Builder (similar to Access and SQL Server), so I thought I would do a quick post to go over the features of Query Builder.
Ever wanted to get a query or table which you have in Access exported into a table in an Oracle database? Read on!
Related : Connecting an Excel Pivot Table with an Oracle database
In my tutorials on how to connect a Pivot Table to an Access database and an Oracle database I have gone through how you can set up an ODBC connection in great detail however I know a lot of people are starting to use MySQL a lot more and would like to use Office products such as Excel and Access with MySQL as well. This tutorial looks at how to configure an ODBC connection to a MySQL database which is either:
Related Posts:
Earlier I posted about how to use an Excel Pivot Table with an Access database, today I thought I would go through how you can connect an Excel Pivot Table to an Oracle database.
Recent Comments