Roger Troller

ACT Pyrenees - Day 1

SQuizL 23-MAY-24 1/6 guesses 39 seconds 🟩🟩🟦🟩🟩🟩🟦 bit.ly/SQuizL-game #SQuizL #SQL Enum-Annotations ... new with the latest 23ai Release. Looking good

Analytic views are still a powerful feature in the @OracleDatabase. It’s sad that almost nobody uses them. Perhaps that changes after @kibeha‘s presentation at #DOAG2023

@dani_schnider @OracleDatabase i have to get used to not using it anymore … will take some time … months or years 😇

CEIL and FLOOR on date and timestamp is one of the nice little features in @OracleDatabase 23c - but why does @RogerTroller use „from dual“ in his examples? 😉 #DOAG2023

Dani Schnider@DOAG looking forward to his presentation

@Andrej_SQL @DOAGeV see you there ...

Wow! The next few months are likely to be a bit busy for me! Thank you @DOAGeV for accepting 3 of 3 abstracts for the #DOAG2023 conference! See you in Nuremberg again! (it will be my first onsite conference since #DOAG2019 🥳)

Join us in congratulating @RogerTroller for becoming our newest Oracle ACE Director! Roger has been working with Oracle database since 1990 & an active member of the program for many years. Thank you for your recommendation, @Loic__Lefevre! social.ora.cl/6019O2Zjb #OracleACE

@phsalvisberg ALTER SESSION SET group_by_position_enabled=TRUE;

I've installed Oracle Database 23c Free in a Docker container. Works like a charm. However, has anyone an idea why group by column position does not work in the example below? Have I misunderstood the new feature? See docs: #GUID-3C11D3A9-8B14-4DCC-B212-B7FE57EE81E8__GUID-9E2CDE0A-5A5C-4964-832E-C30F00B2B0FA" target="_blank" rel="nofollow noopener">docs.oracle.com/en/database/or…

Verdun Schlucht France #France #motorbike #hemmernoprofil #trümmligvorluterkurve

The @Trivadis #PLSQL & #SQL Coding Guidelines v4.0 is now released: HTML: trivadis.github.io/plsql-and-sql-… PDF: trivadis.github.io/plsql-and-sql-… What's new: github.com/Trivadis/plsql… Enjoy 😀! Thanks to @phsalvisberg for great support.

@kibeha @Andrej_SQL @Trivadis @phsalvisberg Looking good ;-)

@ChrisRSaxon Actually that worked since 12.2 ... the only missing thing was the documentation. Oracle declared restart to be an „internal“ feature after I filed an SR regarding the missing documentation...

ICMYI You can now reset sequences to an earlier value with the restart clause create sequence s; select s.nextval n from dual connect by level <= 5; N 1 2 3 4 5 alter sequence s restart start with 3; select s.nextval n from dual; N 3

Antipatterns SQL & PL/SQL – Redefine oracle defined exceptions rogertroller.com/2020/05/25/ant…

ORA12R2 – IMPdp may change segment_column_id rogertroller.com/2020/05/25/ora…

Antipatterns SQL & PL/SQL – “SELECT *” even if you only need a few columns rogertroller.com/2020/05/24/ant…

Antipatterns SQL & PL/SQL – Substitute NULL with empty string rogertroller.com/2020/05/24/ant…

Antipatterns SQL & PL/SQL – Reusing table aliases in the same SQL statement rogertroller.com/2020/05/24/ant…

Antipattern SQL & PL/SQL – Using the LIKE operator even if searching for equality. rogertroller.com/2020/05/23/ant…

Antipatterns SQL & PL/SQL – Existance Check rogertroller.com/2020/05/23/ant…

ORACLE 18c – TO_UTC_TIMESTAMP_TZ rogertroller.com/2020/02/29/ora…