Get the free Oracle SQL Developer 4.1.1 and develop

This is a great tool and has evolved a lot. The last time I wrote about this was in May 2014 when the version was 4.0.2. If you have not worked with this tool, please access Oracle.com and search. If you need information on previous versions you can access my previous posts here;
----
http://hodentek.blogspot.com/2007/08/do-you-know-how-to-use-oracle-sql.html
http://hodentek.blogspot.com/2008/12/oracle-sql-developer-tool-15-with-sql.html
http://hodentek.blogspot.com/2009/05/articles-on-earlier-versions-of-oracle.html
http://hodentek.blogspot.com/2010/01/migrating-mysql-table-using-oracle-sql.html
http://www.packtpub.com/article/oracle-sql-developer-tool-1.5-sql-server-2005

You may download this free tool from here:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
sqldeveloper-4.1.1.19.59-no-jre.zip (383.6MB)

This free tool will allow you a complete end-to-end development of PL/SQL applications. It has worksheet to run queries and SQL scripts. A DBA console with reports; data modelling and data migration tools.

In order to run SQL Developer Tool you need Java SDK8.

You can get it from here:
http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
You choose the OS version, herein Windows 7 Ultimate  x32bit
jdk-8u60-windows-i586.exe is the download for this Windows x32

Double click to install.

In this edition of Oracle SQL Developer you can not only connect to relational database management systems but can also connect to Oracle NoSQL and the Cloud.

Vastly improved Oracle SQL Developer Tool 4.0

This is a great tool if you are working with Oracle and you can do all of this:
Develop
Administer
Model
Migrate

I have been using SQL Developer tool since 2007 and I find the latest version released this may vastly improved with a rich interface.

The latest release 4.0 can be downloaded from here:
Oracle SQL Developer 4.0.2 (4.0.2.15.21)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The x64 bit version I downloaded came with the required JDK (7.0).

Apart from these new features SQL Developer 4.0 it supports Oracle database 12C:

• Database performance monitoring'
• Database search
• Command line support now covers reporting and Cart
• Cart itself has enhanced features-multiple cart support; export ddl options, etc.
• Creating and drill -down on Reports with floating Editor and Navigation windows
• UI enhancements- Usability enhancements
• Data modeler is now 4.0 to support 12C with masking of sensitive data and ability to create Trasparent Sensitive Data Protection
• Oracle Migrations
• Oracle Data Miner

Installation cannot be easier than this. Download the zip file (Choose the one that you can work
with), unzip and start using.

While installing you may import your preferances from an earlier version if it exists. The
computer I am using did not have any previous installation.

The User Interface gets displayed as shown with a modal window requesting your permission
to track usage for product improvement.  I generally say, OK.

The View menu shows many of the features that you will be using.

Team menu lets you connect to GIT or to Subversion

The Start page also has important informative content such as Videos; Tutorials and Online demonstrations, etc

 

The Tools menu is also feature rich as it gives you access to many of tasks you may need to perform and the Data Modeler submenu shown above shows many features of database administration'



You must not forget to take a look at the Help | About which gives an idea of all the extensions

You will agree that SQL Developer has evolved vastly from its beginnings,

This vastly improved compared to the ones I used in previous years:

Here is a context for this article if you have missed the earlier ones:

http://hodentek.blogspot.com/2007/08/do-you-know-how-to-use-oracle-sql.html

http://hodentek.blogspot.com/2008/12/oracle-sql-developer-tool-15-with-sql.html

http://hodentek.blogspot.com/2009/05/articles-on-earlier-versions-of-oracle.html

http://hodentek.blogspot.com/2010/01/migrating-mysql-table-using-oracle-sql.html

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

Windows Azure/Oracle Colloboration is done deal

It is now official that the collaboration deal is in place according to a general availability. Details here:
Announcing General Availability of Oracle Software on Windows Azure and Updates to Windows Azure Traffic Manager

Open and flexible platforms are in vogue and that was adopted as a rule by Windows Azure. Partenership with Oracle reaches a new height with this collaboration and what this means is the following Oracle products are now generally available as viratual images and more with license thrown in.

On Windows Server 2008 R2
Oracle database 11g R2 -Standard and Enterprise
Oracle Weblogic Server 11g R2 -Standard and enterprise
Oracle database 11g R2 and Oracle Weblogic Server 11g R2 Standard
Oracle Weblogic Server 11g Standard

On Windows Server 2012
JDK6
Oracle database 12c and Weblogic Server 12c Standard
Oracle database 12c Standard
Oracle Weblogic Server 12c Standard
Oracle database 12c and Weblogic Server 12c Enterprise
Oracle database 12c Enterprise
Oracle Weblogic Server 12c Enterprise

You can get to them via the Windows Azure Image gallery.
It is very easy to access these images to create your virtual server application.
Login to portal
Click the portal icon and open this window

Click on From Gallery and then Select Oracle on the list on the left to display the following:





Well you can try it or buy it from Windows Azure as shown:

Good luck with your implementations!!

 Vis-a-vis the collboration Oracle supports all these for databse and java developers.

Oracle Day in Honolulu, January 28, 2014

Converge, Connect was the theme of the Oracle Innovation Forum in Honolulu,
Hawaii. With an attendance of over 100 there were lots of interesting
discussions. The event took place in the ball rooms of Westin Moana Surfrider
on the beach side of Waikiki.

The event started off with the key note, Innovation in Practice by Gayle
Fitzpatrik focusing on innovation, convergence and integration. She touched
upon Oracle Cloud Solutions. 25 million Users, and over 10000 customers makes a
compelling case. There were many slides showing how Oracle Cloud Solutions were
better than others in all respects including flexibility, security, and
performance. She also spoke about the dawn of the M2M era and the Internet of
things. In any case business should be good in the coming years with over 50
billion connected devices. Some examples of Oracle solutions adopted by industry
was also mentioned with  lot more details about a Regional Power
Company.

Mark Kelder of Oracle described the Oracle 12 C features; the advantages of
pluggable vs. separate databases for an enterprise. The scaling of pluggable
databases beats that of Separate databases by a wide margin. With Container
Database 12.1, the upgrading in place (in-situ) is a matter of minutes (I am not sure if I got the unit correct; I will sure when the promised PPT arrive)  and you
can plug/unplug databases as required (versions 10.2, 11.1 and 12.1). Point in
time recovery for plugged databases is another great feature which is most
appropriate for SaaS. He also described the cloning of pluggable databases for
test and development as well as dual format covering both row and column for
the in-memory database.

Troy Kitch spoke on Internet of things and various security regulatory
compliances (PII, PCI, PIPEDA, PCI DSS and Directive 95/46/EC). Unfortunately I missed most part of his talk.

In the afternoon Srividhya Kasturi explained the details of Oracle Mobile
Solution covering Mobile Apps; Mobile Platform and Mobile Security. She
mentioned MbaaS, the Mobile backend as service. There was a lot of talk in
trying to answer, what is driving the cloud? Globalization; data explosion;
rise of mobile devices; Social media; and the necessity to modernize to
survive were all mentioned.

I am not sure if this is the order of importance in the driving forces
but what appears to be given is security is still a troubling issue.

She also touched upon a hybrid cloud with private cloud (SaaS, Paas, and IaaS) and Public Cloud (SaaS and PaaS). 5 considerations for cloud integration were laid out; Connectivity, flexibility, (Visibility-Management?), security and scalability). CISCO WebEx order management system with Oracle SOA Suite was mentioned.

Michelle Beasley and Gia Villanueva compared and contrasted traditional ETL+CDC
vs. the modern E-LT + real time. Ross stores case study was mentioned.

All in all it was an interesting day with all the modern buzz and Oracle as
usual extended impeccable hospitality to the attendees.

Full schedule here: