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

713
Following

74
Likes

4K

PLSQL @plsql

a week ago

If you have a watch that syncs daily with Atomic Time and you live in a place of the world with no reception, you could build your own antenna with a raspberry pi and start syncing daily... GitHub Project: github.com/apoluekt/raspb…

0 0 1 41 0

Download Image

Philipp Hartenfeller @phartenfeller

2 weeks ago

New blog post, my longest one ever. A full guide on how to use AI as a PL/SQL developer. - No 23ai or Python required - Advanced techniques like tools, structured output, reasoning, and file analysis - Usage demos hartenfeller.dev/blog/real-ai-s… #oracle #ai #orclAPEX

3 27 51 2K 23

PLSQL @plsql

2 weeks ago

Question ORACLE APEX: * Have you guys used the SESSION in a cookie instead of having it the URL? * Was there any problem with that ?

0 0 0 44 0

Tim Hall ∞🐵+∞⌨️ @oraclebase

2 months 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

2 months ago

Nice... Got my USA passport...

0 0 6 240 0

Download Image

PLSQL @plsql

2 months ago

Nice.

Tim Hall ∞🐵+∞⌨️ @oraclebase

2 months ago

Nice.

0 9 29 1K 1

Download Image

0 0 6 325 0

SQL Daily @sqldaily

2 months ago

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

2 months 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 241 0

Download Image

Plamen Mushkov @plamen_9

3 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 657 4

Download Image

SQL Daily @sqldaily

3 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 39 2K 18

Download Image

Philipp Hartenfeller @phartenfeller

3 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

3 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 132 1

SQL Daily @sqldaily

3 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 47 3K 16

Download Image

Denes Kubicek @DenesKubicek

3 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 937 0

Download Image

Oracle APEX @OracleAPEX

3 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

3 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 30

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