oraclewiki's profile picture. A website for IT Professionals involved with Oracle database run by Mark Ramsay.  How to Guides, SQL Scripts, Forums, News... http://www.oracle-wiki.net/

oraclewiki

@oraclewiki

A website for IT Professionals involved with Oracle database run by Mark Ramsay. How to Guides, SQL Scripts, Forums, News... http://www.oracle-wiki.net/

oraclewiki أعاد

They're here! Oracle Critical Patch Update Advisory - October 2025 oracle.com/security-alert…

oraclebase's tweet image. They're here!

Oracle Critical Patch Update Advisory - October 2025

oracle.com/security-alert…

oraclewiki أعاد

Oracle AI Database 26ai architects AI into the core of data management, enabling organizations to combine private database data with public information and gain better answers to business questions: social.ora.cl/6012A7oeM

OracleDatabase's tweet image. Oracle AI Database 26ai architects AI into the core of data management, enabling organizations to combine private database data with public information and gain better answers to business questions: social.ora.cl/6012A7oeM

oraclewiki أعاد

Great news! 🤖 Oracle ACE Rich Niemiec will be presenting at the ODTUG event "Oracle GenAI, VectorDB & Agents" on October 22. Don’t miss this opportunity to gain valuable insights into the latest in AI and database technology! Get event details and register: 🔗…

oracleace's tweet image. Great news! 🤖 Oracle ACE Rich Niemiec will be presenting at the ODTUG event "Oracle GenAI, VectorDB & Agents" on October 22. Don’t miss this opportunity to gain valuable insights into the latest in AI and database technology! 

Get event details and register:
🔗…

oraclewiki أعاد

Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai This adds the QUALIFY clause QUALIFY filters window functions after grouping Like the HAVING clause does for aggregate functions SELECT ... FROM ... QUALIFY fn OVER ( ... ) > ...

sqldaily's tweet image. Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai

This adds the QUALIFY clause

QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions

SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...

oraclewiki أعاد

Find us today at 10:15am at Marco Polo 806 level 1 for Upgrade to Oracle AI Database 26ai at Oracle AI World 2025 - your chance to learn about the news and the new release numbering. Don't miss it! reg.rf.oracle.com/flow/oracle/oc…

MikeDietrichDE's tweet image. Find us today at 10:15am at Marco Polo  806 level 1 for 

Upgrade to Oracle AI Database 26ai

at Oracle AI World 2025 - your chance to learn about the news and the new release numbering. 

Don't miss it!

reg.rf.oracle.com/flow/oracle/oc…

oraclewiki أعاد

Holographs 🤝 Agentic AI Watch Kay Malcolm take a deep dive into agentic AI at Data Deep Dive. #AIWorld


oraclewiki أعاد

Are you prepared for GoldenGate 23ai’s evolution? Don’t miss our ACE Live event where we cover migration tips & new capabilities! ⏰ Set a reminder for October 22, 7am PT. 🔗 social.ora.cl/6016A5WZs

oracleace's tweet image. Are you prepared for GoldenGate 23ai’s evolution? 
Don’t miss our ACE Live event where we cover migration tips & new capabilities!
⏰ Set a reminder for October 22, 7am PT.
🔗 social.ora.cl/6016A5WZs

oraclewiki أعاد

🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️ Are you a technology expert or an Oracle enthusiast, but new to sharing your knowledge? The ACE Apprentice level is designed to kickstart your journey…

oracleace's tweet image. 🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️ 

Are you a technology expert or an Oracle enthusiast, but new to sharing your knowledge? The ACE Apprentice level is designed to kickstart your journey…

oraclewiki أعاد

🚀 Oracle AI Database 26ai officially launched at Oracle #AIWorld 2025. 🔸 Seamless AI integration 🔸 New Oracle Autonomous AI Lakehouse 🔸 Quantum-resistant encryption, built-in security & more 🔗 bit.ly/46XOAEk #oracle26ai


oraclewiki أعاد

The Oracle AI Database 26ai Free is available now🔥 I'm currently reading the release notes 🤓 And you? #Oracle #AIWorld

moreaux_louis's tweet image. The Oracle AI Database 26ai Free is available now🔥 

I'm currently reading the release notes 🤓 And you?

#Oracle #AIWorld

oraclewiki أعاد

Oracle AI Database 26ai Free available for download. oracle.com/database/free/… I've done my first install.

oraclebase's tweet image. Oracle AI Database 26ai Free available for download.

oracle.com/database/free/…

I've done my first install.

oraclewiki أعاد

Define which prior rows to include in window functions with ORDER BY ... [ frame ] ... PRECEDING The frame states which sort keys to include (UNBOUNDED = all) ROWS - Strict row count RANGE - Logical value offset; only valid for numbers & datetimes GROUPS - Unique values count

sqldaily's tweet image. Define which prior rows to include in window functions with

ORDER BY ... [ frame ] ... PRECEDING

The frame states which sort keys to include (UNBOUNDED = all)

ROWS - Strict row count
RANGE - Logical value offset; only valid for numbers & datetimes
GROUPS - Unique values count
sqldaily's tweet image. Define which prior rows to include in window functions with

ORDER BY ... [ frame ] ... PRECEDING

The frame states which sort keys to include (UNBOUNDED = all)

ROWS - Strict row count
RANGE - Logical value offset; only valid for numbers & datetimes
GROUPS - Unique values count

oraclewiki أعاد

🌟 Experience Oracle innovation first-hand! Watch, learn, and interact with over 30 ACE experts this week at #OracleAIWorld. Whether you’re new or seasoned, there’s a session for you! Don’t wait—register now. ♠️ social.ora.cl/6011AuUHH #OracleACE

oracleace's tweet image. 🌟 Experience Oracle innovation first-hand! Watch, learn, and interact with over 30 ACE experts this week at #OracleAIWorld. Whether you’re new or seasoned, there’s a session for you! Don’t wait—register now. ♠️ 
social.ora.cl/6011AuUHH
#OracleACE

oraclewiki أعاد

It’s time to see Oracle Database and AI in action! This week, dive straight into the heart of AI in Oracle Database at Oracle #AIWorld with Hands-on Labs and Live Demos. Learn more at social.ora.cl/6014AiqkA


oraclewiki أعاد

Oracle Database 21c enhanced FOR LOOPs in PL/SQL to enable you to use Custom increments (BY) Lists of values to loop through Conditions to skip the loop body (WHEN) Expressions to set the next value (REPEAT WHILE) Mutable iterands to set their value inside the loop (MUTABLE)

sqldaily's tweet image. Oracle Database 21c enhanced FOR LOOPs in PL/SQL to enable you to use

Custom increments (BY)

Lists of values to loop through

Conditions to skip the loop body (WHEN)

Expressions to set the next value (REPEAT WHILE)

Mutable iterands to set their value inside the loop (MUTABLE)

oraclewiki أعاد

Get hands-on at Oracle AI World next week! Attend technical labs, customer success stories, and integration best practices delivered by elite Oracle ACEs. See why this event is a must-attend for tech professionals. ♠️ 👉 social.ora.cl/6010AuURG #OracleACE

oracleace's tweet image. Get hands-on at Oracle AI World next week! Attend technical labs, customer success stories, and integration best practices delivered by elite Oracle ACEs. 
See why this event is a must-attend for tech professionals. ♠️ 👉 
social.ora.cl/6010AuURG
#OracleACE

oraclewiki أعاد

The Oracle ACE community is home to a diverse group of experts who actively shape the future of analytics, data management, and emerging technologies. In this edition of ACE Voices, we showcase insights and practical resources from Oracle ACEs worldwide, covering hot topics…

oracleace's tweet image. The Oracle ACE community is home to a diverse group of experts who actively shape the future of analytics, data management, and emerging technologies. In this edition of ACE Voices, we showcase insights and practical resources from Oracle ACEs worldwide, covering hot topics…

oraclewiki أعاد

♠️ Message for all ACEs ♠️ Our next Oracle ACE Program update meeting is scheduled for October 8, 8:00 am PT! Hear from our guest speakers @sabinacornovac, @Iulia_Stanescu_, and Oracle ACE Director Julio Lois. 🎉 We're hosting an additional session from 4:00 pm PT, in case you…

oracleace's tweet image. ♠️ Message for all ACEs ♠️ 
Our next Oracle ACE Program update meeting is scheduled for October 8, 8:00 am PT! Hear from our guest speakers @sabinacornovac, @Iulia_Stanescu_, and Oracle ACE Director Julio Lois. 

🎉 We're hosting an additional session from 4:00 pm PT, in case you…

oraclewiki أعاد

You can subtract one year from a date in Oracle #SQL with either ADD_MONTHS ( dt, -12 ) - INTERVAL '1' YEAR But take care - these handle 29th Feb differently: ADD_MONTHS => 29th Feb -> 28th Feb in previous year INTERVAL => 29th Feb -> 29th Feb in previous year => error!


Loading...

Something went wrong.


Something went wrong.