Loic Lefevre
banner
loiclefevre.bsky.social
Loic Lefevre
@loiclefevre.bsky.social
⚔️Data Warrior⚔️
Oracle Database PM, Java Hacker, OSON Evangelist, Cool SQL and mongo2ora father
blog: medium.com/db-one
#MyView
Pinned
🤩 Want to get started quickly with #SQL using the #Oracle #Database 23ai?

Here is my getting started guide: #easy #fast 🚀🦭🐳👇

medium.com/db-one/oracl...
Oracle Database 23ai: Download, Install, Tutorial… My Getting Started Guide
TL;DR — In this post, I share the tricks I’ve learned for getting started fast with the Oracle Database.
medium.com
Reposted by Loic Lefevre
Get your desks of #SQL tips at #AIWorld from the swag-as-a-service or Oracle AI Database booths
October 14, 2025 at 4:50 PM
Ca pourrait aider certain.e.s : règles de sécurité pour la circulation en vélo

www.securite-routiere.gouv.fr/sites/defaul...
www.securite-routiere.gouv.fr
October 3, 2025 at 5:28 AM
Reposted by Loic Lefevre
Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER
QUICKLY access database object metadata via DBMS_DEVELOPER
Previously on @thatjeffsmith... QUICKLY access database object metadata via DBMS_DEVELOPER
www.thatjeffsmith.com
September 29, 2025 at 12:37 PM
Reposted by Loic Lefevre
Previously on @thatjeffsmith... How are we (Oracle) doing? Here’s your chance to tell us!
How are we (Oracle) doing? Here’s your chance to tell us!
Previously on @thatjeffsmith... How are we (Oracle) doing? Here’s your chance to tell us!
www.thatjeffsmith.com
September 24, 2025 at 12:38 PM
Reposted by Loic Lefevre
Previously on @thatjeffsmith... Oracle SQLcl 23.3 is now Available for download
Oracle SQLcl 23.3 is now Available for download
Previously on @thatjeffsmith... Oracle SQLcl 23.3 is now Available for download
www.thatjeffsmith.com
September 16, 2025 at 8:37 PM
Reposted by Loic Lefevre
Previously on @thatjeffsmith... SQL Notebooks in Oracle SQL Developer for VS Code
SQL Notebooks in Oracle SQL Developer for VS Code
Previously on @thatjeffsmith... SQL Notebooks in Oracle SQL Developer for VS Code
www.thatjeffsmith.com
September 10, 2025 at 8:42 PM
Reposted by Loic Lefevre
Previously on @thatjeffsmith... Come see the Database Tools team at Oracle Cloud/DB World
Come see the Database Tools team at Oracle Cloud/DB World
Previously on @thatjeffsmith... Come see the Database Tools team at Oracle Cloud/DB World
www.thatjeffsmith.com
September 9, 2025 at 12:40 PM
Reposted by Loic Lefevre
How to Unplug an Oracle Database PDB into a .pdb File and Replug into Another Container Database

Oracle's Multitenant architecture allows you to unplug a Pluggable Database (PDB) from one Container Database (CDB) and plug it into another, simplifying database migration and management. This quick…
How to Unplug an Oracle Database PDB into a .pdb File and Replug into Another Container Database
Oracle's Multitenant architecture allows you to unplug a Pluggable Database (PDB) from one Container Database (CDB) and plug it into another, simplifying database migration and management. This quick guide walks through the process of unplugging a PDB into a .pdb archive file and replugging it into another CDB. We will be using the gvenzl/oracle-free images to demonstrate multiple Oracle Database environments.
www.geraldonit.com
September 9, 2025 at 1:00 PM
Reposted by Loic Lefevre
Using SQLcl Projects

Learn how you can get started with SQLcl Projects to help automate and mange your application development lifecycle.

spendolini.blog/using-sqlcl-...

#orclapex
Exploring SQLcl Projects
SQLcl Projects streamline database deployment with Liquibase, simplifying change management, code automation, and CI/CD integration
spendolini.blog
September 1, 2025 at 2:23 PM
Reposted by Loic Lefevre
The wait is almost over for Flows for APEX 25.1. The cake is in the oven! flowsforapex.org #orclapex
Flows for APEX
Oracle APEX extension for BPMN based workflows
flowsforapex.org
September 1, 2025 at 7:25 PM
Reposted by Loic Lefevre
Reposted by Loic Lefevre
JSON Type Modifier Enhancements in Oracle Database 23ai

oracle-base.com/articles/23/...

@OracleDatabase #database #23ai
August 6, 2025 at 7:26 AM
Reposted by Loic Lefevre
‼️ #Oracle #Database 23.9 brings some really cool #Developer features to the table:

😎 GROUP BY ALL
🥇 Non-positional INSERT statements - first and only database to support this
🔢 UUIDv4
And more!

Definitely check it out 👇
What’s new for Developers in Oracle Database 23.9
For more information on what's new in Oracle Database 23.8, see: What's new for Developers in 23.8 Oracle Database 23.9 has been my favorite RU so far. The features introduced in 23.9 are some of those that we had long had on our list, but simply took a while to get to and to get right. The Non-Positional INSERT INTO…
www.geraldonit.com
August 5, 2025 at 1:00 PM
Reposted by Loic Lefevre
UUID() Function in Oracle Database 23ai

oracle-base.com/articles/23/...

@OracleDatabase #database #23c
August 5, 2025 at 6:19 AM
Reposted by Loic Lefevre
🚨 Oracle Database 23ai Release Update 9 is available 🚨

🆕 Beginning with Oracle Database 23.9 you no longer need to grant execute on javascript... to execute JavaScript code in the database

📖 Read the blog post for more details: martincarstenbach.com/2025/08/04/w...

👉 Give it a go on your database
What’s new with MLE 23.9 – no need to grant execute on javascript
Oracle Database 23ai introduces In-Database JavaScript for Linux x86-64 and aarch64. That’s Linux on Intel and Arm, respectively. Developers with a preference for Typescript can use it alternativel…
martincarstenbach.com
August 4, 2025 at 10:01 AM
Reposted by Loic Lefevre
This is a great post showing you how to use multiple properties files in SQLcl projects. This trick comes in very handy when you want to deploy your APEX app to multiple environments. blog.neilfernandez.com/sqlcl-projec...
Define Dynamic Property File Location in SQLcl Projects
Learn to dynamically define property file locations in SQLcl projects for efficient APEX installations with customizable configurations
blog.neilfernandez.com
July 30, 2025 at 3:36 PM
Reposted by Loic Lefevre
The #SQLcl #GitHub action just received an update.

There's no longer a need for the versions.txt file and you can pick up versions as long as they are live on oracle.com.

However, the recommendation remains to just use "latest".

github.com/marketplace/...
oracle.com
July 28, 2025 at 2:43 AM
Reposted by Loic Lefevre
Dynamic Statistics for PL/SQL Functions in Oracle Database 23ai

oracle-base.com/articles/23/...

@OracleDatabase #database #23ai
July 25, 2025 at 6:30 AM
In case you didn't see, #Oracle #database 23.9 has landed

docs.oracle.com/en/database/...

#SQL #NewFeatures
Oracle Database New Features
This book describes the new features in Oracle Database 23ai.
docs.oracle.com
July 23, 2025 at 12:12 PM
Reposted by Loic Lefevre
Learn what's new for #Developers in #Oracle #Database 23ai Release Update 8
What’s new for Developers in Oracle Database 23.8
For more information on what's new in Oracle Database 23.7, see: What's new for Developers in 23.7
www.geraldonit.com
July 22, 2025 at 4:00 PM
Reposted by Loic Lefevre
TechTarget:

"The industry has adopted MCP extremely quickly, and the potential was obvious from the beginning," he said. "We evaluated it internally and saw quite clearly that the potential for Oracle Database users was real. The key is doing it in a way that makes sense, is secure and will scale."
July 21, 2025 at 10:18 PM
Reposted by Loic Lefevre
Did you know that in #Oracle #Database 23ai, you can now #materialize columns in your tables, just like Star Trek, but cooler.

👉 www.geraldonit.com/whats-new-fo...
July 21, 2025 at 8:58 PM