1 / 24

What’s new in Oracle SQL Developer

What’s new in Oracle SQL Developer. Rick Greenwald Director, Product Management, Database Cloud Service. Program Agenda. A brief history of SQL Developer Overview of new features.

dani
Download Presentation

What’s new in Oracle SQL Developer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s new in Oracle SQL Developer Rick GreenwaldDirector, Product Management, Database Cloud Service

  2. Program Agenda • A brief history of SQL Developer • Overview of new features

  3. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  4. Graphic Section Divider

  5. A brief history of SQL Developer

  6. Oracle SQL Developer Overview Database IDE 2,500,000+ users worldwide Windows, OS X, *NIX Administer APEX Listener Deploy to Oracle Cloud

  7. SQL Developer Release History Project Raptor (2005) ~ Oracle SQL Developer v1.0 (2006) Version 1.5 (2008) Version 2.1 (2009) Version 3.0 (2011) Version 3.1, 3.2 (2012) Version 4.0 Summer 2013

  8. Support for Other Oracle Database Products Times Ten Data Miner XML DB Spatial & Graph

  9. SQL Developer Data Modeling Strategy and Analysis Import Models Data Type Domains DFD ERD Multidimensional Logical Reporting Database Design Physical Star Schema Relational

  10. What’s new in SQL Developer 4.0?

  11. What’s New? Pretty Much Everything 

  12. Under The Covers • Now Requires Java 7 JDK • Now Supports Subversion 1.7 • Smaller Memory Footprint, faster load times • Better Command Line Interface

  13. New & Improved: #1 Find DB Object Search 1 or more Schemas Search 1 or more Categories Standard Editor for Results full screen, easier browsing pin results for later

  14. New & Improved: #2 Database Cart • Multiple Carts • Before & After Object Scripting • Before & After INSERT Scripting • Compare Cart w/DB or Carts • Invoke DB Copy based on Cart • Command Line Interface

  15. Editor loads faster See Report as You Design It New chart options Command Line Run -> HTML New & Improved: #3 Reports

  16. Reports + Command Line Interface = HTML

  17. New & Improved: #4 Look & Feel • Float & Clone Object Editors! • Editor tabs can be reordered • ‘Cleaner’ window rendering

  18. New & Improved: #5Assorted Semantic Analysis Info Tips • ‘Explode’ * to column names • Auto-add GROUP BY clauses • Find missing statement delimiters • Yes, you CAN disable these 

  19. New & Improved: #5Assorted Temporal Data Type Editors • Calendar pickers • dates • timestamps • intervals

  20. And much, much more! • Tons of productivity enhancements • 2 Top #10 Exchange Features implemented • color coded connections • GIT • Many hundreds of bug fixes • Ready to rock and roll with Oracle Database 12c

  21. SQL Developer Resources OTN – SQL Developer • Forums • By Example Tutorials • Jeff Smith’sTips & Tricks Blog Download the Developer Days VirtualBox Image! 11gR2, SQLDEV, APEX, APEX Listener, Times10, OEM and more!

More Related