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

ToggleIS_PUBLIC_CLASS = 'N'

1 - 50

Date	Session	Focus	Description
September 19, 2022	Excel Interfaces for REST Services	Excel Interfaces for REST Services	Learn 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, 2022	Should 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, 2022	Introducing Oracle Machine Learning for R for Oracle Autonomous Database	Introducing Oracle Machine Learning for R for Oracle Autonomous Database	Join 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, 2022	Preguntas Frecuentes sobre Oracle APEX	Preguntas Frecuentes sobre Oracle APEX	En 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, 2022	Multi-Cloud Security - Oracle Database and Azure Active Directory integration	Multi-Cloud Security - Oracle Database and Azure Active Directory integration	Join 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, 2022	How big can a database be? And your other questions answered	How big can a database be? And your other questions answered	Practical 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, 2022	Use Cloud Database and On-premise tools to connect to your cloud database services	Use Cloud Database and On-premise tools to connect to your cloud database services	Explore 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, 2022	Using R to cluster data at scale in Autonomous Database	Using R to cluster data at scale in Autonomous Database	Some 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, 2022	Visual Builder New Features - August 2022	Visual Builder New Features - August 2022	Learn 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, 2022	Developer Tips from the APEX Dev Team - Part III	Developer Tips from the APEX Dev Team - Part III	We'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, 2022	Multi-Cloud Security - Oracle Database and Azure Active Directory integration	Multi-Cloud Security - Oracle Database and Azure Active Directory integration	Azure 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, 2022	How to perform in-database text analytics using a pre-built ML model	How to perform in-database text analytics using a pre-built ML model	Did 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, 2022	AVDF Cafe - Reference Architectures of AVDF	AVDF Cafe - Reference Architectures of AVDF	Dear 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, 2022	AVDF Cafe - Reference Architectures of AVDF	AVDF Cafe - Reference Architectures of AVDF	Dear 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, 2022	APEX 22.1, ORDS and the MySQL Database Service	APEX 22.1, ORDS and the MySQL Database Service	APEX 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, 2022	Automate and codify your Exadata Database Service deployments using OCI Resource Manager and Terraform	Automate and codify your Exadata Database Service deployments using OCI Resource Manager and Terraform	As 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, 2022	Is CURSOR_SHARING broken? and your other questions answered	Is CURSOR_SHARING broken? and your other questions answered	Practical 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, 2022	How to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle Database	How to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle Database	Often 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, 2022	Extending Oracle Cloud Apps with Visual Builder	Extending Oracle Cloud Apps with Visual Builder	Learn 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, 2022	Como usar a API JavaScript para estender as funcionalidades do APEX	Como usar a API JavaScript para estender as funcionalidades do APEX	A 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, 2022	Back to the basics of DB security - Database roles	Back to the basics of DB security - Database roles	In 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, 2022	De 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, 2022	Heat Map	Heat Map	This 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, 2022	Use Case: Oracle Machine Learning in football - Expected Goals	Use Case: Oracle Machine Learning in football - Expected Goals	Thanks 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, 2022	How to handle NULL in SQL	How to handle NULL in SQL	The 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, 2022	Zero Data Loss Recovery Appliance - 3rd Party SEC Compliance Assessment	Zero Data Loss Recovery Appliance - 3rd Party SEC Compliance Assessment	Join 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, 2022	Everything an APEX Developer needs to know about ORDS	Everything an APEX Developer needs to know about ORDS	Exactly 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, 2022	Ready 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, 2022	Back to the Basics of DB Security - User Profiles	Back to the Basics of DB Security - User Profiles	Did 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, 2022	OCI in Pocket - OCI News: Data & AI	OCI in Pocket - OCI News: Data & AI	O 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, 2022	Customer Spotlight: Sensa Analytics Use Case Deep Dive and Lessons Learned	Customer Spotlight: Sensa Analytics Use Case Deep Dive and Lessons Learned	For 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, 2022	Oracle Data Transforms: ETL direto no Banco de Dados	Oracle Data Transforms: ETL direto no Banco de Dados	Oracle 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, 2022	New 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, 2022	How to archive old data	How to archive old data	As 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, 2022	Visual Builder New Features - May 2022	Visual Builder New Features - May 2022	Come 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, 2022	Part 5: UI, PWA and Mobile	Part 5: UI, PWA and Mobile	This 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, 2022	Oracle Audit Vault & Database Firewall 20.7 New Features & Updates	Oracle Audit Vault & Database Firewall 20.7 New Features & Updates	Please 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, 2022	Usage Highlight: OML4Py Embedded Python Execution SQL API on ADB	Usage Highlight: OML4Py Embedded Python Execution SQL API on ADB	Join 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, 2022	Part 4: Developer Experience	Part 4: Developer Experience	In 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