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

813
Followers

129
Following

343
Likes

5

Oracle Database @OracleDatabase

23 hours ago

Oracle Data Deep Dive at #AIWorld is bringing you the latest innovations in Oracle Database 23ai, including GenAI, Vector Search, and machine learning features to help you create and deploy AI-driven applications in your enterprise. See the sessions at social.ora.cl/6018Ad9AI

1 3 7 869 1

Download Image

Oracle Database @OracleDatabase

5 days ago

Realize your AI goals with Oracle Database 23ai. Learn about Agentic AI, Vector Search, App Dev, and the cool things users are doing today. Secure your spot now at social.ora.cl/6014AjX6e

0 6 9 2K 1

Download Video

SQL Daily @sqldaily

6 days ago

Create blockchain tables in Oracle Database with CREATE BLOCKCHAIN TABLE ... ( ... ) NO DROP UNTIL n DAYS IDLE NO DELETE UNTIL n DAYS AFTER INSERT HASHING USING SHA2_512 VERSION "v1" These Allow INSERT Disallow UPDATE Disallow DELETE/DROP until you wait N days as defined

0 13 30 1K 9

Download Image

Oracle Database @OracleDatabase

6 days ago

Oracle Data Deep Dive at #AIWorld is the go-to place for data scientists and engineers! Our expert-led sessions will show you how to build, deploy, and optimize AI and data-driven solutions with integrated AI-assisted tools for model development, vector search, and real-time…

0 3 6 962 0

Download Image

Oracle University @Oracle_Edu

6 days ago

Oracle Race to Certification 2025 social.ora.cl/6016AjHzi now has over 700,000 learners taking free training and certification exams in AI, OCI, Multicloud, and Data. This momentum demonstrates a global commitment to upskilling and the value of continuous learning. Professionals…

1 5 16 815 4

Download Image

Oracle Database @OracleDatabase

7 days ago

1 5 6 1K 1

Download Image

SQL Daily @sqldaily

a week ago

Combine rows by value in #SQL with GROUP BY col And this returns one row for each value in col You can then use aggregate functions to get totals for the rows in each group, e.g. COUNT - number of rows AVG - numeric mean MIN/MAX - smallest/largest LISTAGG - list of values

0 7 28 1K 8

Download Image

SQL Daily @sqldaily

a week ago

The NVL function in Oracle #SQL returns The 1st argument if it's non-null Otherwise the 2nd argument Use it like so WHERE col = NVL ( :var, col ) And the plan can use an index if :var is non-null & a full table scan if it is @monika_mitura demos how2ora-en.blogspot.com/2025/09/the-ma…

1 8 23 1K 4

Oracle ACE Program @oracleace

a week ago

Thank you so much to all our ACEs who joined us today for a product overview session presented by @SinanPetrus - Next-Level Resilience: Oracle MAA and HA Strategies on Oracle Database in Multicloud. See you again soon! ♠️ #OracleACE

0 2 18 408 0

Download Image

Oracle Database @OracleDatabase

a week ago

Don’t miss the security sessions at Oracle Data Deep Dive at #AIWorld that help you keep your business-critical data safe from cyber threats, ransomware attacks, and data breaches while simplifying compliance. Register now: social.ora.cl/6011AkUSh

0 4 9 963 1

Download Image

Oracle Database @OracleDatabase

a week ago

Catch Hasan Rizvi’s keynote at Oracle Data Deep Dive at #AIWorld to learn more about Oracle Database 23ai and how it can help you innovate faster with AI, scale smarter, and sleep easier. Register now: social.ora.cl/6013AThAD

2 7 12 2K 1

Download Image

Oracle ACE Program @oracleace

a week ago

Don’t miss your chance to connect with Oracle’s top experts at AI World! The Oracle ACE community is bringing curated sessions on everything from AI in APEX to cloud cost optimization. Plus, join us in the ACE Lounge to network and grab exclusive giveaways! Check out the ACE…

0 2 6 247 0

Download Image

Oracle ACE Program @oracleace

a week ago

🌏 The community asked, we delivered—introducing ACE Live! Our new external webinar series spotlights leading voices in Oracle technology, with actionable insights for tech leaders at every level. All sessions are free! Check it out: social.ora.cl/6015AH2qU #OracleACE

0 2 7 277 0

Download Image

layla @pilatesdev

3 weeks ago

Shout out to the @Oracleace program at @Oracle for the awesome new swag - even my little guy is a fan! 😊🧢

10 1 228 10K 8

Download Image

SQL Daily @sqldaily

2 weeks ago

Take care when filtering the INNER table in OUTER JOINs e.g. the right table in a LEFT OUTER JOIN Do this in the WHERE clause => it's an INNER JOIN To preserve the OUTER JOIN, filter the inner table in the ON clause The pic shows outer joins ON number col with inner filters

1 12 28 1K 13

Download Image

Oracle ACE Program @oracleace

2 weeks ago

With Oracle AI World just around the corner, now is the time to secure your spot and dive deep into the latest innovations in Oracle technology. This year, we’re thrilled to highlight a special lineup of sessions led by Oracle ACEs, so explore the Oracle ACE sessions agenda ♠️…

0 5 10 491 0

Download Image

SQL Daily @sqldaily

3 weeks ago

Oracle Database 23.9 added non-positional inserts This assigns values to columns in the SET clause (like UPDATE) INSERT INTO employees SET employee_id = 210, first_name = 'Gerald', ... @GeraldVenzl dives into the details and gives the backstory in geraldonit.com/non-positional…

1 11 31 2K 12

SQL Daily @sqldaily

4 weeks 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 25 1K 11

Download Image

Oracle ACE Program @oracleace

2 months 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…