Kscope12 Presentations

Check out the presentations listed below.



Should Invoker Rights Be Used?
Patrick Barel, AMIS Services
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Can Collections Speed Up Your PL/SQL?
Patrick Barel, AMIS Services
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Real Cases of Indispensability of Analytic Functions
Kim Berg-Hansen, T. Hansen Gruppen A/S
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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."

Back to Top
Tools & Processes for Efficient Development of High Quality PL/SQL in the Large
Martin Buechi, Avaloq
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Oracle SQL Developer and Data Modeler New Features
Ashley Chen, Oracle Corporation
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Performance Practices of the Successful Developer: Making Friends with Your DBA
Ron Crisco, Method R Corporation
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Implementing MapReduce Algorithms in SQL and PL/SQL
Dominic Delmolino, Agilex Technologies
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Do-It-Yourself Cloud Computing
Paul Dorsey, Dulcian
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Developers Toolbox - Subtopic: Coding

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

Back to Top
Where Do We Go Post Forms? Panel
Paul Dorsey, Dulcian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Deep Dive into Logical and Physical Modeling with JDeveloper
Susan Duncan, Oracle Corporation
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Continuous Integration: Put It at the Heart of Your Development
Susan Duncan, Oracle Corporation
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Developers Toolbox - Subtopic: Tools

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!

Back to Top
Writing Maintainable PL/SQL Code
Steven Feuerstein, Quest Software
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Error Management Features of Oracle PL/SQL
Steven Feuerstein, Quest Software
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
High Performance PL/SQL
Steven Feuerstein, Quest Software
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Developing Plugins for Oracle EM 12c Cloud Control
Alex Gorbachev, Pythian
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Introducing Oracle RAC to Developers
Alex Gorbachev, Pythian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Introducing Oracle RAC to Developers
Alex Gorbachev, Pythian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Reverse Engineering (and Re-engineer) an Existing Database Using Oracle SQL Developer Data Modeler
Kent Graziano, Data Warrior
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Developers Toolbox - Subtopic: Tools

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!).

Back to Top
Getting Started with Oracle and .NET
Alex Keh, Oracle Corporation
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
What's Old is New Again: Oracle Forms 11gR2 New Features
John King, King Training Resources
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Oracle 11g for Developers: What You Need to Know
John King, King Training Resources
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Five Things You Probably Didn't Know About SQL
Tom Kyte, Oracle Corporation
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Five Things You Probably Didn't Know About PL/SQL
Tom Kyte, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Instrumentation: Why You Should Care
Cary Millsap, Method R Corporation
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Dynamic SQL in the 11g World
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Modern PL/SQL Code Checking and Dependency Analysis
Philipp Salvisberg, Trivadis AG
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Developers Toolbox - Subtopic: Coding

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.

Back to Top
Forms 11g, ADF and APEX: Co-existence in Enterprise Applications
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

For some time now, Oracle Forms has addressed all the needs for database development. The next challenge is taking advantage of the newest features in Forms 11g and integrating enterprise Forms applications with other modern technologies, like ADF and APEX. We will present and exemplify live our first-hand experience of migrating large, enterprise Oracle Forms applications to Forms 11g, ADF and APEX. The demonstration will not only take into consideration the web layout redesign, but will also offer solutions for dealing with true challenges like: how to assess the amount of work, how to re-use components and preserve the investment in Oracle Forms, how to ensure a smooth coexistence of Forms 11g, ADF and APEX. Come and join us in discussing the lessons we have learnt from our latest migration projects, the dos and don’ts and much more.

Back to Top
SQL Developer Tips and Tricks
Jeff Smith, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Debugging PL/SQL With SQL Developer
Jeff Smith, Oracle Corporation
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
An Oracle Geek's Guide to Successful Dating
Sean Stuber, American Electric Power
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

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

Back to Top
Survival of the Fittest: How to Evolve Your Existing Oracle Forms Applications to the 21st Century
Mia Urman, OraPlayer
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top
Oracle Forms Extreme Makeover - Tips and Tricks for Oracle Forms GUI Modernization
Mia Urman, OraPlayer
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Developers Toolbox - Subtopic: Tools

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.

Back to Top

Enter your e-mail to be added to our database so you will not miss any deadlines.


From Twitter

    Sorry, this stream was unable to get updates. Please check settings or wait for the service to return.