oraclewiki @oraclewiki

A website for IT Professionals involved with Oracle database run by Mark Ramsay. How to Guides, SQL Scripts, Forums, News... https://t.co/03YERqlO6E oracle-wiki.net Joined October 2010

Tweets

796
Followers

129
Following

344
Likes

5

SQL Daily @sqldaily

2 days ago

Get values from the previous or next row in #SQL with <fn> ( val ) OVER ( ORDER BY ... ) Where <fn> is either LAG - previous LEAD - next By default these look one row forward/back Use the second parameter to get the value from N rows before/after the current

0 8 23 1K 11

Download Image

Oracle ACE Program @oracleace

a month ago

Join us in welcoming Ashley Mentele as a new ACE Associate from the United States! Ashley helps clients maximize the value of their Oracle solutions, with a focus on Account Reconciliation, Financial Consolidation and Close, and Narrative Reporting. She loves to share her…

1 2 8 332 0

Download Image

Tim Hall ∞🐵+∞⌨️ @oraclebase

a month ago

Materialized Virtual Columns (Expression Columns) in Oracle Database 23ai oracle-base.com/articles/23/ma… @OracleDatabase #database #23c

0 8 33 1K 4

Download Image

Tim Hall ∞🐵+∞⌨️ @oraclebase

a month ago

You don’t have to wait for 23ai for these features! oracle-base.com/blog/2025/08/0… @OracleDatabase #database #19c

1 16 42 2K 13

Download Image

Oracle ACE Program @oracleace

a month ago

Happy #WorldWideWebDay! 🌐 Today we celebrate the incredible impact of the World Wide Web—connecting people, ideas, and opportunities across the globe since 1989. #WWWDay

0 2 7 283 0

Download Image

Tim Hall ∞🐵+∞⌨️ @oraclebase

a month ago

GROUP BY ALL in Oracle Database 23ai oracle-base.com/articles/23/gr… @OracleDatabase #database #23ai

0 9 29 1K 1

Download Image

SQL Daily @sqldaily

a month ago

Convert GeoJSON to Oracle Spatial objects and back with SDO_UTIL.FROM_GEOJSON SDO_UTIL.TO_GEOJSON This enables you to use spatial functions on JSON data e.g. to find the distance between two points

0 8 24 1K 8

Download Image

Oracle Database @OracleDatabase

a month ago

"Oracle Database can now be used directly by AI assistants via the Model Context Protocol (MCP). Oracle is integrating the technology into its command-line tool SQLcl to provide database connectivity to any AI assistant that supports MCP." Read the Techzine article:…

1 22 69 6K 16

Oracle ACE Program @oracleace

2 months ago

Thank you for joining us today for our July 2025 Oracle ACE Program Update Meeting! We had a lot of exciting updates from our guests, and over 80 ACEs joined us for our monthly meeting! It's always great seeing the community get together! ♠️ #OracleACE

0 3 19 525 0

Download Image

Oracle Database @OracleDatabase

2 months ago

AWS enterprise users now get all the benefits of Oracle Autonomous Database, with higher availability, rolling updates with no interruptions, and fully automated Data Guard failover. Learn more at social.ora.cl/60174INQd

1 2 12 2K 1

Download Image

SQL Daily @sqldaily

2 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 48 3K 15

Download Image

SQL Daily @sqldaily

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

Download Video

SQL Daily @sqldaily

2 months ago

Initialise arrays in PL/SQL with FOR loops inside type constructors from 21c array_var := array_type ( FOR i IN ... => val ) The loop can iterate through: A range of values ( FOR i IN min .. max => ... ) A cursor ( FOR rws in (SELECT ...) => ... )

0 13 58 2K 23

Download Image

SQL Daily @sqldaily

2 months ago

Oracle Database excludes wholly NULL rows from B-tree indexes => WHERE col IS NULL Won't use an index on COL Overcome this by including a constant in the index CREATE INDEX ... on ... ( col, 1 ) => Every row is indexed Bitmap indexes do include nulls but are unfit for OLTP

2 13 43 2K 22

Download Video

Oracle ACE Program @oracleace

2 months ago

♠️ Message for all ACEs ♠️ Our next Oracle ACE Program update meeting is scheduled for June 26, 9:00 am PT! Looking forward to seeing you soon! #OracleACEs

0 5 14 482 0

Download Image

Oracle Database @OracleDatabase

3 months ago

Find out how the Oracle Database Engineering team is using AI to explain and test tens of millions of lines of code. Learn more about the latest Oracle Database technology at social.ora.cl/60184M974.

0 3 5 1K 0

Download Video

S.E. Robinson, Jr. @SERobinsonJr

3 months ago

xAI NEWS: Oracle has announced a partnership with xAI to deliver Grok 3 models through the Oracle Cloud Infrastructure (OCI) Generative AI service for content creation, research, and business process automation. OCI will enhance Grok 3 with enterprise-grade data governance,…

325 1K 5K 1.9M 365

Download Image

SQL Daily @sqldaily

3 months ago

Change the contents of #JSON in Oracle Database with JSON_TRANSFORM ( <json_doc>, <op1>, <op2>, ... ) This enables you to add, change, remove or rename attributes matching a path Available from 21c and backported to 19.10

0 9 29 2K 10

Download Image

Oracle Database @OracleDatabase

3 months ago

DatabaseWorld: Multicloud AI Edition – a virtual event where you can learn about the latest Oracle innovations in Data and AI, and how to gain the most value from them. Learn more at social.ora.cl/60144EbwQ.

0 4 11 1K 0

Download Image

Oracle ACE Program @oracleace

3 months ago

Thank you for joining us for the June Oracle ACE Product Overview Session on Oracle GDS: The Secret Sauce to Make Database High-Availability Come Alive! with Ravi Sharma, Senior Principal Product Manager. #OracleACE