1 Copyright 2013 Oracle andor its affiliates All

1 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

What’s New in Oracle SQL Developer Jeff Smith Senior Principal Product Manager jeff. d. smith@oracle. com @thatjeffsmith

Legal 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. 3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Agenda § Product History § SQL Developer New Features § Question/Answer 4 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Oracle SQL Developer Overview § Database IDE § 3, 500, 000+ users worldwide § Windows, OS X, *NIX § Third Party DB Migrations § Administer APEX Listener 5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer Release History § Version 1. 1 – 2006 § Version 1. 2 - 2007 § Version 1. 5 - 2008 § Version 2. 1 - 2009 § Version 3. 0 - 2011 § Version 3. 1/3. 2 - 2012 § Version 3. 2. 2 - 2012 § Version 4. 0 2013 - GA 6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Support for Other Oracle Database Products §Times Ten §Data Miner §XML DB §Spatial & Graph 7 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer Data Modeling Strategy and Analysis Import Models Data Type Domains DFD ERD Logical Multidimensional Reporting Database Design Relational 8 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Star Schema Physical Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer Release 4. 0 9 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

What’s New? 10 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Under The Covers § Smaller Memory Footprint, faster load times § Now Requires Java 7 JDK § Supports Subversion 1. 7 § Better Command Line Interface § Central Framework - SDCLI § Stores all Feature Commands 11 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Look & Feel § Float & Clone Object Editors § Editor tabs can be reordered § ‘Cleaner’ window rendering 12 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Configurable Connection Tree Nodes (hide stuff) § less scrolling, searching § all connections (for now) 13 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Find DB Object § Search multiple Schemas § Search multiple Object Types § Standard Editor for Results § full screen, easier browsing § pin results for later § Trick: Auto-invoke search on selected text in editor with ‘Alt+G’ 14 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

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 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Reports § Editor loads faster § See Report as You Design It § New chart options § Command Line Run -> HTML 16 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Reports + Command Line Interface = HTML 17 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Worksheet Semantic Analysis Info Tips § ‘Explode’ * to column names § Auto-add GROUP BY clauses § Find missing statement delimiters § Yes, you CAN disable these! 18 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Temporal Data Type Editors Calendar pickers § dates § timestamps § intervals 19 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Clickable Error Messages 20 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Explain Plan & Autotrace Cached Plans vs Explains 21 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Procedure Editor Navigation Aids § Package Member Toggles § ‘Breadcrumbs’ 22 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Database Performance § Enhanced Database Performance Monitoring § Snapshots § Baselines and Templates § Automatic Database Diagnostic Monitoring (ADDM) § ASH Report Viewer § AWR Report Viewer § Range, Diff, SQL Viewer § Diagnostic Pack License 23 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer RESTful Services Admin § UI to manage RESTful Services § Restful Service Definitions § Example: www. example. com/employees/<Resource Handler> § Resource Handlers §HTTP Methods: GET, POST, PUT, DELETE § REST SQL Worksheet §Tune and Test Query or your PL/SQL *8890 Creating RESTful APIs with Application Express Listener – Wed 10: 15 – Golden Gate C 2* 24 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

RESTful Services Administration *10031 HOL: Developing REST for On-Premises or the Cloud – Wed 5 pm – Salon 3 and 4* 25 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

And much, much more! § Tons of productivity enhancements § 2 Top #10 Exchange Features implemented § Color coded connections § GIT § Many hundreds of bug fixes § Oracle Database 12 c Support available in version 3. 2 26 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Multitenant in SQL Developer Plug, Clone, Alter State, and more § Container Database management § Accessed via the DBA panel § Available in version 3. 2. 20. 09 and higher 27 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Translation Framework Run your non-Oracle apps against Oracle translate SQL on-the-fly § SQL Translation Framework – SQL Translation Profile – collection of translated statements § Each application can have its own profile – SQL Translator – java engine that translates the SQL § SQL Developer can install Sybase & SQL Server translators § SQL Translation Framework Benefits – Test and Verify application code before production – Helps define Task List of modifying the application code – Convert Applications To Oracle Quicker – Temporary Step before migrating application fully 28 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Database Redaction in Oracle SQL Developer § Oracle Data Redaction, a part of Oracle Advanced Security, enables you to mask (redact) data that is queried by lowprivileged users or applications. The redaction occurs in real time when users query the data. 29 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Creating a Redaction Policy *8891 SQL Developer and Oracle Database 12 c - Tues 12 pm – Golden Gate B* 30 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Brand New Today! 31 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Design Redaction into the Model Data Modeler Release 4. 0 § Redaction Policy § Full, Partial, Random, Regular Expressions § Define Redaction at Table and Column Level § Data Masking Templates § Transparent Sensitive Data Protection (TSDP) Policy §Support for 11 g and 12 c Models 32 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Generate DDL *8893 Implementing Data Redaction with Data Modeler - Wed 11: 45 pm – Golden Gate C 2* 33 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

New Features in Data Model 4. 0 § Support for JDK 1. 7 § Faster and Cleaner UI § Code folding in DDL Preview § Float your Diagrams § Comment-only displays § Multiple Classification Types 34 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Properties at Design Level § Set Properties at Design Level § Classification Types § Format Colors, Fonts, Line Widths § DDL Migration - Name Substitutions § Naming Standards § Increased Flexibility! 35 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Classification Type Options § Classification Type for a Table § Fact, Dimension, Temporary, Summary, Logging § Add new Types § Assign a Type to Many Tables § Customize Color § Display Classification Name on Diagram § Assign multiple Types to a Table 36 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Comments Only 37 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Diagram, PDF Printing Enhancements 38 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

SQL Developer Resources § SQL Developer on OTN – www. oracle. com/sqldeveloper § Feature Exchange – sqldeveloper. oracle. com § Forums – https: //forums. oracle. com/forums/forum. jspa? forum. ID=260 § Oracle Learning Library – www. oracle. com/oll 39 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

Graphic Section Divider 40 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template