Jumbabox

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.

Read the rest of this entry »

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

Read the rest of this entry »

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.

Read the rest of this entry »