你可能會喜歡
I’ve just published a new blog post where I walk through the alternatives to APEX_ITEM, now marked as legacy in #orclAPEX . If you're interested in declarative ways to implement row selection ☑ in APEX reports, this one is for you: aleskravos.com/apex-item-alte…
Good reading ...
More great advice about why to use views in #orclapex from Jon Dixon (bsky.app/profile/jon.cl…) Bonus: a peek at the power of SQL macros at the end. blog.cloudnueva.com/importance-of-…
Oracle APEX now offers APIs for all Fusion pillars in the form of SQL files that can be imported into the REST Catalog in Oracle APEX—simplifying the work for APEX developers. 💪 Learn more: social.ora.cl/60187P0RM #orclAPEX
In PL/SQL EXCEPTION WHEN OTHERS THEN Catches all errors Filling your code with this without reraising the error hides unexpected issues So the compiler raises PLW-6009 to warn you If you reraise in custom logging procedures use PRAGMA SUPPRESSES_WARNING_6009 To skip this
Oracle Virtual Private Database enables you to transparently add WHERE clauses to restrict what users can see See what was added with DBMS_UTILITY.EXPAND_SQL_TEXT But this may expose sensitive values! @connor_mc_d shows how to hide them with contexts connor-mcdonald.com/2025/10/15/sec…
Hi Oracle Apex Gurus !!! I opened this thread in Apex Forum, and it seems to be a BUG: forums.oracle.com/ords/apexds/po… Do you guys know the best way to log a bug? So far, there's no solution for this issue. THANKS !!!!
Macros in Oracle #SQL enable you to define expression templates as text At parse time the database merges these with the parent query, replacing parameters with the actual values passed Macros come in two types Scalar - use in SELECT, WHERE, ORDER BY, etc. Table - use in FROM
Quick Linux tip: Got log files compressed as .gz? You don’t need to extract them to read or search through the content. Use the 'z' tools directly: • zcat - view the file • zless - scroll through it • zgrep - search inside it • zegrep - search with extended regex •…
People ask: “Yuan, how did you get so good at Oracle?” My secret: the Database Concepts book. I’ve read it over and over since 9i, even printed the PDF and kept studying. If you want to master Oracle, start there. Drop a like if you agree. #Oracle #OracleACE
youtu.be/DWsZ-rNxJd0 How to Read Oracle AWR Report – The Header #Oracle #OracleACE #AWR
youtube.com
YouTube
How to Read Oracle AWR Report – The Header
Quick Linux tip: In Linux, the pipe(|) operator is very useful if you want to redirect the output of one command to serve as input to the next for further processing: $ cat data.txt | grep "No such file" However, this does not redirect the errors. So, if the file does not…
Got unaggregated columns you want to include in the SELECT list, but not the GROUP BY? You can use ANY_VALUE, e.g.: SELECT c1, ANY_VALUE ( c2 ), COUNT ... FROM ... GROUP BY c1 This returns the value from a random row (it's optimized to return the first) => non-deterministic
Database triggers often contain auditing or other security logic So stopping bad actors from disabling triggers is vital @petefinnigan shows how in Oracle Database: Create an AFTER DDL ON DATABASE trigger Check ALTER TRIGGER statements for DISABLE petefinnigan.com/weblog/archive…
United States 趨勢
- 1. The Jupiter 450K posts
- 2. FINALLY DID IT 646K posts
- 3. Ferran 12.3K posts
- 4. Texas Tech 8,030 posts
- 5. The Rock 44.4K posts
- 6. #big12championship N/A
- 7. Cherki 39K posts
- 8. Europe 405K posts
- 9. The EU 501K posts
- 10. #MeAndTheeSeriesEP4 1.88M posts
- 11. Kohler N/A
- 12. Bob Nightengale N/A
- 13. LJ Martin N/A
- 14. Roony 6,817 posts
- 15. Zac Gallen 1,094 posts
- 16. Coen Carr N/A
- 17. #WaitingForYouBTS 1,671 posts
- 18. BDAY 27.4K posts
- 19. Cinnabon 11.5K posts
- 20. Ernie Johnson N/A
你可能會喜歡
-
Portilho
@rportilhoproni -
Marcus Vinicius
@viniciusdba -
Ask TOM for Database/SQL
@OracleAskTOM -
Franck Pachot
@FranckPachot -
Kent Graziano
@KentGraziano -
Oracle ACE Program
@oracleace -
Victor Armbrust
@varmbrust -
Alex Zaballa
@alexzaballa -
Franky Weber Faust ♠
@frankyweber -
Scott Spendolini🍊
@sspendol -
Oracle Brasil
@oracledobrasil -
Talan - Oracle Technologies (formerly Insum)
@TalanOracleTech -
Gwen (Chen) Shapira
@gwenshap -
Tim Hall ∞🐵+∞⌨️
@oraclebase
Something went wrong.
Something went wrong.