Skip to Main Content

Office Hours - Past Sessions

Archive

If you weren't able to attend an Office Hours session live, you can still learn from the presentations and Q&A by watching a replay of the session.

Report Settings

  • IS_PUBLIC_CLASS = 'N'
DateSessionFocusDescription
September 19, 2022Excel Interfaces for REST ServicesExcel Interfaces for REST ServicesLearn about Visual Builder add-in for Excel and how it can help you interact with REST based backend from the familiar excel interfaces.

00:53 - Intro
02:05 - Excel Add-in main page
02:25 - Overview
03:35 - Download installer
04:40 - Install
05:15 - Update
06:00 - Remove add-in
07:05 - Connect to a Visual Builder Business Object
09:10 - Modify Excel table columns
09:55 - Admin columns
10:20 - Add query criteria
11:45 - Publish spreadsheet for users
12:20 - Open the published spreadsheet
12:50 - Insert / Update / Delete Data
14:55 - Upload changes
15:55 - Error handling
17:10 - The reason the email couldn't be set to Null is the field property "Omit from payload if value is empty" was on
18:00 - Form over table (Parent child) layout
18:15 - Add a new catalog
19:50 - Enable child relationship
20:05 - Refresh catalog after change
21:05 - 'Contains' query criteria
21:10 - Add an LOV
24:10 - Enforce business rules on the backend
27:10 - Use ORDS for the backend
28:10 - Open API specification
29:00 - Change authentication method
30:40 - Alter column type
31:50 - Re-download the data to remove pending changes
32:50 - Authentication methods overview
33:25 - End of demo - Recap
34:00 - Additional resources
34:35 - Join us at Cloud World

E. Alex Davis, Senior Director, Software Engineering
Blaine Carter, Developer Advocate for Open Source
Shay Shmeltzer, Director of Product Management
September 15, 2022Should Oracle change some of the default settings on the database?Should Oracle change some of the default settings on the database?Practical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session we talked about:

- Standby database and how undo_retention settings relate to it
- Idiosyncrasies with how DDL tracking is done in USER_OBJECTS
- How to access and process the alert log on cloud databases
- Why doesn't Oracle just change database defaults as times change?

Connor McDonald, Developer Advocate
August 30, 2022Introducing Oracle Machine Learning for R for Oracle Autonomous DatabaseIntroducing Oracle Machine Learning for R for Oracle Autonomous DatabaseJoin us to learn about Oracle Machine Learning for R (OML4R) for Oracle Autonomous Database. OML4R leverages the database as a high-performance computing environment to explore, transform, and analyze data faster and at scale, while allowing the use of familiar R syntax and semantics. The in-database parallelized machine learning algorithms are exposed through a well-integrated R interface. Further, data scientists and other R users can store and manage user-defined R functions as well as R objects directly in the database – as opposed to being managed in flat files. These features facilitate collaboration across the data science team by enabling convenient hand-off of data science work products from data scientists to application developers for immediate deployment. Run user-defined R functions in database-spawned and managed R engines, with system-supported data-parallel and task-parallel options. This session includes a demonstration through OML Notebooks.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
August 25, 2022Preguntas Frecuentes sobre Oracle APEXPreguntas Frecuentes sobre Oracle APEXEn esta sesión, resolvimos preguntas frecuentes sobre Oracle APEX y también preguntas que quedaron pendientes de sesiones pasadas.

2:00 - ¿Qué es Oracle APEX?
3:37 - ¿Dónde esta APEX disponible?
5:08 - ¿Cuáles son las diferencias cuando se trabaja On-premises vs Cloud?
7:09 - ¿Cuál es el costo de licenciamiento de APEX?
8:05 - ¿Quién puede usar APEX?
8:39 - ¿Cuáles son los conocimientos requeridos?
9:58 - ¿Cómo puedo editar una página de APEX?
11:11 - ¿Cómo crear validaciones y procesos?
24:38 - ¿Cómo personalizar la aplicación?
31:09 - ¿Cómo funciona PWA en APEX?
35:18 - ¿Qué tipos de URLs están disponibles en APEX?
37:43 - ¿Cómo trabajar con Quick Edit / Live Template Options?
43:44 - ¿Qué tipos de gráficos hay disponibles en APEX?
46:10 - ¿Cómo trabajar con llaves primarias compuestas en APEX?
51:01 - ¿Qué opciones para desplegar aplicaciones de APEX?
52:52 - ¿Puedo tener una solucion hibrida, base de datos local y APEX cloud?
53:06 - ¿Es posible conectar APEX con bases de datos no-Oracle?
54:16 - ¿Cuándo hay una versión de APEX que debo hacer?
56:45 - ¿Dónde aprender más de APEX?
57-44 - ¿Cómo conectar con otros desarrolladores de APEX?
59:37 - Q&A

Mónica Godoy, Principal Product Manager
August 24, 2022Multi-Cloud Security - Oracle Database and Azure Active Directory integrationMulti-Cloud Security - Oracle Database and Azure Active Directory integrationJoin us for an encore presentation as Alan Williams, Senior Principal Product Manager, discusses the new multi-cloud integration between Oracle Databases and Azure Active Directory (AD). In this session, Alan will cover the benefits of multi-cloud identity integration, the architecture and how to configure it in Oracle Autonomous Database (ADB-S). Alan will take you step-by-step through the configuration and usage of our new capability.

This event is an encore presentation. Ask Tom Database Security Office Hours takes place on the Second Wednesday of each month at 10:00 US/Central. You can subscribe to receive notifications of upcoming events and please review our back catalog with several years of presentations.

Alan Williams, Database Security Product Manager
Richard C Evans, Product Manager, Database Security
August 18, 2022How big can a database be? And your other questions answeredHow big can a database be? And your other questions answeredPractical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session we talked about:

- How to turbo boost your partition maintenance speed
- Just how big can an Oracle database be?
- PIVOT/UNPIVOT internals
- How to compute the number of rows for each table
- The strange combination of referential and composite partitioning

Connor McDonald, Developer Advocate
August 17, 2022Use Cloud Database and On-premise tools to connect to your cloud database servicesUse Cloud Database and On-premise tools to connect to your cloud database servicesExplore the available cloud database tools and how to configure access to your cloud database services for your favorite development tools. Learn how to:

- How to find your database connect string & database host IP details
- How to securely save and use database connection details in the Cloud Vault
- How to configure and use Database Tools Connections Feature
- How to use SQL Worksheet Feature
- How to enable connectivity from your desktop to a Private Cloud Subnet
- How to connect applications and developer tools to your cloud database

Eddie Ambler, Product Manager - DBCS, ExaDB-D, ExaDB-C@C
Leo Alvarado, Product Manager, Exadata Cloud Service
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
August 16, 2022Using R to cluster data at scale in Autonomous DatabaseUsing R to cluster data at scale in Autonomous DatabaseSome of the recent images of galaxies from the James Webb telescope highlight natural clustering in the universe. It's relatively easy to see clusters in two- or even three-dimensional images, but when confronted with significantly more dimensions, having advanced clustering algorithms can mean the difference between a "pile of data" and a meaningful understanding of, for example, customer segments. In this session, we'll touch on the different in-database clustering algorithms supported by Oracle Database and demonstrate these using the soon-to-be-released R interface of Oracle Machine Learning for R on Oracle Autonomous Database. This will be a fun and entertaining session that will cater to all levels of experience in OML.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Nicholas Cusato, Solution Engineer
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
August 15, 2022Visual Builder New Features - August 2022Visual Builder New Features - August 2022Learn about the new features rolling out in the Aug/Sep versions of Oracle Visual Builder and Visual Builder Studio. We'll review the new capabilities including live demos.

Laura Akel, Senior Principal Product Strategy Manager
Murtaza Amiji, Senior Director Product Management
Shay Shmeltzer, Director of Product Management
August 11, 2022Developer Tips from the APEX Dev Team - Part IIIDeveloper Tips from the APEX Dev Team - Part IIIWe're inviting three members of the APEX dev team to share their top developer tips to help you supercharge your productivity!
Whether you are new to APEX or an experienced developer, we are sure you will learn something new that'll help you be more productive and build apps faster than ever before.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
August 10, 2022Multi-Cloud Security - Oracle Database and Azure Active Directory integrationMulti-Cloud Security - Oracle Database and Azure Active Directory integrationAzure Active Directory is the most requested Cloud Identity Provider integration from Oracle customers. Join Alan Williams, Senior Principal Product Manager, as he discusses the new multi-cloud integration between Oracle Databases and Azure Active Directory (AD).

In this session, Alan will cover the benefits of multi-cloud identity integration, the architecture and how to configure it in Oracle Autonomous Database (ADB-S). Alan will take you step-by-step through the configuration and usage of our new capability.

Join the Database Security Product Management team on the second Wednesday of every month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Alan Williams, Database Security Product Manager
Richard C Evans, Product Manager, Database Security
August 9, 2022How to perform in-database text analytics using a pre-built ML modelHow to perform in-database text analytics using a pre-built ML modelDid you know that you can perform document similarity, topic modeling, and term/document classification in-database using a pre-built machine learning model that’s based on millions of Wikipedia articles? This pre-built model was produced using the Explicit Semantic Analysis (ESA) algorithm. ESA models do not find latent features, but rather use explicit features represented in the knowledge base, which in this case is a selected set of Wikipedia articles. Preparing data and training such a model can be involved, so the model being pre-built streamlines that effort. We’ll be demonstrating using the Wikipedia model through the soon-to-be-released OML4R interface on Oracle Autonomous Database. Using OML4R, we show how to create a model proxy object for this pre-build Wiki model and use it for document similarity and document classification use cases.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Miles Novotny, Solution Engineer
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
August 3, 2022AVDF Cafe - Reference Architectures of AVDFAVDF Cafe - Reference Architectures of AVDFDear AVDF Community,

We are halfway through the year, and it is time for another AVDF Café.

As always, bring your warm beverage of choice, and while taking a sip of your favorite drink, join us on Aug 3rd’2022 to discuss various Reference Architectures of AVDF. Our topic for the second AVDF Cafe' of 2022 is different scenarios and how those reference architectures support real-world customer use cases.

Whether you are an existing AVDF customer, Oracle partner, or even someone just interested in learning more about AVDF, you are welcome to join us in the cafe.

Welcome: 00:01
Agenda: 01:57
AVDF Overview: 02:27
AVDF Components: 10:08
Reference Architectures: 18:05
Audit Vault Server Deployment Model: 18:33
Audit Vault Agent Deployment Model: 21:20
Database Firewall Deployment Model: 28:42
Summary: 40:13

Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall
Nazia Zaidi, Sr. Principal Product Manager - Oracle Audit Vault and Database Firewall (AVDF)
Richard C Evans, Product Manager, Database Security
August 2, 2022AVDF Cafe - Reference Architectures of AVDFAVDF Cafe - Reference Architectures of AVDFDear AVDF Community,

We are halfway through the year, and it is time for another AVDF Café.

As always, bring your warm beverage of choice, and while taking a sip of your favorite drink, join us on Aug 2nd’2022 to discuss various Reference Architectures of AVDF. Our topic for the second AVDF Cafe' of 2022 is different scenarios and how those reference architectures support real-world customer use cases.

Whether you are an existing AVDF customer, Oracle partner, or even someone just interested in learning more about AVDF, you are welcome to join us in the cafe.

Welcome: 00:01
Agenda: 01:57
AVDF Overview: 02:27
AVDF Components: 10:08
Reference Architectures: 18:05
Audit Vault Server Deployment Model: 18:33
Audit Vault Agent Deployment Model: 21:20
Database Firewall Deployment Model: 28:42
Summary: 40:13

Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall
Nazia Zaidi, Sr. Principal Product Manager - Oracle Audit Vault and Database Firewall (AVDF)
Pedro Lopes, Sr. Principal EMEA Field PM
July 28, 2022APEX 22.1, ORDS and the MySQL Database ServiceAPEX 22.1, ORDS and the MySQL Database ServiceAPEX 22.1 is the first APEX release that supports building Applications directly based on the MySQL Database Service in Oracle Cloud Infrastructure. Leveraging ORDS "REST Enabled SQL" functionality, APEX components can visualize data directly from the MySQL database.

In this Office Hours session, Carsten Czarski showed how to set up a connection to a MySQL Database Service within APEX and how to build an application, using tables, views or SQL Queries being executed in the MySQL database. Learn how to create a Catalog of REST Data Sources, each executing a SQL Query in the MySQL Database Service and how to synchronize data to the APEX schema.

How to set up a MySQL Connection in OCI by Peter O'Briens:
https://peterobrien.blog/2022/06/20/how-to-use-the-oracle-database-tools-service-to-provide-mysql-data-to-apex/

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
July 20, 2022Automate and codify your Exadata Database Service deployments using OCI Resource Manager and TerraformAutomate and codify your Exadata Database Service deployments using OCI Resource Manager and TerraformAs the infrastructure grows in scale and complexity, it becomes evident that it would be better to manage it programmatically. Using Terraform, OCI Resource Manager helps you install, configure, and manage resources through the "infrastructure-as-code" model.
Leverage Exadata Database Service, OCI Resource Manager & Terraform to quickly produce standardized DEVOPS environments for your development lifecycle.
Join the live discussion covering these learning points:
- Explore and Learn how to Automate and codify your Exadata Database Service deployments using OCI -Resource Manager and Terraform
- Conduct Discovery and Generate a baseline Terraform config for your Exadata Database Service deployments utilizing Resource Manager
- Move from Manually managed infrastructure to Resource Manager-controlled infrastructure
- Duplicate or rebuild existing Exadata Database Service Infrastructure deployments
- How to use Configuration Source Providers (GitHub and Gitlab) to enable automation
Join us to learn about Exadata Database Services and Base Database Service in OCI. AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Eddie Ambler, Product Manager - DBCS, ExaDB-D, ExaDB-C@C
Leo Alvarado, Product Manager, Exadata Cloud Service
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
July 20, 2022Is CURSOR_SHARING broken? and your other questions answeredIs CURSOR_SHARING broken? and your other questions answeredPractical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session we talked about:

- Reporting with SQL Developer
- Using the WITH statement with DML
- LPAD/RPAD issues with PL/SQL
- The strange CHECK syntax that is not document
- Consolidating your connection pools
- CURSOR_SHARING might not fix ALL of your SQL

Connor McDonald, Developer Advocate
July 19, 2022How to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle DatabaseHow to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle DatabaseOften when loading data you want to add new rows and change the existing ones. So you need "update if exists, insert if not exists" logic, aka UPSERT. This can lead to complex statements and conditional logic.

The MERGE statement enables you to do both actions in one SQL statement.

This session covered the details of how this works. Highlights include:

05:15 - Overview of MERGE syntax
10:10 - Merging bind variable values
12:30 - Demo of MERGE
21:40 - Getting the INSERT vs UPDATE split for merged rows
22:30 - Using triggers to record INSERT vs UPDATE
25:00 - INSERT vs UPDATE count Flashback versions query
27:10 - INSERT vs UPDATE count with SQL Monitoring
33:35 - ORA-30926 unable to get a stable set of rows error
41:10 - Deleting rows in the target missing from the source
43:20 - Demo of insert vs update count, ORA-30926 error and deleting missing
52:30 - Performance of MERGE
57:50 - Demo of update only MERGE performance compared to UPDATEs
1:03:40 - Recap

Get the scripts for this session https://bit.ly/SQL-ATOH-MERGE
Improve Your SQL Skills with this FREE course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html

Chris Saxon, Oracle Developer Advocate for SQL
July 18, 2022Extending Oracle Cloud Apps with Visual BuilderExtending Oracle Cloud Apps with Visual BuilderLearn how Visual Builder enables Oracle Cloud Apps customers to configure and extend their applications. With the new App UI features, Oracle SaaS customers can easily create new pages and apps in that provide innovative user interfaces on top of Oracle SaaS data - learn about these new features and more.

Murtaza Amiji, Senior Director Product Management
Shay Shmeltzer, Director of Product Management
Steve Waterhouse, Sr. Principal Product Manager
July 14, 2022Como usar a API JavaScript para estender as funcionalidades do APEXComo usar a API JavaScript para estender as funcionalidades do APEXA API JavaScript do APEX é muito importante para que os desenvolvedores possam fazer uso completo do APEX de forma segura e prática. Através dela podemos fazer chamadas AJAX, criar validações em tempo de execução além de executar lógica no client side de forma criar aplicações extremamente dinâmicas.

Nesta sessão, Paulo Künzel irá destacar alguns dos métodos disponíveis no apex.server, apex.action, apex.message e apex.util que podem ajudar o desenvolvedor na hora de transformar o Front-end de suas aplicações, tornando-a fluidas e dinâmicas.

Paulo Künzel é especialista em desenvolvimento de sistemas. Tem dez anos de experiência com Front-end e há três anos desenvolve aplicações em Oracle APEX.

Karina Pastor, Principal Product Manager - Oracle APEX
Mónica Godoy, Principal Product Manager
July 13, 2022Back to the basics of DB security - Database rolesBack to the basics of DB security - Database rolesIn this month's Database Security Office Hours, we continue our Back to Basics track with a focus on Oracle Database roles. Roles are an extremely powerful tool to help manage your users, privileges, and secure access to your sensitive data. Richard C. Evans, DB Security Product Manager, will guide you from the basics of roles to advanced use cases, helping you understand how you can use password protected roles, non-default roles, and secure application roles to control which privileges are available to a database sessions. We'll cover how to create Unified Audit policies based on the use of a role, identify used and unused privileges and roles, and map roles to Active Directory groups with Oracle Centrally Managed Users (CMU).

Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.


Announcements: 1:45
Start of presentation: 5:55
Different types of roles: 16:10
Default vs non-default roles: 17:25
Password protected roles: 18:20
Global roles: 20:20
Common roles: 21:15
Using SYS_SESSION_ROLES built-in context: 24:58
Common views related to roles: 26:07
Granting roles to users: 29:12
Enabling roles: 34:00
Restrictions on roles: 35:47
Secure application roles: 37:38
Global roles with Oracle Centrally Managed Users (CMU): 40:57
Auditing roles: 44:00
Identifying users, roles, and privileges: 45:15
Closing: 51:45
Next Month: 53:30

Check out the links at https://github.com/oradbsec/AskTomDBSecurity

Hakim Loumi, Product Manager/Field Engineer - Database Security
Pedro Lopes, Sr. Principal EMEA Field PM
Richard C Evans, Product Manager, Database Security
June 30, 2022De idea a realidad: Construye una app completamente funcional en 60 minutos con Oracle APEX!De idea a realidad: Construye una app completamente funcional en 60 minutos con Oracle APEX!En esta sesión, Mónica Godoy te guía en cómo desarrollar e implementar rápida y fácilmente aplicaciones móviles utilizando Oracle APEX, la plataforma de desarrollo de aplicaciones Low Code de Oracle.

Comenzaremos con un archivo que contiene datos de carreras de F1 y la convertiremos en una aplicación donde agregaremos búsqueda por facetas, informes personalizados, tableros y más.

Archivo JSON: https://oracledevrel.slack.com/files/U0326BR02LX/F03A32J4YUR/f1-races-2022.json

Enlaces Útiles:

Sitio Oficial de APEX https://apex.oracle.com
Descargar APEX https:// apex.oracle.com/otn
Enlaces Rápidos https://apex.oracle.com/shortcuts
Comunidad https://apex.oracle.com/community
Blog https://apex.oracle.com/blog
Tutoriales https://apex.oracle.com/hols

Mónica Godoy, Principal Product Manager
June 22, 2022Heat MapHeat MapThis session explored Heat Map and how it is used with Database In-Memory and Advanced Compression. Andy Rivenes (@TheInMemoryGuy) PM for Database In-Memory and Gregg Christman (@aco_gregg) PM for Advanced Compression, reviewed the motivation for Heat Map, how it works and how it is used in Oracle Database. A demo was also given to show how access Heat Map data.

Andy Rivenes, Product Manager
Gregg Christman, DB Performance Senior Product Manager
June 21, 2022Use Case: Oracle Machine Learning in football - Expected GoalsUse Case: Oracle Machine Learning in football - Expected GoalsThanks to the partnership between the Premier League (the top tier of England's football) and Oracle we have the opportunity to experience what it is to be a football analyst and apply advanced analytics and machine learning to real match data.

In this session, you will learn about the concept of "Expected Goals" (xG) in football. Expected goals (xG) is a predictive model used to assess every goal-scoring chance and the likelihood of scoring. The xG model computes for each chance, the probability to score based on factors such as distance, the position of defenders, type and speed of pass, type of shot, shot angles, and various other aspects.

In this demonstration, you'll see how we can use Oracle Machine Learning, Autonomous Datawarehouse, and Analytics Cloud to:
- Visualize data on a football pitch
- Prepare data for machine learning
- Train the xG model
- Apply the model to recent matches to understand team and player performance.

Jeroen Kloosterman, Product Strategy Director SMB EMEA
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
June 21, 2022How to handle NULL in SQLHow to handle NULL in SQLThe NULL value represents missing or not applicable information. But using it introduces three-valued logic. This can lead to surprising outcomes when handled incorrectly.

This session covered the problems using NULL brings and how to avoid these. Highlights include:

- 00:30 - The problem with val = null
- 05:30 - Demo of problems and quirks with null
- 10:50 - Nulls in aggregate functions
- 16:30 - Nulls in check constraints
- 18:40 - Nulls in ORDER BY
- 20:50 - Why does null exist?
- 22:10 - Examples of not applicable/missing information and ways to change the schema to avoid null
- 32:40 - Handling end dates for currently active rows - null vs separate tables vs magic values
- 41:00 - The problem with magic values
- 45:00 - Situations where nulls can still appear when all columns are mandatory: outer joins, new columns, and window functions
- 47:30 - Demo of nulls in outer joins
- 48:45 - Nulls returned by window functions
- 50:00 - Mapping nulls to non-null values
- 55:40 - How to include nulls when searching for rows less than some value
- 1:00:30 - Summary

Chris Saxon, Oracle Developer Advocate for SQL
June 17, 2022Zero Data Loss Recovery Appliance - 3rd Party SEC Compliance AssessmentZero Data Loss Recovery Appliance - 3rd Party SEC Compliance AssessmentJoin us to hear the details of the Zero Data Loss Recovery Appliance (ZDLRA) compliance assessment. This 3rd party assessment covers the ability of the ZDLRA to meet SEC 17a-4(f), FINRA 4511(c), CFTC 1.31(c)-(d) and the MiFID II Delegated Regulation(72)(1). These regulations are critical for customers in financial services but may also apply to your business.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
June 16, 2022Everything an APEX Developer needs to know about ORDSEverything an APEX Developer needs to know about ORDSExactly what it sounds like. Those little voices in the back of your head whispering, "Just what is ORDS, and what am I potentially missing out on?"
This session covered just how it supports APEX and also what else it can be used for an Oracle Database user and an APEX Developer.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
That Jeff Smith, Product Manager
Mónica Godoy, Principal Product Manager
June 14, 2022Ready to 'Go' with JSON and Oracle DB!Ready to 'Go' with JSON and Oracle DB!Godror (GO DRiver for ORacle) is an open source database package in Go that allows an application user to connect and work with Oracle Database. Oracle DB had introduced new JSON features in its latest release (21c), including a new datatype. Oracle has now added support for the latest JSON features in Oracle DB 21c in Godror's latest release. We will look at all the exciting new JSON-specific features ready to use in godror!

Beda Hammerschmidt, Consulting Member of Technical Staff
Sharad Chandran R, Principal Product Manager
sudarshan soma, Principal Member Technical Staff
June 8, 2022Back to the Basics of DB Security - User ProfilesBack to the Basics of DB Security - User ProfilesDid you know Oracle 19c users can have two different passwords active at the same time? Have you ever had a difficult time changing all of the application user passwords because so many different systems use them and you don't know if you've captured them all? Have you ever wanted to limit a user to only 1, maybe 2, sessions at a time in the database? Are you using password reuse and expiration parameters properly? Do you need to temporarily lock an account for too many failed passwords?

In June's Database Security Office Hours, Russ Lowenthal, Senior Director of Product Management, will take you back to the basics where you will learn how to answer all of the above and much more with Oracle User Profiles.

Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Hakim Loumi, Product Manager/Field Engineer - Database Security
Pedro Lopes, Sr. Principal EMEA Field PM
Russ Lowenthal, Senior Director of Database Security Product Management
June 2, 2022OCI in Pocket - OCI News: Data & AIOCI in Pocket - OCI News: Data & AIO OCI in Pocket, nossa pílula de Conhecimento semanal, é um evento que acontece todas às quintas das 9h às 9h30, sempre em trilhas de conhecimento diferentes.

O tema será "Data & AI News" - Vitor Vieira

Nessa sessão vamos apresentar as últimas releases em Oracle Cloud Infrastructure dos serviços de Data Science, Data Lakehouse, AI e Data Analytics.

Assista para conhecer mais e entender como a Oracle vem desenvolvendo tecnologias de dados para transformar o negócio de várias empresas

Não fique de fora! Inscreva-se e você sempre será notificado quando novas sessões foram disponibilizadas!

#Data&AI #DataScience
#DataEngineering #MachineLearning
#OracleCloudInfrastruture #OCI
#DataViz #Lakehouse #InteligênciaArtificial
#DataWarehouse #Analytics

Breno Comin, Cloud Solution Engineer
Thais Henrique, Solutions Engineer
Vitor Vieira, Data & AI Manager
May 26, 2022لماذا اختارت دايناميش أوراكل أيبكس لبناء أنظمتها المعلوماتية؟لماذا اختارت دايناميش أوراكل أيبكس لبناء أنظمتها المعلوماتية؟يعد الأوراكل أيبكس منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أيبكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!

لتبقى على تواصل مع سلسلة أيبكس بالعربي يرجى الضغط على "اشترك" في أعلى هذه الصفحة ومن ثم "الدخول للاشتراك".

انضم إلينا في هذه الحلقة وشاهد لماذا تم اختيار أوراكل أيبكس لبناء الأنظمة المعلوماتية لشركة دايناميش المتخصصة في قطاع الإنشاءات.

Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
May 24, 2022Customer Spotlight: Sensa Analytics Use Case Deep Dive and Lessons LearnedCustomer Spotlight: Sensa Analytics Use Case Deep Dive and Lessons LearnedFor this session, we are pleased to welcome back our guest speaker Steve Chamberlin of Sensa Analytics, who will take a deeper dive into their use case with an OML example and lessons learned in applying Oracle Machine Learning to the problem of healthcare claims processing. This is part 2 of the April 12 session.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Steve Chamberlin, CEO
May 20, 2022Oracle Data Transforms: ETL direto no Banco de DadosOracle Data Transforms: ETL direto no Banco de DadosOracle Data Transforms: ETL direto no Banco de Dados

👀 Você sabia que é possível trabalhar com ETL (Extração, Transformação e Carregamento de dados) direto dentro do Autonomous Database? 🤔

Você pode fazer isso através de uma interface gráfica intuitiva onde por trás temos o poder do Oracle Data Integrator (ODI)!

Aprenda na prática como, conectar, projetar e desenvolver seus fluxos de dados utilizando o Oracle Data Transforms, com todo o processamento direto no Autonomous Database.

Apresentado por: Heloisa Escobar - https://www.linkedin.com/in/heloisa-escobar-09ab7583/

Acesso ao mateial do Lab:
https://github.com/heloisaescobar/OCI-in-Lab-Data-Transforms

#Data&AI #DataScience
#DataEngineering #MachineLearning
#OracleCloudInfrastruture #OCI
#DataViz #Lakehouse #InteligênciaArtificial
#DataWarehouse #Analytics

Heloisa Escobar, Solutions Engineer - Cloud Tech (Brazil) | Data & AI
Thais Henrique, Solutions Engineer
May 19, 2022New rules for ROWIDs and more!New rules for ROWIDs and more!Practical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session we talked about:

- The new rules for using a ROWID
- Sorting numeric data which contains some invalid strings
- Handling the relationship between sequences and tables
- Options for deleting old data

Connor McDonald, Developer Advocate
May 17, 2022How to archive old dataHow to archive old dataAs applications mature there is often a need to archive old data. This could be to reduce storage costs, improve query performance or meet regulatory requirements.

But adding archival routines is a daunting task. The processes to remove old data can be complex to write and take a long time to run. So often this work is deferred, leading to colossal tables that are increasingly hard to manage.

Join this session to learn strategies to quickly and easily wipe the oldest rows in tables.

Highlights include:

01:30 - What is archiving?
05:25 - Why archive?
14:50 - Using DDL to make DELETE faster
15:50 - "Delete" methods performance comparison
19:20 - How to add partitioning to a table
24:40 - Using partition exchange to move data to archive tables
34:50 - Handling child rows when archiving data
38:00 - Reference partitioning
42:20 - What is In-Database Archiving
47:40 - Demo of adding partitioning to tables and using partition exchange to archive data

Chris Saxon, Oracle Developer Advocate for SQL
May 16, 2022Visual Builder New Features - May 2022Visual Builder New Features - May 2022Come and learn about the new features added to Oracle Visual Builder and Visual Builder Studio in our May 2022 Release.

Brian Fry, Director of Product Management
Laura Akel, Senior Principal Product Strategy Manager
Shay Shmeltzer, Director of Product Management
May 12, 2022Part 5: UI, PWA and MobilePart 5: UI, PWA and MobileThis is the last part of the five amazing sessions we hosted about Oracle APEX 22.1.
Part 1: Sneak Preview of What's New - https://youtu.be/wEByBTc_dp0
Part 2: What's new in Oracle APEX 22.1 - https://youtu.be/TbBs_ZXro-g
Part 3: New and Improved Components - https://youtu.be/pbMfCECO3AU
Part 4: Developer Experience - https://youtu.be/7qklHBqKE3s

In this session, we presented and demonstrated these features in Oracle APEX 22.1: Persistent Authentication, PWA enhancements, and User Experience.

0:00 - Welcome and Introduction
3:10 - Persistent Authentication
23:24 - PWA enhancements
52:06 - User Experience

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
May 11, 2022Oracle Audit Vault & Database Firewall 20.7 New Features & UpdatesOracle Audit Vault & Database Firewall 20.7 New Features & UpdatesPlease join us as Nazia Zaidi, Product Manager of Oracle Audit Vault and Database Firewall (AVDF), takes us through the new features her team has added in Oracle AVDF 20.7. This presentation will start with an overview of Oracle Audit Vault and Database Firewall as a critical component to centralizing and managing your audit records. Nazia will guide you through her team's work on AVDF and provide a walk-through of the latest features, including decrypting TLS traffic to an Oracle Database target, default DB firewall policies that simplify the most common monitoring requirements, updated reports and data retention policies as well as the shadow Audit vault Server now included to audit activities on the main AV server.

Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Nazia Zaidi, Sr. Principal Product Manager - Oracle Audit Vault and Database Firewall (AVDF)
Pedro Lopes, Sr. Principal EMEA Field PM
Richard C Evans, Product Manager, Database Security
May 10, 2022Usage Highlight: OML4Py Embedded Python Execution SQL API on ADBUsage Highlight: OML4Py Embedded Python Execution SQL API on ADBJoin us for this Office Hours session on the new SQL API for OML4Py Embedded Python Execution. Using embedded execution, user-defined Python functions can be invoked on database-environment-spawned and managed Python engines and enables data-parallel and task-parallel processing. In this session, we'll see how to invoke such functions not only from Python but also from SQL and REST for ease of production deployment.

Akash Dharamshi, Solution Engineer
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
May 5, 2022Part 4: Developer ExperiencePart 4: Developer ExperienceIn this session, we will present and demonstrate the developer experience enhancements in APEX 22.1.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
April 29, 2022A importância de MLOps em Data ScienceA importância de MLOps em Data ScienceSérie de eventos voltados à Data & AI na OCI. Conheça mais sobre as ferramentas que a Oracle tem para Data Science, Data Engineering, Machine Learning, Data Lake, Data Warehouse, Autonomous Data Warehouse e muito mais!

Nesta sessão falaremos sobre: A importância de MLOps em Data Science

Uma introdução didática, e ao mesmo tempo mão na massa, sobre MLOps e seu papel importante em projetos de Ciência de Dados

Apresentado por: Rafael Dias - https://www.linkedin.com/in/rafael-roberto-dias-data-lover/

Link para o passo-a-passo do Lab: https://github.com/rafaelrdias/OCI_In_Lab_MLOPS

#Data&AI #DataScience
#DataEngineering #MachineLearning
#OracleCloudInfrastruture #OCI
#DataViz #Lakehouse #InteligênciaArtificial
#DataWarehouse #Analytics

Rafael Dias, Sr. Cloud Engineer - Data & AI
Thais Henrique, Solutions Engineer
April 28, 2022Vista previa de las novedades de APEXVista previa de las novedades de APEXEn esta sesión, presentaremos y demostraremos las funciones principales de APEX 22.1.

Mónica Godoy, Principal Product Manager
April 28, 2022Part 3: New and Improved ComponentsPart 3: New and Improved ComponentsIn this session, we will present and demonstrate the new and improved components in APEX 22.1.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
April 28, 2022Google Search your DatabaseGoogle Search your DatabaseIn this latest session we talked about:

- Dealing with date format masks and function based indexes
- Installing the sample schemas easily
- Improvements to Text indexing in 21c
- Building a Google-style search across your applications.

Connor McDonald, Developer Advocate
April 21, 2022Part 2: What's new in Oracle APEX 22.1Part 2: What's new in Oracle APEX 22.1In this session, we will present and demonstrate the marquee features of APEX 22.1.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
April 19, 2022Produzindo insights do seu sistema EBS com AnalyticsProduzindo insights do seu sistema EBS com AnalyticsSérie de eventos voltados à Data & AI na OCI. Conheça mais sobre as ferramentas que a Oracle tem para Data Science, Data Engineering, Machine Learning, Data Lake, Data Warehouse, Autonomous Data Warehouse e muito mais!

Nesta sessão falaremos sobre: Produzindo insights do seu sistema EBS com Analytics

Há um grande grupo de usuários que utilizam o E-Business Suite em OCI. Além dos ganhos de performance e flexibilidade que a nuvem Oracle proporciona, existe uma Stack que auxilia na extração de dados para que sejam consumidos em uma plataforma de Analytics.

Venha conferir como essa solução pode atender às necessidades do negócio complementando as capacidades relatoriais da aplicação e fornecendo uma visão centralizada e intuitiva para todos os principais indicadores

#Data&AI #DataScience
#DataEngineering #MachineLearning
#OracleCloudInfrastruture #OCI
#DataViz #Lakehouse #InteligênciaArtificial
#DataWarehouse #Analytics

Breno Comin, Cloud Solution Engineer
Thais Henrique, Solutions Engineer
April 19, 2022Optimizing functions in the WHERE clauseOptimizing functions in the WHERE clauseCalling functions in the WHERE clause can lead to slow SQL. This is because they limit the optimizer's ability to use indexes, can cause bad cardinality estimates, and increase the work the query does.

This session covered why functions cause the problems and actions you can take to avoid them.

Highlights include:

00:40 - the impact of calling functions in SQL where clauses
04:20 - Why functions prevent the optimizer using indexes
06:40 - Why can't the optimizer rearrange formulas?
12:40 - How to create function-based indexes
13:20 - Demo of indexing date range queries
17:20 - Invisible indexes
25:00 - Summary of problems functions in WHERE cause and function-based indexes
28:10 - Applying the function on INSERT/UPDATE
34:30 - The challenge of ensuring everyone uses the same function
36:15 - Virtual columns
38:10 - Demo of indexing case-insensitive search queries
47:20 - What to do when you have to use functions in a SQL query
49:00 - Optimizing PL/SQL functions in WHERE clauses
50:40 - Using PRAGMA UDF and Scalar SQL macros to improve runtime performance
51:50 - Demo of using PL/SQL functions to do currency conversion
58:00 - Recap of optimizing PL/SQL function in WHERE
58:50 - Final recap

Want to learn more about SQL performance tuning?

Join this free class on Oracle Dev Gym:

https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-performance.html

Chris Saxon, Oracle Developer Advocate for SQL
April 18, 2022Visual Builder - Real World ImplementationsVisual Builder - Real World ImplementationsJoin to learn from the experience of developers who built enterprise applications with Oracle Visual Builder. In this special meeting we'll hear their stories, learn about the architecture of their solutions and get an insight into what is really involved in delivering VB based apps.

abhishek chauhan,
Mohan Chandra, Senior Principal Consultant
Shay Shmeltzer, Director of Product Management
April 14, 2022Part 1: Sneak Preview of What's NewPart 1: Sneak Preview of What's NewIn this session, we will present and demonstrate the marquee features of APEX 22.1.

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Principal Product Manager
April 13, 2022Oracle Key Vault 21.4 New FeaturesOracle Key Vault 21.4 New FeaturesPlease join us as Peter Wahl, Product Manager of Oracle Transparent Data Encryption and Oracle Key Vault, takes us through the new features his team has added in Oracle Key Vault 21.4. This presentation will start with an overview of Transparent Data Encryption and why Key Vault is a critical component to securing and protecting your organization's sensitive data. Peter will guide you through his team's work on encryption and key management since 11gR2 and conclude with a demonstration of non-extractable keys and per-PDB keystores.

The Database Security product management team holds a knowledge-building session on the second Wednesday of the month at 10:00 am US Central time. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Recording Highlights
1:50 Announcements
5:00 Oracle Key Vault 21.4 Presentation
42:45 Oracle Key Vault Resources
43:38 Next Month's Topic - ADVF 20.7

Pedro Lopes, Sr. Principal EMEA Field PM
Peter Wahl, Principal Product Manager
Richard C Evans, Product Manager, Database Security
  • 1 - 50