Zach Hudock

[Allen Holub. https://linkedIn.com/in/allenholub @allenholub]

<rant> A periodic reminder that Sprints, Backlogs, Daily Scrums, Scrum Boards, Scrum Masters, Product Owners, Points, Velocity, PIs, etc., have NOTHING AT ALL to do with "Agile." Agility comes from working small, delivering frequently for feedback from actual customers, and adapting based on that feedback. It has to do with teams working in whatever way they see fit to get stuff into the customer's hands as quickly as possible and acting on the feedback without bureaucratic obstacles. Any way that you can accomplish that is fine. All that garbage I listed in the first sentence just gets in your way.</rant>

[Philipp Hartenfeller @phartenfeller]

Next week, @kevinthyssen and I are doing our APEX Security Basics session in a webinar. This was awarded best APEX KScope25 session. No sign-up required; links in reply.
#orclAPEX

[Connor on SQL and Database @connor_mc_d]

Fresh video! Want to run MERGE in parallel for your massive partitioned tables? There is a little bit of nuance required to make sure you get the performance you want.
https://t.co/H8zZlKOZPV

[that Jeff Smith @thatjeffsmith]

Great database design tips from @NickHodges

https://t.co/Oqe1rI61aq

[that Jeff Smith @thatjeffsmith]

Previously on thatJeffSmith: Best Practices: REST APIs for your Database {Draft!} https://t.co/0jFFscKopP

[Ask This Old House @AskTOH]

🛠️ Squeaky floors driving you crazy? Here’s how to silence those pesky creaks and get back to peaceful steps. #HomeImprovement #DIY
https://t.co/Kc9KygFgY8

[Plamen Mushkov @plamen_9]

Another note to myself - you only need 2-3 lines of CSS to adjust the width and padding of your Oracle APEX app content area. Lots of CSS variables yet to explore and lots of hidden gems yet to find.

So, to adjust the padding on mobile/desktop and the maximum width of the content area, all you need is to set these 3 CSS variables:

:root {
--ut-body-content-padding-x: 8rem;
--ut-xs-body-content-padding-x: 1rem;
--ut-body-content-max-width: 1000px;
}

🔸 --ut-body-content-padding-x and --ut-xs-body-content-padding-x are not set in the Universal Theme, but are ready for use in case you set them with a value. If they are not set, UT uses a default value, like in this case: padding-inline-end: var(--ut-body-content-padding-x, 1rem);
Here, the padding will be 1rem if you don't set a value for --ut-body-content-padding-x.

🔸 It is easy to see that in the Browser Dev tools - all the CSS variable that don't have a value set, are in grey colour. The ones that have a value are in blue and are clickable. Once you click on the value, you see the original place where it is set in your CSS files.

#orclAPEX

[Matt Mulvaney @Matt_Mulvaney]

🚀 New Blog for #orclapex
Learn how to extract every part of an Oracle APEX URL in JavaScript. Supports classic &amp; friendly URLs, parameters, and more.
Check it out: https://t.co/TKL8O8y7St

[Plamen Mushkov @plamen_9]

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 your APP_USER is in the desired case

#orclAPEX

[SQL Daily @sqldaily]

Fed up with other developers overwriting your changes when working in a shared #database?

Prevent this with Oracle Loki

This #oracleapex app enables you to lock objects, so only one person can change them at a time

@r_grzegorczyk demos https://t.co/uVGJePPrVQ

[SQL Daily @sqldaily]

Materialized views (MVs) store the results of a query

The challenge is keeping them up-to-date

@Killianlynchh shows how real-time (ON QUERY COMPUTATION) MVs in Oracle Database can give current results by applying changes to out-of-date MVs

https://t.co/l4dsyjmK3d

[SQL Daily @sqldaily]

Oracle Edition-Based Redefinition allows many copies of PL/SQL objects in the database

@jasminfluri covers two use cases for this

Zero-downtime deployments
Multiple applications using the same database

And covers what you need to know to use it https://t.co/XWxhc4lP91

[SQL Daily @sqldaily]

Real-Time #SQL Monitoring in Oracle Database lets you see the progress of plans as the query runs

View the report for a statement with

SELECT dbms_sql_monitor.report_sql_monitor ( sql_id =&gt; :sql_id )

For full details see this guide by @uschwinn https://t.co/iyoPTBofC4

[Ask This Old House @AskTOH]

🔧 Want table saw precision with your circular saw? @TomSilvaTOH explains how to build a homemade track saw:

[Tim Hall ∞🐵+∞⌨️ @oraclebase]

Oracle REST Data Services (ORDS) : Authentication Enhancements (ORDS_SECURITY and ORDS_SECURITY_ADMIN Packages)

https://t.co/iSXEhwGpxk

@OracleREST

[krisrice 🏒🍺📷 @krisrice]

Be sure to sign up. This one is huge &gt; Introducing SQL Developer Copilot Integration in @code and @MCP_Community Support for Oracle Database.
https://t.co/aGKVuks4hX

[SQL Daily @sqldaily]

Find the bottlenecks in PL/SQL code with the hierarchical profiler

DECLARE
DBMS_HPROF.CREATE_TABLES ();

id := DBMS_HPROF.START_PROFILING;
&lt;code&gt;
DBMS_HPROF.STOP_PROFILING;

DBMS_HPROF.ANALYZE ( id, report_clob =&gt; html );
END;

Enhanced in 18c to store trace data in tables

[Kamil Rybicki @rybicki_k]

Have you ever wondered how to create a dynamic number of Oracle APEX charts based on a SQL query?

If so, check out my latest blog where I show how to build flexible visualisations using Cards region + Oracle JET.

https://t.co/cz26WA7v3e

#orclAPEX

[United Codes @united_codes]

🚀 NEW VIDEO ALERT! 🚀

JavaScript for #orclapex developers - Accessing Page Items is now LIVE!

Whether you're just starting or looking to level up your JS skills, @phartenfeller breaks down how to access page items using JS in clear, simple steps.

https://t.co/ap28L9Hg8x

[krisrice 🏒🍺📷 @krisrice]

Because everyone needs more side projects. Thanks? to @DougAGault for asking. Here's a start of a @code extention for Quick SQL.
https://t.co/WIeRAEapjb