PLSQL @plsql

My name is Thomas. EBS / Apex Developer, BSc Mathematics, MSX computer nostalgics, etc glufke.net United States Joined March 2009

Tweets

3K
Followers

709
Following

94
Likes

4K

Tim Hall ∞🐵+∞⌨️ @oraclebase

a month ago

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

1 13 39 2K 11

Download Image

PLSQL @plsql

a month ago

Nice... Got my USA passport...

0 0 6 209 0

Download Image

PLSQL @plsql

a month ago

Trying seedr.cc So far so good! @seedrcoil

0 0 0 96 0

Tim Hall ∞🐵+∞⌨️ @oraclebase

a month ago

Nice.

0 9 29 1K 1

Download Image

0 0 6 305 0

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

0 11 31 2K 12

Download Image

PLSQL @plsql

a month ago

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

0 0 0 219 0

Download Image

Plamen Mushkov @plamen_9

2 months ago

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…

0 2 20 640 4

Download Image

SQL Daily @sqldaily

2 months ago

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

0 10 40 2K 18

Download Image

Philipp Hartenfeller @phartenfeller

2 months ago

📢 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

0 9 19 2K 2

PLSQL @plsql

2 months ago

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

0 0 1 125 1

SQL Daily @sqldaily

2 months ago

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

0 14 48 3K 15

Download Image

Denes Kubicek @DenesKubicek

2 months ago

The IR Checkbox Plugin has always been a weak spot in #orclapex. Back in 2018, we at @Kubicek_CG 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…

1 8 17 920 0

Download Image

Oracle APEX @OracleAPEX

2 months ago

🎯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:…

1 20 50 3K 21

Download Image

SQL Daily @sqldaily

2 months ago

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!

1 13 63 3K 29

Download Video

Osman DINC @InsaneDBA

3 months ago

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

0 5 8 878 5

SQL Daily @sqldaily

3 months ago

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

0 14 46 2K 29

Download Image

Oracle Developers @OracleDevs

4 months ago

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

1 7 20 2K 5

Download Image

HOW THINGS WORK @HowThingsWork_

4 months ago

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

78 2K 19K 846K 1K

Download Video

PLSQL @plsql

4 months ago

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");…