Lukas Horwath

[*Walter Bloomberg @DeItaone]

IRAN'S IRGC SAY THEY TARGETED U.S. FIGHTER JETS STATIONED IN JORDAN - STATE TV

[Sabine Heїmsath 🇺🇦🇪🇺😷 @oraesque]

#orclAPEX Meetup Frankfurt grüßt den Rest der Welt von der #APEXconn24!

[Lukas Horwath @lukas_hh]

New optimized Version of a simple Month Picker just made of native APEX Items and Regions. See demo and download at https://t.co/VjabKGTbKx
user: demo
pw: picker23
#orclapex

[Lukas Horwath @lukas_hh]

That's it!

[Lukas Horwath @lukas_hh]

Need a Month Picker in #orclapex ? Just Take two Buttons, one Select List, three Dynamic Actions and a Classic Report with Cards Template.

[Lukas Horwath @lukas_hh]

Repeated execution of such queries then returns the cached result for all APEX user sessions. Including a bind variable or a sys_context call or a date/timestamp function or a hint disables the forced result cache behavior for given query. Set result_cache_mode = MANUAL helps!

[Lukas Horwath @lukas_hh]

Autonomous Database with workload type Data Warehouse by default sets result_cache_mode to FORCE. This forcefully caches the results of SQL queries even if these queries invoke non-deterministic PL/SQL functions such as APEX v() and apex_util.get_session_state(). #orclapex

[krisrice 🏒🍺📷 @krisrice]

This is neat. Using jetty-gzip to inflate incoming payloads for @OracleREST 's rest-sql. So a 10M incoming rest-sql request can be compressed to 7M

[Mike Dietrich @MikeDietrichDE]

Silent ORA-918 behavior change in RU 19.17.0 and newer https://t.co/3TnfCfsu7K

[Philipp Salvisberg @phsalvisberg]

Session keynote: New and cool features for developers in Oracle database by @GeraldVenzl at #DOAG2022

Expected new features in @OracleDatabase 23c.

A thread. (1/17)

[Niels de Bruijn 🌍 @nielsdb]

Thank you @DOAGeV, our sponsors @MT_AG_ @TRIOLOGY_GmbH and @DataCons_PL, all speakers and all attendees for making APEX Connect 2022 such a great experience! Here is a recap (DE): https://t.co/JklQHqFyDF All pictures from @OliverLemm are here: https://t.co/IGsPpa3qPR #apexconn22

[Lukas Horwath @lukas_hh]

@OracleREST if you call the URL "..../ords/<workspace-name>/" then ORDS prints the DB parsing schema on the error page. Tested on Always Free Cloud, ORDS 21.4.2.r0621806, Oracle APEX 21.2.6. Do you need this internally or why can I use the workspace name there?

[Lukas Horwath @lukas_hh]

#APEXconn22 APEX Summer Night with @msewtz and @cczarski Und vielen Dank an das gesamte APEX connect Team! 👏

[Medinchen @Medinchen1]

#apexconn22 sehr schöner Abend hier... Danke

[Sabine Heїmsath 🇺🇦🇪🇺😷 @oraesque]

#orclAPEX Meetup Frankfurt & Fans grüßen heute von der #APEXconn22 im #Phantasialand! ☀️🇲🇽😘

[Tobias Arnhold 💯 @tobias_arnhold]

#apexconn22 officially started the #orclapex way‼️🚀🙌🚀
#enjoyTheSpirit

[Lukas Horwath @lukas_hh]

Seems APEX and SQL Developerhave the same problem showing data from too deep nested inline functions? ORA-32034: unsupported use of WITH clause: APEX and SQL Developer should populate an inner WITH_PLSQL hint to the outer query.
#orclAPEX #oracle #SQLDeveloper

[Lukas Horwath @lukas_hh]

@Dani3lSun @StewAshton For IG the end user doesn‘t have to save the report to change the timestamp (and also the page/app hash!), see known known BUG 32413371 - INTERACTIVE GRID: END USER CHANGES (FILTER, ARRANGE COLUMNS) ARE RECORDED IN APP AUDIT COLUMNS

[Lukas Horwath @lukas_hh]

@toufiqmoh @oraclebase Till Version 20.4 it's listed in the Oracle REST Data Services Installation, Configuration, and Development Guide: Jetty 9.4.28, jcl104-over-slf4j 1.7.25, log4j-over-slf4j 1.7.25, slf4j-api 1.7.25, slf4j-simple 1.7.25.
Since 21.1 it's not listed explicitly.

[Lukas Horwath @lukas_hh]

@oraclebase Yes, APEX should be safe, but ORDS not.