PLSQL (@plsql) header
PLSQL (@plsql) profile picture

My name is Thomas. EBS / Apex Developer, BSc Mathematics, MSX computer nostalgics, etc

United States
Joined March 2009
Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)Photo by PLSQL (@plsql)
#orclapex 26.1 A native "menu button" is now possible - even the little things are helpful.
2
4
12
504
Over the last few days, I built my own Oracle APEX 26.1 AI Playground 🚀 Yes, I know there are super easy Docker setups 😄 But this time I went the old-school route and built everything from scratch. 🛠️ Full setup & walkthrough 👇 tm-apex.hashnode.dev/buildin… #orclapex
3
11
489
PLSQL retweeted
Change an Oracle table to be insert-only with ALTER TABLE ... BECOME IMMUTABLE NO DROP ... NO DELETE ... This then blocks UPDATEs to the rows You can only remove - rows older than the NO DELETE setting - the table if there's no new rows since the NO DROP setting
7
1
24
1,720
PLSQL retweeted
You can initialize PL/SQL arrays with FOR loops itype constructors from 21c array := arr_type ( FOR i IN ... ) These can loop through Values => IN x .. y A cursor => IN ( SELECT ... ) Use the optional INDEX clause to set custom indices Try these at freesql.com/?compressed_code…
12
17
1,057
Everyone debated the wrong thing. The real answer 👇 teapawt.net/i/status/2063177489640…
Everyone debated UUIDs today. But nobody mentioned UUID v7. Here's why it changes everything 🧵 The real problem with UUID v4: -> Completely random -> Fragments your B-tree indexes -> Kills write performance at scale -> Larger storage than integers This is what the "never use UUID" crowd experienced. And they weren't wrong for v4. UUID v7 fixes all of that: -> Timestamp-prefixed (sequential by design) -> No index fragmentation -> Fast inserts, just like auto-increment -> Still globally unique - no coordination needed -> Works across distributed systems out of the box UUID v7 wins on almost every axis. The takeaway: The debate was never "UUID vs Integer." It was always "which UUID are you using?" Most devs are still on v4 in 2026. Upgrade your mental model. 🙂
4
2
25
26,811
PLSQL retweeted
Web development in a nutshell.
5
75
2
692
20,822
With the combination of APEX 26.1, APEXlang, and the Integrated Browser in VS Code, your AI agent can now understand .apx files, see the actual application in the browser, and even test the implementation by itself 😎 🔗 Link kuchatom.hashnode.dev/oracle… #orclAPEX #orclapexworld
5
12
644
SQLcl 26.1 introduces a new DIFF command 👀 It compares database schemas directly and generates deployment patches. Check my new article to learn more! 🔗Link kuchatom.hashnode.dev/new-sq… #orclAPEX #orclapexworld
4
27
1,151
PLSQL retweeted
Make insert-only tables in Oracle AI Database with CREATE IMMUTABLE TABLE ... ( ... ) NO DROP UNTIL m DAYS IDLE NO DELETE UNTIL n DAYS AFTER INSERT Take care with the NO clauses They control when you can delete rows or drop the table @oraclebase demos oracle-base.com/articles/23/…
5
8
1,014
How to add search and make your users more efficient? Learn how to unlock the real potential of APEX Search feature 🚀 🔗Link kuchatom.hashnode.dev/oracle… #orclAPEX #orclapexworld
4
11
503
New #DB26AI feature: V$SQL_HISTORY logs the last 60 SQL statements run on your database (so yes, during a batch, it will quickly fill those 60 slots then overwrite them etc.). So note that now anyone who can read this view can you see the SQL that YOU ran... #orclDB #DBA
6
16
1,386
PLSQL retweeted
Stop users in Oracle AI Database making any changes by marking them ALTER USER ... READ ONLY You can also restrict changes within a session with ALTER SESSION SET READ_ONLY = TRUE After setting these, any attempts to write to the database raises ORA-28194
5
1
15
706
Want your APEX apps to shine on mobile without tons of code? 🤔📱 Check out my new article: "APEX Tips for Responsive and Mobile-Friendly Apps" - native lowcode solutions to make your apps look & work smoothly on any device! 😀 #orclapex #lowcode Link: lcieslik.hashnode.dev/apex-t…
1
6
20
798
Stop guessing why a process is running on your system.
59
774
34
10,937
430,227
I’ve just published a new blog post where I walk through the alternatives to APEX_ITEM, now marked as legacy in #orclAPEX . If you're interested in declarative ways to implement row selection ☑ in APEX reports, this one is for you: aleskravos.com/apex-item-alt…
1
7
15
878
Oracle APEX now offers APIs for all Fusion pillars in the form of SQL files that can be imported into the REST Catalog in Oracle APEX—simplifying the work for APEX developers. 💪 Learn more: social.ora.cl/60187P0RM #orclAPEX
8
1
14
1,959
In PL/SQL EXCEPTION WHEN OTHERS THEN Catches all errors Filling your code with this without reraising the error hides unexpected issues So the compiler raises PLW-6009 to warn you If you reraise in custom logging procedures use PRAGMA SUPPRESSES_WARNING_6009 To skip this
8
21
1,151
Oracle Virtual Private Database enables you to transparently add WHERE clauses to restrict what users can see See what was added with DBMS_UTILITY.EXPAND_SQL_TEXT But this may expose sensitive values! @connor_mc_d shows how to hide them with contexts connor-mcdonald.com/2025/10/…
10
22
1,179
Macros in Oracle #SQL enable you to define expression templates as text At parse time the database merges these with the parent query, replacing parameters with the actual values passed Macros come in two types Scalar - use in SELECT, WHERE, ORDER BY, etc. Table - use in FROM
1
7
26
1,432
PLSQL retweeted
Brilliant move 💯
109
360
37
9,207
217,297