System News
 1 2 3 next
Articles for the keywords: Oracle SQL Developer
20 Mar 2017 Oracle Database 12c Release 2: Analytic Views & SQL Developer [61839]
By Jeff Smith

One of the major new features in Oracle Database 12c Release 2 is Analytic Views

Jeff Smith writes, "An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data.

Analytic views layer a hierarchical/dimensional model over data. Analytic views are defined over the dimension tables and fact table of a star schema. Hierarchies are defined over dimension tables. The analytic view references hierarchies and a fact table.

I'm not here to introduce this new feature itself, more just to let you know that Oracle SQL Developer v4.2 has a TON of support for it - courtesy the same team that built this database feature.

If you'd like to take a tutorial on this subject, LiveSQL has a nice on-line demo - no database required!..."
(Get More Information . .) open to premium members only

28 Jan 2016 Top 10 MySQL GUI Tools (Slideshow) [49396]
Database Journal, January 28th, 2016

"A few things have changed in the database landscape since our Top 10 MySQL GUI Tools list was compiled--in particular the emergence of cloud services. Keep that in mind when searching for the right MySQL admin tool.

Most relational databases, with the notable exception of MS Access, are comprised of two distinct components: the back-end, where the data is warehoused, and the front-end, a user interface for communicating with the data component. This type of design is quite clever, as it parallels the two tier programming model that separates the data layer from the user interface and allows the makers of the database software to focus on their product's strongest suit: data storage and management. It also opens the door for third parties to create rich applications to interact with various databases. Such products include Embarkedaro Rapid SQL and Oracle SQL Developer. Here are ten outstanding graphical interfaces for MySQL..."
(Get More Information . .) open to premium members only

04 May 2015 Oracle Updates Development Tools for Public Cloud Services [42402]
by Jeff Smith

Laura Ramsey writes, "the Oracle Database Application Development Tools team released two important updates to the development tools line up. This guest post from Jeff Smith, Senior Principal Product Manager at Oracle, provides the full story..."

Jeff Smith writes, "Oracle SQL Developer version 4.1 and Oracle SQL Developer Data Modeler 4.1 are now generally available. The two products empower customers to design, develop, and deploy best-of-breed applications running on-premises or in Oracle Database Cloud Services..."

'We are very pleased with the strong adoption of Oracle SQL Developer,' said Michael J. Hichwa, Vice President of Oracle Database Tools.
(Get More Information . .) open to premium members only

04 May 2015 SQL Developer 4.1 - Oracle REST Data Services 3.0 [42410]
By Laura Ramsey

Laura Ramsey writes, "Oracle SQL Developer 4.1 and SQL Developer Data Modeler 4.1 let customers design, develop, and deploy applications running on premises or in Oracle Database Cloud Services. And SQL Developer 4.1 sports a new interface for DBAs to observe critical metrics in real-time around IO, networking, wait events, storage, and more.

And here's how SQL Developer now supports Public Cloud Services-- It has a one-button-click solution for copying on-premises Oracle Databases to the Oracle Database Cloud Service. So you just right-click on a 12c Multitenant Pluggable Database and choose to either move, or copy to the Cloud Service. When the operation is complete, the database is automatically made available in the Oracle Database Cloud Service..."
(Get More Information . .) open to premium members only

30 Dec 2014 Your Favorite Posts from 2014 [40123]
By Jeff Smith

Jeff Smith, Product Manager at Oracle for Oracle SQL Developer, writes, "We've had another great year. Multiple product updates, 127 posts, and LOTS of questions asked and answered. Since it's that time of year, here's your, 'lazy writer, popular posts' update :)

Based on overall site traffic in 2014, your favorite posts from this year are:.."

  • Introducing the Oracle Database 12c VirtualBox OTN Image
  • Migrating SQL Developer Connections with Passwords
  • Creating Schema DDL Scripts to Multiple Files
  • Exporting Multiple Blobs
  • Connecting to Oracle on VirtualBox from SQL Developer on your Windows Host
  • Ask a Question
  • SQL Developer and TNSNames
  • How to Start the Debugger
  • How to Open the Modeler in SQL Developer
  • SQL Developer and the Oracle Client

Read on for details.
(Get More Information . .) open to premium members only

 1 2 3 next

!-- end archive_section.tpl -->