LightNews LightNews
mschuapex2000.bsky.social
@mschuapex2000.bsky.social
8 followers 20 following 0 posts
No politics, just #orclapex
Posts Replies Media Videos
Reposted
hartenfeller.dev
📝 How to be able to run JavaScript extensions for #SQLcl on macOS using #GraalVM: hartenfeller.dev/blog/sqlcl-j...
SQLcl with JavaScript on macOS using GraalVM
Getting JavaScript working in SQLcl in 2025 is not straightforward. Here is how I did it on macOS using GraalVM.
hartenfeller.dev
January 7, 2025 at 3:38 PM
Reposted
thatjeffsmith.com
Recommended reading for Oracle Database

Deep dive on Binary JSON formats (the first in a series) from @loiclefevre.bsky.social

medium.com/db-one/jsonb...
JSONB, BSON, OSON…  A deep dive into Binary JSON formats
If you’ve used JSON to store and manage data, you’ve likely faced situations where the format seemed to fall short of your expectations…
medium.com
January 2, 2025 at 12:33 PM
Reposted
thatjeffsmith.com
SQL Developer Web, Database Actions, LiveSQL - these web applications are powered by REST APIs.

Each request you make is ran as it's own transactions/session.

To test 23ai's SQL Transpiler, run it as a script!

Hat Tip: @monikalewandowska.bsky.social
Learn more: oracle-base.com/articles/23/...
alter session set sql_transpiler = 'ON'; select id, val1, val2 from t1 where add_numbers(val1, val2) = 300; EXPLAIN PLAN FOR select id, val1, val2 from t1 where add_numbers(val1, val2) = 300; select plan_table_output from table(dbms_xplan.display('plan_table',null,'all'));
November 20, 2024 at 8:08 PM
Reposted
thatjeffsmith.com
💡 Tip: Working with lots of different databases and don't want to accidentally drop a table in your PROD Oracle system?

PS if you've never done this, you've probably not been in IT for very long #riteOfpassage

Use emojis in your connection names 🔴 🟡 🟢

Tip 2: STAY OUT OF PRODUCTION :)
November 15, 2024 at 2:21 PM