A Gentle Introduction to Polymorphic Table Functions (Connect 2019)

Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when to use which technique.

Get your money’s worth out of your Database (Connect 2019)

The database is one of the most important assets to your application. Besides being one of the most important assets it is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data. Features you can use ‘in the database’ include:
– Flashback queries (what did my data look like at a certain moment in time)
– Data Security (only read and write data you are authorized for)
– Performance increase (Set based operations, regular expressions, analytics)
– EBR (near zero downtime application upgrades or support for parallel database worlds)
– Data integrity/quality (Single Point Of Data Integrity)
– Special SQL features like paginating your result.
This presentation will show these features as well as some of the enhancements in the Oracle 12c Database including:
– Identity columns (12c)
– Invisible columns (12c)
– Whitelisting PL/SQL program units (12c)
– Improvement of execution of PL/SQL in a SQL query (12c)
– Cross session Result cache (both SQL and PL/SQL) (11g)

The Case for Cloud: Developing a business case moving from on-premise to Cloud (Connect 2019)

This session is for customers currently using Oracle on-premise applications and who are interested in moving to Cloud but are unsure when. The session will talk about the reasons why now is the time to move to cloud. We will look at the capabilities, benefits and cost efficiencies that can be achieved by moving to Cloud with case studies on existing local customers who have made the move, and finally provide guidance on how best to put together a business case.

Developing Node.js Applications for Oracle Database (Connect 2019)

Middle tier Node.js applications are powering high performance Oracle applications around the world with Oracle’s popular node-oracledb module. See how easy it is to access your PL/SQL business logic. Learn best practices in connection management, data handling, bulk data loading, LOB management and more. See relational and Oracle’s document storage APIs in action. Learn how node-oracledb and Oracle Database features improve scalability and high availability. This talk is full of tips and techniques for making the most out of node-oracledb.

Effective and Efficient Python with Oracle Database (Connect 2019)

Python is rapidly becoming a de facto language for big and small database applications. Learn the best techniques for using Oracle’s cx_Oracle DBI-compliant Python API and its advanced, Oracle-specific features. Whether you are creating microservices, or writing management and monitoring scripts, cx_Oracle’s traditional relational data access and new document store interfaces are easy and powerful to use. This session dives into making the most of cx_Oracle, from best practice configuration for high availability, through to using the latest cx_Oracle features.

APEX for Forms Developers (Connect 2019)

After spending about seven years as an Oracle Forms developer, I successfully transitioned to Oracle APEX, and I find myself a very happy camper. After spending time in the chat thread during the Ask TOM Office Hours session on Oracle Forms modernization, I felt like I had a duty to help existing Forms developers take hold of our modern development environment.

This session will cover the important considerations to transform your skills as an Oracle Forms developer to Oracle APEX. You might be surprised by just how much overlap there is.

SQL Gone Wild! – Taming and Tuning the Optimizer (Connect 2019)

The root cause of most database performance issues is bad or sub-optimal SQL execution plans. This session not only covers optimizer internals and new optimizer features introduced in versions 12c, 18c and 19c but also outlines a practical approach to SQL optimization, identification, and elimination of SQL performance issues by ensuring SQL Plan stability as well as influencing the Oracle optimizer via the use of appropriate hints.

Accelerate migration to Oracle Cloud Infrastructure with minimal downtime (Connect 2019)

This session provides insight into migration methodologies to enable organizations to rapidly and seamlessly adopt cloud infrastructure and services migrating data with minimal outages and disruption to the business. Attendees will learn how to use techniques like Oracle GoldenGate Cloud Service and Oracle Data Guard for rapid cloud on-boarding and on-premise data migration with almost zero downtime.

Every APEX developer should be a plugin developer (Connect 2019)

Every professional seeks to improve their craft by learning all the capabilities of their tools. One of the most useful features of Oracle Application Express is its Plugin system, yet many developers still rarely use it.
Whether it’s installing and extending third-party plugins, or creating your own, you can strategically add capabilities to your applications, standardise your user interfaces, and improve code re-use within your organisation. A lot of the time the hard work may have already been done; you could just convert what you have into a plugin.
This talk will include a demonstration of developing of a new plugin from scratch.