Tobias Arnhold
LightNews LightNews
banner
tobias-arnhold.bsky.social
Tobias Arnhold
@tobias-arnhold.bsky.social
200 followers 120 following 4 posts
A guy with passion for Oracle APEX and BI. Beside this I'm a Dad, Geek and Football Fan.
Posts Replies Media Videos
Reposted by Tobias Arnhold
oraesque.bsky.social
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
Diverse Logos
May 19, 2025 at 7:03 PM
tobias-arnhold.bsky.social
@chrisdeberg.bsky.social @anjeli2001.bsky.social
tobias-arnhold.bsky.social Tobias Arnhold @tobias-arnhold.bsky.social · May 15
#apexconn25 Schön war’s! 🔥🎢
Team, Connecten, Achterbahnen und einen glücklichen Gewinner❗️
#orclapex
May 15, 2025 at 7:50 PM
tobias-arnhold.bsky.social
#apexconn25 Schön war’s! 🔥🎢
Team, Connecten, Achterbahnen und einen glücklichen Gewinner❗️
#orclapex
May 15, 2025 at 5:57 PM
Reposted by Tobias Arnhold
doagev.bsky.social
#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
May 14, 2025 at 7:41 AM
Reposted by Tobias Arnhold
oraesque.bsky.social
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
Wann kommt das Produkt endlich?
May 14, 2025 at 9:44 AM
Reposted by Tobias Arnhold
pythonhub.dev
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
January 5, 2025 at 1:15 AM
Reposted by Tobias Arnhold
connormcd.bsky.social
Speaking of which ... for the old-schoolers
December 17, 2024 at 2:54 PM
Reposted by Tobias Arnhold
martindba.bsky.social
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.
December 17, 2024 at 1:53 PM
Reposted by Tobias Arnhold
thatjeffsmith.com
📣 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.
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...
www.linkedin.com
December 10, 2024 at 10:01 PM
Reposted by Tobias Arnhold
andypavlo.bsky.social
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/...
Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL CIDR 2024
December 7, 2024 at 3:10 AM
Reposted by Tobias Arnhold
sqldaily.bsky.social
Got a long-running Oracle SQL query that Just Won't Stop?

Cancel it with

ALTER SYSTEM CANCEL SQL ', '

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

Task Status
Task Monitor

@thatjeffsmith.com demos
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.
www.thatjeffsmith.com
December 6, 2024 at 12:00 PM
Reposted by Tobias Arnhold
kibeha.dk
Starter pack of #SYM42 Symposium 42 members

go.bsky.app/AnE4rQH
November 14, 2024 at 7:27 PM
Reposted by Tobias Arnhold
chrisrsaxon.bsky.social
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
SQL firewall overview
December 2, 2024 at 12:25 PM
Reposted by Tobias Arnhold
oraesque.bsky.social
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
CfP ends today, midnight DOAG time
December 2, 2024 at 11:17 AM
Reposted by Tobias Arnhold
ralf-mueller.bsky.social
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
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.
December 2, 2024 at 12:37 PM
tobias-arnhold.bsky.social
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
APEX connect 2025: APEX Connect
apex.doag.org
December 2, 2024 at 7:03 AM
Reposted by Tobias Arnhold
cczarski.bsky.social
Did you submit your abstract already? Deadline is tomorrow, December 2nd.

apex.doag.org

#orclapex #apexconn25 @doagev.bsky.social
Submit your abstract for the APEX Connect conference. May 13-15, 2025.
December 1, 2024 at 2:00 PM
Reposted by Tobias Arnhold
evrocs.bsky.social
Conference: lovely part of life
Dinner: great
Drinks: essential
Friends: invaluable

#ukougdiscover24
November 30, 2024 at 10:00 PM
Reposted by Tobias Arnhold
hartenfeller.dev
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
APEX Shortcuts | UC Advent Calendar 1
YouTube video by United Codes
youtu.be
December 1, 2024 at 10:30 AM
Reposted by Tobias Arnhold
winand.at
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.
November 29, 2024 at 10:22 AM
Reposted by Tobias Arnhold
loiclefevre.bsky.social
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
November 29, 2024 at 3:03 PM
Reposted by Tobias Arnhold
cczarski.bsky.social
... 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
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;
November 26, 2024 at 2:43 PM
Reposted by Tobias Arnhold
doagev.bsky.social
🎥 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
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.
November 26, 2024 at 8:22 AM
Reposted by Tobias Arnhold
nloug.bsky.social
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
November 21, 2024 at 10:58 AM
Reposted by Tobias Arnhold
kirvirvi.bsky.social
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
November 21, 2024 at 7:05 AM