Zoran Tica
@zoran_tica
Followers
300
Following
1K
Media
62
Statuses
2K
♠ Oracle ACE Pro | Database & APEX Specialist | OCP Certified | Blogger & Conference Speaker | IT Enthusiast
Slovenia
Joined November 2017
It's fresh video content, no slides!
Previously on thatJeffSmith: Videos! Overview of our MCP Server, and a Demo!
0
3
6
How do the data types of join columns affect query performance? Dani Schnider compares using Hashes as CHAR(32) and RAW(16) Sequences as NUMBER And finds in Oracle #SQL NUMBER is faster than RAW RAW is faster than CHAR https://t.co/ht7zpEsCIX
danischnider.wordpress.com
The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema.
0
4
18
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
0
9
21
Toon is a data representation format that is optimized for usage for LLMs. With UC AI's PL/SQL package, you can convert any JSON data to the Toon format. https://t.co/304bUPaTcI
#oracle #toon #AI #orclAPEX
hartenfeller.dev
Toon is a data representation format that is optimized for usage for LLMs. With UC AI's PL/SQL package, you can convert any JSON data to the Toon format.
2
5
7
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 https://t.co/TpK6Sq09YR
connor-mcdonald.com
Since way back in version 8.1 of the database, there has been a cool feature in Oracle called Virtual Private Database (VPD), which essentially lets you force predicates into SQL statements run by …
0
10
22
I wrote about the GraphQL table function over a year ago, but in 26ai it is now in the documentation. GraphQL in Oracle Database 23ai/26ai https://t.co/zZU1dL0ENJ
@OracleDatabase #database #26ai
0
8
30
Just noticed Patch Set Bundle 24.2.11 has been release for APEX 24.2. https://t.co/ZjedpsRh8w
@OracleAPEX #orclapex
0
3
6
Relational and JSON in one model? 🤯 With Oracle Database 26ai, you can use relational tables AND JSON documents together—the same data, perfectly synced, no duplications. Learn more in this hands-on lab: https://t.co/Z6yhHU6NIK (via @pilatesdev)
1
9
22
Only one month remains to submit your abstract for the Sweet 16th edition of APEX World! 👉 Avoid last-minute rushes and send in your entry now at https://t.co/PTZR5xINj6
0
3
3
Create a flashback archive in Oracle AI Database to record all changes to a table CREATE FLASHBACK ARCHIVE ... RETENTION ... ALTER TABLE ... FLASHBACK ARCHIVE Then view the changes with SELECT * FROM ... VERSIONS BETWEEN ... @Matt_Mulvaney demos
0
10
27
🎉 Welcome to the APEX Tips! We've put together a new playlist of incredible videos produced by the experts of the APEX community. Press play and see APEX in action through the eyes of those who live and breathe technology. 🎥 Innovate. Learn. Share. https://t.co/tMC86bMJ29
0
9
24
📚 New Reading List is out! This week, we have a lot of #Oracle #Database content, #survival tips for DNS #failures, a bit of #AI and some #announcements. Happy reading! https://t.co/QZFvctSYin
geraldonit.com
📰 Surviving Regional and DNS Failures in the Cloud – Sinan Petrus Toma and Markus Michalewicz explain strategies to compensate for widespread cloud provider outages 📰 How I Think You Should C…
0
4
9
In association with Oracle we'd like to invite you to the Oracle APEX Day Netherlands. Discover how to easily integrate AI into your business data to accelerate and simplify your application development. https://t.co/14hxk2q805
#oraclAPEX #free #english
0
2
4
Join us for Oracle APEX Day in the Netherlands on December 10! ✔️Live Demos ✔️Expert Technical Talks ✔️Authentic customer stories & beyond! Register now: https://t.co/peRet1MajU
#orclAPEX #LowCode
0
8
15
Join Anton & Marwa today at 12:05 p.m. ET for a quick, practical #orclapex tip: Using Authorization Schemes to make items read-only—and even in SQL statements! #APEXInstantTips #184
https://t.co/WJ7TB2EkG2
0
3
4
🎃 Our AI Halloween tradition continues! This year's spooky tale: The Haunting of Frank What happens when your office Iron Man figure gets a little too smart? Motion sensors, glowing arc reactors & self-writing code 👻🦾 Read Frank's story: https://t.co/HaGmDRYwPo
#orclapex
0
4
6
Edition-based redefinition enables zero-downtime app upgrades for Oracle AI Database @DBoriented discusses why it's worth using when offline upgrades are OK: Any time or length upgrades Separate database & app upgrades Flexible release of new versions https://t.co/NqzS8f8U5s
db-oriented.com
So, You Don’t Need Online Upgrades EBR is a set of features that enables patching and upgrading live Oracle-based applications in an online fashion, with zero downtime. If you are responsible for an...
0
6
13