Philipp Salvisberg
banner
salvis.com
Philipp Salvisberg
@salvis.com
Focused on database-centric development. Chat is open.
https://www.salvis.com/blog/about
Some Oracle ACE Program swag waited for me after returning from two amazing days at the ATP Finals in Turin. Useful stuff for #DOAG2025 next week! Thanks @oracleace.bsky.social!
November 11, 2025 at 5:49 PM
Reposted by Philipp Salvisberg
SYSDATE in Oracle AI Database is evaluated once per

Statement in #SQL
Call in PL/SQL

Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement

But beware: this can lead to unwanted behaviour

@salvis.com explores
Is SYSDATE Deterministic? #JoelKallmanDay - Philipp Salvisberg's Blog
Is SYSDATE deterministic in Oracle Database? Explore definitions, test cases, and pitfalls when using SYSDATE vs deterministic functions.
buff.ly
October 28, 2025 at 12:03 PM
Reposted by Philipp Salvisberg
I felt like writing a blog post —a little write-up on why fixing failed #database deployments is challenging.
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃

medium.com/@jasminfluri...
Database Rollbacks in CI/CD: Strategies and Pitfalls
Database rollbacks would be incredibly valuable and essential if we want quick fixes for failed deployments. But they are rarely feasible.
medium.com
October 22, 2025 at 7:44 PM
Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks! #HrOUG25 #HrOUG2025
October 17, 2025 at 7:17 AM
This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025
October 16, 2025 at 2:08 PM
Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025
October 16, 2025 at 9:57 AM
Having fun at the tennis court #hroug25
October 16, 2025 at 7:13 AM
Reposted by Philipp Salvisberg
For #JoelKallmanDay I am sharing a free plug-in for reactive Markdown preview. It auto refreshes, supports tables, alerts, etc., and comes with three themes. #orclAPEX

hartenfeller.dev/blog/apex-re...
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
hartenfeller.dev
October 15, 2025 at 5:03 AM
Is SYSDATE Deterministic? #JoelKallmanDay

No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.

www.salvis.com/blog/2025/10...
Is SYSDATE Deterministic? #JoelKallmanDay
TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...
www.salvis.com
October 15, 2025 at 1:59 AM
Do you use MERGE statements in your PL/SQL code? Then I recommend not using Oracle SQL Developer for VSCode version 25.3.0 or SQLcl 25.3.0.

See forums.oracle.com/ords/apexds/...
forums.oracle.com
October 10, 2025 at 3:32 PM
„The successful 5% of AI agents? They all have one thing in common: human-in-the-loop design.“
Great read: What Makes 5% of AI Agents Actually Work in Production?
www.motivenotes.ai/p/what-makes...
October 9, 2025 at 7:30 PM
Reposted by Philipp Salvisberg
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
www.thatjeffsmith.com
October 6, 2025 at 5:44 PM
I've just finished writing my blog post. And you?
Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase
September 29, 2025 at 11:35 AM
Subtly downgrade a band:

Beagles
Subtly downgrade a band:

Veggie Loaf
Subtly downgrade a band:

Tin Zeppelin
September 28, 2025 at 5:45 AM
Reposted by Philipp Salvisberg
New blog post, my longest one ever. A full guide on how to use AI as a PL/SQL developer.

- No 23ai or Python required
- Advanced techniques like tools, structured output, reasoning, and file analysis
- Usage demos

hartenfeller.dev/blog/real-ai...
#oracle #ai #orclAPEX
Build Real AI Solutions with Oracle PL/SQL (No 23ai Required)
Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.
hartenfeller.dev
September 17, 2025 at 11:29 AM
Reposted by Philipp Salvisberg
GraalVM 25 is here, with lots of updates for native compilation, GraalPy, GraalJS, and WebAssembly.
Faster and better than ever!🐰🚀
Download: www.graalvm.org/downloads/
Release notes: www.graalvm.org/release-note...
September 16, 2025 at 3:38 PM
If you are using version 0.15.0 of the dbLinter VS Code extension, please update to version 0.15.1. Thx!

This update fixes a problem where the wrong configuration name was being used for anonymous users. Other users are not affected.
September 16, 2025 at 11:40 AM
Reposted by Philipp Salvisberg
Transactional Outbox: Simplified with Oracle Database

Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
Transactional Outbox: Simplified with Oracle Database
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional two-phase commit (2PC) implementations can be costly and slow, making them impractical for high-throughput environments. In this article, we’ll solve data consistency challenges in event streaming systems using Oracle Database Transactional Event Queues…
andersswanson.dev
September 12, 2025 at 4:38 PM
Reposted by Philipp Salvisberg
I guess it will be about linters and coding standards :) @salvis.com at #POUG2025 @sym42.bsky.social
September 5, 2025 at 12:49 PM
Reposted by Philipp Salvisberg
Get faster PL/SQL in #SQL with

alter session set sql_transpiler = on

=> database will convert eligible functions to SQL

Read my latest post for details on

What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes

blogs.oracle.com/sql/post/fas...
blogs.oracle.com
August 27, 2025 at 2:31 PM
Reposted by Philipp Salvisberg
New video: leverage AI coding assistants to generate unit tests for #oracle #PLSQL.

- how to structure your project
- optimize AI context with a copilot-instructions.md
- let the AI agent compile and test with SQL Dev #MCP server

youtu.be/O9fhl1Gr0UU #orclAPEX
Generate valuable PL/SQL unit tests with AI
YouTube video by United Codes
youtu.be
August 20, 2025 at 10:49 AM
In the next version of dbLinter, you will be able to report issues with related locations. Here's a sneak peek in VS Code and SonarQube (via generic formatted issue reports).

Fewer reported issues. Cleaner editor and issue repositories. 😎
August 19, 2025 at 2:07 PM
Reposted by Philipp Salvisberg
August 7, 2025 at 11:31 AM