ODTUG Kscope12 - Kscope12

How can you ensure users use only their data and not someone else's? How can you do this with minimal effort? How can you get rid of multiple codebases. How can you (partially) protect yourself against SQL Injection? Explore these questions and more in this informative session.

Collections (array-like structures in PL/SQL) are used in two of the most important performance features of PL/SQL: BULK COLLECT for data retrieval and FORALL for data modification. This session will cover these topics and more.

Many developers have seen how smart analytic functions are, but some of them still ask "what is it really good for?"The speaker works for a major Danish retail company where more than 1000 analytic statements have been used in the source code in the course of development over the last decade. He will show several real use cases demonstrating examples of using analytic functions for solving tasks that would be difficult without analytics. At the end of the presentation, you are likely to be smitten by the analytic bug and know how to start doing this at home. As Tom Kyte says: "Analytics Rock, Analytics Roll."

Developers need effective processes and tools to efficiently write quality PL/SQL code. Our 170 PL/SQL developers maintain and extend 12 M lines of PL/SQL code with the help of a database provisioning system that performs automated builds, executes tests, reports results, tests each code change upon check in, and gives developers their own database instance with self-service cloning and flash back from the IDE. Additionally, our installer spots a debugger with breakpoints and the option to flash back, modify, and resume installations. Code changes are branched to the right streams based on customer upgrade plans and delivered with all preconditions.

Whether you are new or a veteran user of Oracle SQL Developer and SQL Developer Data Modeler, you will want to learn about all the latest new features. SQL Developer introduces PDF support for reporting and more DBA-related functionality like Oracle Data Pump and RMAN support. SQL Developer Data Modeler is now tightly integrated with source code control, Subversion. This session will demonstrate the support for collaborative development through this Subversion integration. These and other interesting features will be demonstrated.

User experience is the focus of most developers today, and rightly so, but production software must not only meet the needs of the end users, but also meet the needs of the operations team responsible for maintaining it. This presentation will describe the successful developer's relationship with the operations team, and the steps that should be taken during the software development process to ensure optimal performance and scalability long term.

Many new large-scale data analysis tasks are being described using MapReduce as an implementation language. These descriptions imply that you need Hadoop and HDFS in order to fully exploit the power of MapReduce. However, since MapReduce simply describes implementation primitives, it is actually possible to implement those concepts using SQL and PL/SQL. Doing so will help database engineers more fully understand the underlying data processing activities behind typical large-scale data analysis tasks. In this presentation, database developers will learn about how to use parallel pipelined PL/SQL table functions to build MapReduce-like capabilities in the Oracle database.

The IT industry currently has its head "in the clouds." There are a plethora of vendors touting "cloud solutions," many of which are very expensive to use. This presentation will cover the following topics: 1) Cloud concepts 2) Technical alternatives 3) How we created a complete development environment on a cloud 4) Why we didn't use an existing cloud product

There are several alternatives for how to build systems in the "post-Forms" world. Many are using APEX or trying ADF. Others are going to .net or open source JavaEE. Some of us are wondering if a worthy replacement to Forms even exists. This presentation will be a panel of experts that have picked a technical direction and are successfully building systems. They will share their experiences and discuss their platform of choice. All of the major platforms will be represented. If you are still wondering which way to go, or are having trouble making the transition to a new platform, come to this open panel discussion to ask your questions.

The latest release of JDeveloper offers new functionality to you if you are using UML class models to model your logical database model. The DatabaseProfile allows you to dive deep into every aspect of your model and ensure you get the physical model you want. From datatypes to database types, from primitive types to primary keys: if you need a solid reusable logical model that can be transformed into multiple physical databases JDeveloper's DatabaseProfile has the answer. Come to this demo-based session to explore just how flexible it is with the Product Manager responsible for its development.

There's more to good development than code. Good application lifecycle management (ALM) is paramount to producing good applications. Join this session to see how Hudson CI can help you to excel! Whether it's SCM, task management, build, deploy, testing, coding standards or more Hudson's got it covered. In this session you will see how using Hudson improves code, bug handling, feedback and much more whether you are developing in the database, ADF or SOA components in fact, any type of development!

Software managers are very good at putting pressure on developers to "get the job done" as quickly as possible, so as to meet usually unrealistic deadlines. The end result? Applications that require lots of resources simply to fix those bugs and maintain the code. If we are going to build and deploy successful applications, we have to think not only about getting that application in production today, but also the cost of keeping it in production for years to come. This session offers a range of tips and techniques to improve the readability of your code and make it easier to maintain/evolve that code over time.

Consistent, robust error management is a critical feature of any successful application. Oracle offers a number of very helpful features, ranging from built-in functions like DBMS_SQL.FORMAT_ERROR_BACKTRACE to DML clauses, that will make it easier to identify the sources of problems and fix them more rapidly, as well as meet different business requirements.

Users hate to wait - for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable, they must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

In this session you will learn how to develop plugins for Oracle EM 12c Cloud Control to monitor targets that Oracle EM doesn't support natively like third-party software products, hardware components, and even your own applications. 12c Cloud Control has introduced a lot of enhancements in the area of Extensibility—now a plugin developer can create fully functional extensions and not just simple monitoring plugins. On the example of MySQL plugin, you will learn how to define your own targets, collect metric and reports, define new job types, gather configuration information, and create compliance standards. We will also introduce more advanced area such as customizing user interface and targets auto-discovery. We will learn different collection techniques including SQL, HTTP, Web Services, and others.

This presentation provides an architectural overview of Oracle Real Application Clusters explaining fundamentals of Oracle RAC and various components of Oracle RAC deployments. Rather than focusing on development best practices for Oracle RAC, understanding the key concepts will allow developers to leverage Oracle RAC to the full extent making it a breeze to deploy applications in scalable and highly available fashion. In addition, the attendees will take home several practical guidelines on developing applications that work efficiently with Oracle RAC.

This presentation provides an architectural overview of Oracle Real Application Clusters explaining fundamentals of Oracle RAC and various components of Oracle RAC deployments. Rather than focusing on development best practices for Oracle RAC, understanding the key concepts will allow developers to leverage Oracle RAC to the full extent making it a breeze to deploy applications in scalable and highly available fashion. In addition, the attendees will take home several practical guidelines on developing applications that work efficiently with Oracle RAC.

SQL Developer Data Modeler (SDDM) is a full-function data modeling tool provided for FREE by Oracle. It has many features built in that can be leveraged to capture the design of an existing database, retrofit it to a logical model, re-engineer it to multiple models (including multi-dimensional), and even apply standards, then generate revised DDL to implement your newly standardized design. The presentation will provide step-by-step instructions on how to do all this so you can go back to the office and quickly create diagrams of all your existing databases (Oracle and non-Oracle!).

This beginner-level session will introduce Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by-step demos will be used to illustrate how to get started developing Oracle Database .NET applications using each of these free products. New and upcoming features will also be described briefly in this session, including Entity Framework, LINQ, WCF Data Services, 100 percent managed Thin ODP.NET, and support for TimesTen.

Oracle Forms 11gR2 is the latest incarnation of this venerable tool. Released in September 2011, there are several interesting features to modernize existing forms applications or to manage the forms environment. Features to be discussed include: easier installation, smaller install footprint, Oracle Access Manager support, performance and network statistics, support for 64-bit Windows, use of Oracle Fusion Middleware Real User Experience Interaction for non-intrusive monitoring, Forms Window object maximization, use of dynamic URLs for iconic buttons or READ_IMAGE_FILE, ability to turn off the Forms Menu Bar and window decorations, and other miscellaneous features.

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers.

SQL is an extremely powerful language these days. It offers set-based processing, iteration, and recursion. In short, it has many of the qualities of a procedural language and a declarative language. This session explores five things you probably didn't know about SQL.

PL/SQL turns twenty-three years old this year--it was first introduced in 1988 with Oracle6 Database. This session looks at five technical things about PL/SQL you probably did not know: under-the-covers features that make PL/SQL quite simply the most efficient language with which to process data in the database.

In this session, you'll learn why it's important to regard performance as a feature in its own right (instead of merely an attribute of other features). You'll learn how to add instrumentation to your Java or PL/SQL code that will make your applications easy to optimize in development and easy to diagnose in production.

Dynamic SQL is one of the most critical tools in the developer's toolbox. It empowers well-written systems to rapidly realign with the real world. In addition to the core elements required to properly utilize Dynamic SQL, this presentation focuses on effective and appropriate usage of all 11g additions to the PL/SQL language (in conjunction with other advanced features such as object types, collections, large objects, etc). Real-life examples are used as illustrations for all key points.

Identifying guideline violations in early development stages reduces development times and costs. Using such techniques in database-centric architectures is not common, so standard tooling is currently missing or insufficiently configurable for specific customer guidelines. Trivadis used Eclipse Xtext to define the PL/SQL grammar of Oracle Database 11g Release 2 to check the compliance with the Trivadis SQL and PL/SQL guidelines. The chosen solution is suited for various purposes such as dependency analysis beyond querying the Oracle data dictionary. This session presents the approach with the help of real-life examples.

You use the GUI because you want to be productive, right? Do you ever get the feeling you're only really using a small fraction of what the database and SQL Developer have to offer? If so, then you've come to the right place. Stock up on tips guaranteed to save you time, and make your experience with your code and the database much more enjoyable. If you ever write SQL or PL/SQL, then this presentation is for you.

Do you need to know exactly what is being executed when your application runs and do you need to debug it while the application is running? Or do you need to debug batch jobs that can't be called from the command line due to complex setup scenarios? Throw out your DBMS_OUTPUT and use SQL Developer's remote debugging facility.

A short examination of Oracle's date/time datatypes and best practices for manipulating them in SQL and PL/SQL.

What are you supposed to do with the fifteen plus years of investment you have in Oracle Forms? Just throw it away? Let it stagnate? Or are there other options? This session will discuss the game plan for Forms users to move into new platforms with existing systems. Topics include: upgrading to Forms 11g (including new features demo), developing and integrating with ADF/APEX, and how to exploit Oracle Forms business logic in new channels. The session will then go one step further by demonstrating an ADF data control to run Oracle Forms business logic silently from an ADF faces UI and an ADF mobile application.

Think migration is the only way to get modern, sleek looking web applications? Do we really need a new technology to have good looking Forms systems? This session will give practical tips and tricks on how to modernize the look of your applications WITHOUT migration! The session will show how Forms can be transformed using only design techniques, incorporating Java elements, and integrating with ADF technology. The session will also show a live demo of taking a tired old Forms system and bringing it into the 21st century.