During April 10 – April 19, 2023, over 70 worldwide Oracle ACEs shared insights and knowledge on their blog posts or podcasts and videos. We have selected from over 160 blogs and podcasts some of them for you to enjoy – so we invite you to browse the list below and discover more on the Oracle 23c Free Developer Release, APEX, Database, SQL, Analytics, and More.

Oracle 23c Free Developer Release

Amy Simpson-Grange : Oracle Database 23c Free – Developer Release: Installing & Using VirtualBox Appliance 

Brendan Tierney : 23c Free VM setup

Cary Millsap : Fill the Glass, ep 11: DBMS_USERDIAG

Dani Schnider : Enhanced Partitioning Metadata in Oracle 23c       

Eddie Molina :

• Oracle 23c - módulos Javascript usando BFILE       
• Oracle 23c - Obtener información de los objetos Javascript

Eduardo Claro:

• 23c Expansion of the CASE syntax in PL/SQL        
• 23c Interval datatype aggregations 

Julian Dontcheff : SQL Domains in Oracle Database 23c: an example        

Lisandro Fernigrini :

• Que hay de nuevo en APEX 23.1?        
• Oracle 23c - IF [NOT] EXISTS en Sentencias DDL       
• SQL Developer 23.1 ya está disponible!           

Lucas Jellema :

• Oracle Database 23c as Graph Database–SQL Property Graph for network style querying           
• Get Going with SQL Developer against Oracle Database 23c Free

Martin Berger :

• 23c free - PL/SQL to SQL Transpiler - the CBOs area        
• 23c free - error messages, new and improved        

Peter Finnigan :

• Oracle 23c New Longer 1024 Character Passwords           
• Oracle Protected Users in 23c

Philipp Salvisberg: Oracle Database 23c on a Mac with an M-Series Chip 

Prashant Dixit : Auto Transaction Rollback in Oracle 23c – Is this the end of Row Level Locking in Oracle Database ?

Srinivasarao Ravulapalli :

• Unrestricted Direct Loads Features in Oracle 23c Database Architecture
• Oracle Database 23c Free - Developer Release launch on Oracle VM VirtualBox 7.0           

Timo Herwix : Setting up Oracle Database 23c on Oracle Linux 8 in OCI    

Timothy Hall :

• JSON_TRANSFORM Enhancements in Oracle Database 23c           
• JSON Schema in Oracle 23c   
• Automatic PL/SQL to SQL Transpiler in Oracle Database 23c           

Wadhah Daouehi :

• New Features 23c: BOOLEAN Column Data Type         
• New Features 23c: Table VALUES Constructor  

Database

Adrian Png : Say Hello From An Autonomous Database

Marcin Przepiorowski : Source and deployment control with Oracle databases — part 3  

Timothy Hall : Oracle Database 21c Installation On Fedora 38 (F38)

Tércio Costa: Executando o Data Pump em um Autonomous Database para o Object Storage           

APEX

Angel Oswaldo Flores Torres : Generar un JSON en Oracle APEX  

Clarisa Maman Orfali : ¡Muy buena noticia! ¡Ya está disponible Oracle APEX 23.1 en apex.oracle.com!   

Malik Sikandar Hayat : Oracle APEX 23 1 New Feature Execution Chains Page Processing

Philipp Hartenfeller: Introduction to Template Components in Oracle APEX 23.1 

Rodrigo Mesquita :

• APEX PWA Push Notifications in just a few minutes    
• Create a dynamic membership card on APEX  

OCI

Gurpreet Singh : Segment qualifiers in Oracle Fusion Financials Cloud     

Gustavo Rene Antúnez Berdejo: Back To Cloud Basics : IAM With Identity Domains        

Himanshu Singh: Create a Console Connection to DBCS system in OCI if you Forgot or Lost Keys           

Maicon Carneiro: OCI New Feature: Point In Time Recovery (PITR) em DB Systems MySQL com High Availability (HA)           

Paul Lewis: Improving Calc Scripts with SET HYBRIDBSOINCALCSCRIPT 

Radu Pârvu: Linux Playground on #OCI      

Robin Chatterjee: Saving your Oracle Cloud Database Backups from Ransomware         

SQL

David Kurtz :

• Using SQL Profiles to Tackle High Parse Time and CPU Consumption         
• Oracle SQL Tracing Processes from Startup   

Hesong Wang: 基于SQL的数据可视化和数据挖掘   

Marcus Vinicius Miguel Pedro: How to copy SQL Patches, SQL Profiles and SQL Baselines between environments           

Xiaogang Xue: Java connect MySQL database with SSL     

Analytics

Gianni Ceresa : Oracle Analytics Server – Installation Guide   |  Oracle Analytics Server – Installation Guide (part 2) | Installation Guide (part 3)

Žiga Vaupot: Using AutoML in Oracle Analytics      

More

Aman Sharma : DM-Multipath Configuration File    

Amod Joshi : Oracle Business Network - Deep Dive

Andrew Laferla: Profitability Patch Release – April 2023 (23.04)    

Bo Tang : Network Optimization of Super Remote MAA Oracle Dataguard Primary and Physical Databases           

Bobby Curtis: Using NGINX in unsecure mode for Oracle GoldenGate      

Clemens Bleile: Is it possible to setup a system that a client (specific IP address) can only connect to a specific DB-User?           

David Dai : Oracle 19c 在线将 普通表 转 分区表        

David Kurtz : Clearing PeopleTools Physical Cache Files after Database Restore or Database Flashback           

Emmanuel Guzmán Rojas: Configuración de almacenamiento compartido en Oracle Linux usando un disco externo 

Fernando Simon: Exadata version 23.1.0.0.0 – Part 04

Hassan Abd Elrahman: How to Create Table with Foreign Key in Oracle   

Joerg Sobottka: Welcome to Oracle Communities! (Red Stack Magazin article)

Johannes Michler: wireguard into Oracle Cloud Infrastructure using docker        

Maarten Mulders: Foojay Podcast #19: How Working For Free For Fun Brought Me Fame and Fortune – Or At Least Some Of Each – In The End

Pranay Tiwari: Build Sample SOAP Integration Services  to Display Concatenated String using Oracle Service Bus (OSB) 12C           

Raúl Antonio Molina Alvarenga: Construccion de un Oracle Data Guard Facil      

Selvakumar Nagulan: Create Oracle database Flashback logs outside FRA!          

Soumya Sundar Das: Handy Oracle Data guard Broker Commands Part-II

Sultan Khan: HOW TO RECOVER DROPPED PDB AFTER FLASHBACK OF CDB    

Talip Hakan Ozturk : Creating a Service and Testing Failover in Oracle HA Linux Cluster