Working with Oracle SQL Developer 4.1.1 in Windows 10 - Part 1

In the previous post the details of downloading the free Oracle SQL Developer 4.1.1 and the Java SDK8 were described for a Windows 10 on a x32bit machine. As to requirements please refer to
this link. Although Windows 10 is not in the list of OSs, it seems to work without a problem, at least so far.

You do not need to install the Oracle SQL Developer tool as the executable (sqldeveloper.exe) is in the download.  Java8 SDK was downloaded and installed with the x64 bit SQL Developer on Window 10 on x32 bit laptop. However Oracle SQL Developer Tool 4.1.1  already had JDK8 and there was no need to install JDK8 separately.

Launch the SQL Developer by double clicking the executable. It starts off with the following:

 
SQL Developer411.png

There may be a message to restore previous connections and this was ignored.
The Oracle SQL Developer start page is displayed as shown.

SQLDevGui.png

At the top is the main menu and the toolbar is below the main menu. In the pane on the right you have a number of useful links including videos, featured tutorials and featured online demonstrations. You should make it a point to visit these links.

In the pane on the left at the top is the Connections pane where you establish connections. There are three links as shown.

Connections.png

Right click Connections to open the following:

Connections2.png

From here click New Connection... to open the following:

SelectDBConnection.png

It likes like as it stands you can only connect to an Oracle database. You may have bring in connection information for third part databases. Click Cancel.

Right click Oracle NoSQL Connection to open the following:

ConnectNoSQL.png

Click Cancel.

Right click Cloud Connections and click New Cloud Connection... to open the following interface:

ConnectionCloud.png

This is obviously to the Oracle Cloud. You must have some kind of authentication to get to the service.

The Reports pane at the bottom of the Connections pane has all diffrent reports that you can generate.

ReportsDetails.png
Video: Some major features

Articles on earlier versions of Oracle SQL Developer

If you are interested in reading about earlier versions of Oracle SQL Developer you may want to review these articles

http://www.devshed.com/c/a/Oracle/How-to-Use-the-Oracle-SQL-Developer-Tool/3/

MS Access Queries with Oracle SQL Developer 1.2 Tool

Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2

2008 was a very good year

During 2008 I managed to write more than 18 articles and a book. Got a lot of positive response from readers which has encouraged me to do better in 2009.

The following articles are available on the Packt site

VB.NET Application with SQL Anywhere 10 database
Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2
Microsoft SQL Server 2008 - Installation Made Easy

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps
Windows Presentation Foundation Project - Basics of Working
Understand and Use Microsoft Silverlight with JavaScript

Term Extraction Tasks in SQL Server Integration Services
Creating a Web Page for Displaying Data from SQL Server 2008
Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard

Creating a Simple Report with Visual Studio 2008
Data Processing using Derived Column and Aggregate Data Transformations
Creating an Analysis Services Cube with Visual Studio 2008 - Part 1

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2
Using the Data Pager Control in Visual Studio 2008
Oracle SQL Developer Tool 1.5 with SQL Server 2005

A Simple Pocket PC Application using Visual Studio 2005

These two appeared on other sites.

Web enabling data on a SQL Anywhere Server using a native web service

Retrieving Data on a SQL Anywhere Server Using AJAX

Consuming a SQL Anywhere native web service using a .NET client
International Sybase Users Group Technical Journal, May / June 2008, Pages 14 - 19

The first book had favorable reception and reviews (9) from readers. There were some adverse (2) reviews as well.

I thank all the reviewers and more importantly my readers.

The second book is in its final stages and will be published during the first quarter of 2009. You may order early copies with a discount from Packt. I have tried to make it as comprehensive as possible with more than 50 hands-on exercises. I hope it is as useful as I think it will be.

Oracle SQL Developer Tool 1.5 with SQL Server 2005

Oracle SQL Developer Tool

Oracle SQL Developer Tool is a stand alone program that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2.

Oracle SQL Developer Tool 1.5

While the default installation is ready to connect to Oracle and Access databases the other third-party products such as SQL Server 2005, MySQL and Sybase require additional JDBC drivers. This article describes how you may connect to SQL Server 2005 and SQLExpress servers using the JDBC drivers.

Go ahead and read it...

http://www.packtpub.com/article/oracle-sql-developer-tool-1.5-sql-server-2005