Roger Troller

[Roger Troller @RogerTroller]

ACT Pyrenees - Day 1

[Roger Troller @RogerTroller]

SQuizL 23-MAY-24
1/6 guesses
39 seconds
🟩🟩🟦🟩🟩🟩🟦
https://t.co/UqrezSVZCE
#SQuizL #SQL
Enum-Annotations ... new with the latest 23ai Release. Looking good

[Dani Schnider (inactive) @dani_schnider]

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

[Roger Troller @RogerTroller]

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

[Roger Troller @RogerTroller]

Dani Schnider@DOAG looking forward to his presentation

[Roger Troller @RogerTroller]

@Andrej_SQL @DOAGeV see you there ...

[Oracle ACE Program @oracleace]

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!

https://t.co/X915doRcOS
#OracleACE

[Roger Troller @RogerTroller]

@phsalvisberg ALTER SESSION SET group_by_position_enabled=TRUE;

[Roger Troller @RogerTroller]

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

[Kim Berg Hansen {Inactive} @kibeha]

The @Trivadis #PLSQL & #SQL Coding Guidelines v4.0 is now released:

HTML:
https://t.co/sNhy5UWfFX

PDF:
https://t.co/O3yM1W4Jrd

What's new:
https://t.co/fZVcoZjCey

Enjoy 😀!

Thanks to @phsalvisberg for great support.

[Roger Troller @RogerTroller]

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

[Roger Troller @RogerTroller]

@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...

[Roger Troller @RogerTroller]

Antipatterns SQL & PL/SQL – Redefine oracle defined exceptions https://t.co/fNSE1DW6mo

[Roger Troller @RogerTroller]

ORA12R2 – IMPdp may change segment_column_id https://t.co/MaAgQHUSdR

[Roger Troller @RogerTroller]

Antipatterns SQL & PL/SQL – “SELECT *” even if you only need a few columns https://t.co/ncnemIzopD

[Roger Troller @RogerTroller]

Antipatterns SQL & PL/SQL – Substitute NULL with empty string https://t.co/CGdGPhNV58

[Roger Troller @RogerTroller]

Antipatterns SQL & PL/SQL – Reusing table aliases in the same SQL statement https://t.co/Wt5AbiNZSh

[Roger Troller @RogerTroller]

Antipattern SQL & PL/SQL – Using the LIKE operator even if searching for equality. https://t.co/eTbYo1IaOe

[Roger Troller @RogerTroller]

Antipatterns SQL & PL/SQL – Existance Check https://t.co/V6cXPrNj8S

[Roger Troller @RogerTroller]

ORACLE 18c – TO_UTC_TIMESTAMP_TZ https://t.co/8Rym67bArX