Tobias Arnhold

Diverse Logos

Juhu,

wir haben diese Woche ein Frankfurt APEX Meetup!

Am 22.5. sind wir ab 17:30 bei Syntegris in Neu-Isenburg zu Gast.

Anmeldung über Meetup:
meetu.ps/e/P2Lvm/pMkw...

Wir freuen uns auf Euch!

@oracleace.bsky.social @ora2know.de
#orclAPEX

@chrisdeberg.bsky.social @anjeli2001.bsky.social

#apexconn25 Schön war’s! 🔥🎢
Team, Connecten, Achterbahnen und einen glücklichen Gewinner❗️
#orclapex

#apexconn25 Tipp für 11:00 Uhr ➡️ „Die APEX Karriereleiter“ — Karriere, Einkommen, Weiterentwicklung | meine.doag.org/events/apex-...

Mit @tobias-arnhold.bsky.social und André Monson im Raum Bellevue

PS: 15 Aussteller im Dome 🤩 Kaffee/Wasser holen und immer wieder gerne vorbeischauen.

#orclapex

Wann kommt das Produkt endlich?

Sehr lebensnaher Vortrag von @anjeli2001.bsky.social, @tobias-arnhold.bsky.social und André Monson - mit freundlicher Unterstützung von @ronnyweiss.bsky.social 👍

#APEXconn25 #orclAPEX Karriere

Things we learned about LLMs in 2024

A lot has happened in the world of Large Language Models over the course of 2024. Here's a ...

https://simonwillison.net/2024/Dec/31/llms-in-2024/#atom-everything

Speaking of which ... for the old-schoolers

I didn’t know that a new release was out until I saw @thatjeffsmith.com announce it. Went over to trigger the update only to find it had updated itself already. Couldn’t be easier to use.

Oracle Database Tools Statement of Direction The Oracle Database desktop development, query, and management platform for the past two decades has been Oracle SQL Developer. With more than 7,000,000 installs worldwide, we have helped our customer...

📣 Oracle SQL Developer Extension for VS Code is now your official platform for Oracle Database querying, development, and administration.

www.linkedin.com/pulse/oracle...

The Oracle Developer Tools extension has been deprecated.

I also share a bit of roadmap/futures you can look forward to.

Since multiple people asked, @samarchdb.bsky.social's research doesn't really work well on Postgres because it has one of the worst query optimizers we've tested (sorry it's true). It cannot decorrelate subqueries needed to inline UDFs. See Sam's CIDR 2024 paper: db.cs.cmu.edu/papers/2024/...

How to cancel a long running Oracle SQL query in VS Code When you're running SQL via VS Code and our Oracle SQL Developer Extension, you have two options for how to cancel. Here's a quick read with demo.

Got a long-running Oracle SQL query that Just Won't Stop?

Cancel it with

ALTER SYSTEM CANCEL SQL '<sid>, <serial#>'

Or if you're using the Oracle SQL Developer Extension for VS Code you stop it using

Task Status
Task Monitor

@thatjeffsmith.com demos

Starter pack of #SYM42 Symposium 42 members

go.bsky.app/AnE4rQH

SQL firewall overview

Oracle Database 23ai has a built in #SQL firewall

Use this to define a list of allowed statements

Statement not the list are logged and can also be blocked

@stefanoehrli.bsky.social tracking us all about it at #ukoug2024

CfP ends today, midnight DOAG time

Gianni says I can’t use #ukougdiscover24 to promote #apexconn25 🤷‍♀️

But CfP ends TODAY!
You can submit here: apex.doag.org 🙂

Tracks:
Solutions
APEX ##orclAPEX
SQL&PL/SQL #sql #plsql

This image shows a Workflow Diagram modeled in APEX 24.1 Workflow Designer. The diagram shows several activities in a sequence with a Switch activity to branch in the process after a Human Task. Depending on the outcome of the Human Task, APPROVED or REJECTED, the process takes a certain route. Also shown in the diagram is a custom activity 'OML Pipeline' which is implemented as a Process Type plugin and enabled for use as Workflow Activity.

Did I say I submitted something for #apexconn25 next year. What do you think is the topic? The image below will give some hint. Hurry up #orclAPEX folks, today is the last day to submit for this conference.
#processautomation #workflow

Last day to submit your abstract for the APEX Connect 2025❗️
Be part of this unique event
🖥️🎢🧑🏼‍💻🎡👩🏻‍💻🎠🏃🏻‍♂️
apex.doag.org/de/apex-conn...
#savethedate 13-15 May ‘25
#orclapex
#europapark

Submit your abstract for the APEX Connect conference. May 13-15, 2025.

Did you submit your abstract already? Deadline is tomorrow, December 2nd.

apex.doag.org

#orclapex #apexconn25 @doagev.bsky.social

Conference: lovely part of life
Dinner: great
Drinks: essential
Friends: invaluable

#ukougdiscover24

YouTube video by United Codes APEX Shortcuts | UC Advent Calendar 1

For the festive season, we are doing a @united-codes.bsky.social  advent calendar with a quick APEX tip video every day.

Check out how you can create reusable item utility buttons with #orclAPEX Shortcuts: youtu.be/iaX9R6O37QM

JSON support in SQL is not about storing JSON documents¹.

While storing JSON in SQL tables is possible and sometimes quite useful, the true power of JSON in SQL comes from the ability to *process* JSON within SQL.

I'll present next week during the JSON Schema APIDays Paris!
Agenda: conference.json-schema.org/schedule/#da...
Grab your free ticket here 👉 ticket.apidays.global/event/apiday...

#jsonschemaconf24 #jsonschema #apidays #data #json

Live SQL V2 script to show how delimited strings can be tokenized in the Oracle Database. My favorites are: -- -- Alternative 1: Split with APEX_STRING.SPLIT -- select record_id, count(column_value) as token_cnt from tokens, apex_string.split( record_tokens, ':') group by record_id; -- -- Alternative 2: Split with JSON_TABLE -- select record_id, count(token) as token_cnt from tokens, json_table( '["' || replace( replace( replace( record_tokens, '\', '\\' ), '"', '\"' ), ':', '","' ) || '"]', '$[*]' columns (token varchar2(255) path '$' )) group by record_id;

... seen the usage of REGEXP_SUBSTR and CONNECT BY to tokenize strings with SQL - and guess what? Was way too slow.

So, here's a LiveSQL V2 script to compare a few approaches.
livesql.oracle.com/next/library...

JSON_TABLE or APEX_STRING are still my favorites!

#OracleDatabase #SQL

Niels de Bruijn, links im Bild, Konferenzleiter der APEX connect 2025, und Sabine Heimsath, Leiterin des Streams PL/SQL auf der selbigen Konferenz im Europa-Park in Rust, sprechen über den in wenigen endenden Call for Papers zur Einreichung von Vorträgen.

🎥 DOAG.tv | Finale im Call for Papers 🚀 nielsdb.bsky.social, Konferenzleiter der #apexconn25, und @oraesque.bsky.social, DOAG Themenverantwortliche #PLSQL, sprechen über den am 02.12.2024 um 23:59 Uhr endenden Countdown zur Einreichung von Vorträgen für die #orclapex Fachkonferenz ➡️ scomp.ly/aeYbq1L

It's time to write abstracts!!

The call for papers for APEX World 2025, 15th edition is now open!

nloug.nl/en/events/ca...

#CfP #APEXWorld2025 #aw25 #15thEdition #orclAPEX #oracle #CallForPapers @oracleugs @oracleace

So sehr ich mich auf zu Hause freue, so wehmütig bin ich das heute schon Schluss mit #Doag2024 ist ... Auf in den letzten Tag

Firefox Developer Edition. 🔥🦊
#orclapex

Sabine mit APEX Connect T-Shirt

Auf der Konferenz ist vor der Konferenz!!!

Bitte vergesst nicht: Der CfP für die APEX Connect 2025 läuft. Und zwar bis zum 2. Dezember. Abends. Nachts.
Aber Ihr müsst es nicht ausreizen 🙂

Einfach einreichen: apex.doag.org

#APEXconn25 13. - 15. Mai ’25 im Europapark!

#DOAG2024 #orclAPEX

Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required It's that much easier to get started learning SQL and Oracle Database with our new and improved Oracle LiveSQL platform! Now running 23ai!

I have a new answer for what's the easiest way to get started with Oracle or SQL, using the latest technology..

Oracle LiveSQL

www.thatjeffsmith.com/archive/2024...