Patrick Barel
Qualogy
Actions
Patrick Barel is a PL/SQL Developer for Qualogy [http://www.qualogy.com/] in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins [http://plugins.bar-solutions.com/] for PL/SQL Developer [http://www.allroundautomations.com/]. He publishes articles on his own blog [http://blog.bar-solutions.com/].
In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.
In 2019 he was promoted to Oracle ACE Director [https://apexapps.oracle.com/pls/apex/f?p=119297:3:::::SEARCH:Patrick%20Barel]
In 2023 he published his first book: Modern Oracle Database Programming [https://www.amazon.com/Modern-Oracle-Database-Programming-Powerful/dp/1484291654]
How to use a relational database for your JSON documents
This presentation gives you an introduction of some of the JSON features in Oracle Database 23ai. How can you unlock your relational data in JSON format and how can best and easiest store your JSON documents in Oracle Database 23ai. - We will demonstrate the JSON Relational Duality Views, a new killer feature of Oracle Database 23ai - We will also demonstratie how you can import JSON into the database - We will even show you how to have Oracle write the JRDV for us. If you like JSON, SQL and Formula 1, then this is the session for you.
Get to Know Your Program by Instrumentation
When we create our programs, we usually don’t anticipate anything will go wrong. And it won’t during development and testing. But in production, there is always someone who does something unexpected, and then the code fails. When running in development, you can easily step through your code and see what happens, but in production you are not allowed to do this. How great would it be if you could see what was happening in the production environment? But logging every step takes up a lot of the performance. Installing debuggable code in production just to see what’s going on is usually a no-go. By instrumenting your code, you can get the information you need by “flipping a switch.” This session shows how you can use the (extended) Open Source Logger framework to accomplish this.
Game, Set, and Match
The tagline of the Game of Set is: The Family Game of Visual Perception. It is a game of finding matching cards in a selected group of cards. Being a SQL guy, I read this as: SET: The GAME of MATCHing cards. In any database we can select SETs using MATCHing criteria. Where is the GAME? Well, for me, it is a game of trying to solve this puzzle using SQL.
You will see how you can use the different SET operators in Oracle, how you can use JOINs to create a SET of cards, from which you can SELECT a puzzle and also find the SETs in that puzzle.
A Collection's a Collection, no matter how small
Oracle Database provides us with collections since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.
This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.
Get your money's worth out of your Database
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) - 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 19c 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) - Polymorphic Table Functions (18c) - SQL Macros (19c)
Oracle Database 26ai - What's new
A presentation (mostly live demos) of some of the new features available in Oracle Database 26ai.
Learn about features like:
- Boolean datatype
- Group by Alias
- Developer role
- SQL Domains
- JSON Relational Duality Views
... and more..
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top