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)
I voted
1
34
#orclapex 26.1 A native "menu button" is now possible - even the little things are helpful.
2
4
12
504
Oracle Apex 26 --> What happened to the "COPY TO ANOTHER PAGE" ? It looks like it was removed in Apex 26 :-D Below, how it was before the "upgrade". :-(
1
2
264
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
Linux Mint with Kernel 7.0.0-28 + Oracle Virtual Box = Kernel Panic (below, it's just a picture I took from my phone). After uninstalling Virtual Box, Linux Mint is back. :-/
1
1
2
313
APEX 26.1 - Generative AI in Interactive Grid: For some reason, it can create the filter but it doesn't APPLY the filter. Do you guys have any idea?
2
181
NOT interactive grid ---> Interactive REPORT.
30
Here is another example. I created the >300 filter manually. I asked AI to change it to 400 and it can understand it... But it doesn't apply the new config:
40
Using SQL Developer in Linux Mint: * Installs with no issues. * CPU goes to 100% * Try many differend things. NOTHING. * Install JDK 21, 17, hack the product.conf, etc.. SOLVED. * Cursor missing sometimes. Tried many things. Solution: * Install SQL Developer through WINE :-(
1
119
Query Link: teapawt.net/plsql/status/194123446… Happy 250 Years USA!
Happy 4th of July ! with l as ( select rownum r from all_tables where rownum <= 16 ) , s as (select rpad(' ', 25, '* ') t from dual) select case when r>9 then decode( mod(r,2),1, trim(rpad(' ', 67, '=')) , ' ') when mod(r,2)=0 then s.t else ' * '||trim(s.t) || rpad(' ',40,'=') end HAPPY_4TH_OF_JULY from l,s
1
83
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
Nice blog about APEXlang by ACE Jonathan Dixon: blog.cloudnueva.com/the-anat…
1
1
133
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
It looks like Oracle only has version 4 of UUID. youtu.be/JbdvmQ_HgJo?si=DQex…
95