APEX gurus: Anybody knows why I cannot use the event "apexafterrefresh" with an Interactive Grid ? (It only works for other types of regions). apex.jQuery( "body" ).on( "apexafterrefresh", function() { console.log("This will never be triggered by Interactive Grid");

Just like the first rule of coding: "If it works don't touch it" 😂

Check out this step-by-step guide addressing suspended workflows in Oracle APEX post- deployment. #orclAPEX social.ora.cl/60192xXaP

Is it possible to deploy an Oracle Autonomous Database on your laptop with a management interface like OCI? Yes. Here it is. dincosman.com/2025/06/18/dep… #Oracle #AutonomousDatabase #OracleATP #Docker #OracleDeveloper #DevOps #OracleCloud #DatabaseActions #ORDS #SQLcl #DB

Find the bottlenecks in PL/SQL code with the hierarchical profiler DECLARE DBMS_HPROF.CREATE_TABLES (); id := DBMS_HPROF.START_PROFILING; <code> DBMS_HPROF.STOP_PROFILING; DBMS_HPROF.ANALYZE ( id, report_clob => html ); END; Enhanced in 18c to store trace data in tables

Delete data fast with a filtered table move from Oracle Database 12.2 ALTER TABLE ... MOVE INCLUDING ROWS WHERE <condition> This discards rows where the condition is not true This can remove lots of data faster than DELETE Note this is DDL, so you can't roll it back!

The IR Checkbox Plugin has always been a weak spot in #orclapex. Back in 2018, we at Kubicek Consulting GmbH created a plugin that has been running without updates needed. It’s the Duracell of plugins, so to say. Check it out: 🔗 kubicek-consulting.de/oracle-apex/ir… Download: 🔗 apex.world/ords/r/apex_wo…

🎯Ready… Set… CERTIFY! 🏁 The Oracle APEX Cloud Developer Professional Certification is now 100% FREE! 💥 Flex those low-code muscles, finish the courses, and show the world you've got what it takes. 🏆 ✔ Register now: social.ora.cl/60164YnDa ✔ Read more about the promo:

Oracle Database 21c enhanced analytic functions to support GROUPS, EXCLUDE, & the WINDOW clause: fn ( ... ) OVER ( <w> GROUPS ... EXCLUDE ... ) ... WINDOW <w> AS ( ... ) GROUPS => rows with the same sort key are in the same group EXCLUDE => omit the current or adjacent rows

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('

📢 dbLinter is officially in free preview! Get automated quality checks for your #oracle #plsql code right in VS Code. Customize rules, severities, and naming conventions in our app. Watch it in action: youtu.be/V-ePBfUFhhk #dbLinter #orclAPEX #VSCode

Stop long-running #SQL statements from Oracle Database 18c with ALTER SYSTEM CANCEL SQL '<sid>, <serial#>' To ensure the next statement runs, you can pass the SQL ID of the statement to stop - in case it finishes first! ALTER SYSTEM CANCEL SQL '<sid>, <serial#>, <sql_id>'

A note to myself, because it's not so easy to find this (even using AI): ✨An easy way to set the APP_USER to be lowercase (or whatever you like), and not UPPERCASED as it is by default: 1. Create Post-Authentication Procedure in your Authentication Scheme 2. Use it 3. Verify

You can practice making calculations on a watch with dial here: glufke.net/dial/ -> Just click or drag the dial... That watch is a Citizen Navihawk JY8035-04E

Run bit AND, OR, and XOR operations across numbers in Oracle #SQL using BIT_AND_AGG BIT_AND_AND BIT_AND_OR functions from 21c These convert numbers to binary, then do bitwise comparisons across rows 3 => 011 5 => 101 3 AND 5 => 001 => 1 3 XOR 5 => 110 => 6 3 OR 5 => 111 => 7

Nice.

Trying seedr.cc So far so good! Seedr Official

Nice... Got my USA passport...

Non-Positional INSERT INTO SET and INSERT INTO BY NAME Clauses in Oracle Database 23ai oracle-base.com/articles/23/no… Oracle Database #database #23ai

😎