Dan McGhandanmcghan.hashnode.dev·21 hours agoAn Overview of the Oracle SQLcl Projects Development ProcessSQLcl Projects is a new feature of SQLcl that aims to standardize and streamline the development lifecycle of Oracle Database and APEX applications. This post provides a high level overview of what the development process looks like. Here are a coupl...12 likes·307 readssqlcl
Anton Nielsenapexdebug.com·Dec 11, 2024Full Outer Join - How to Compare TablesIt’s not all that often than I need to do a full out join. Heck, the “Oracle join syntax” doesn’t even support it. I’ve change to using the JOIN keyword (sometimes referred to as an ANSI join) which makes things so much more readable and understandab...52 readsorclapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 25, 2024Oracle APEX Version HistoryFor some reason, I thought' it’d be a really great idea to record the exact date of the Oracle APEX releases. By the time I’d compiled the list, I’d forgotten what that reason was 🤷 Some information I didn’t manage to find the exact dates for the e...1 like·172 readsorclapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 25, 2024Custom Domain for your Oracle 23ai Free APEX & ORDS all in one Docker Container with Apache HTTPFollowing the prerequisites, its a fairly easy guide to get up and running, this time on Apache HTTP. OMG this is a super fast web-server. Following this guide you’ll have a Vanity URL, proxied through Apache HTTP to your APEX instance. Prerequisites...1 like·313 reads#oracle-apex
Urh Srecnikblog.srecnik.info·Nov 18, 2024How to Keep Oracle Database Schema(s) Under Version Control (git, mercurial) Using DDLFSI've just released new (beta) version of ddlfs, which now also supports running natively on Windows (thanks to Dokan). Originally it written for Linux/libfuse only. I made it so that I wouldn't need to use graphical interfaces when interacting with O...ddlfs
Baskarbaskarblogspot.hashnode.dev·Oct 22, 2024All Administrative SQL Scripts for Monitoring and Managing Oracle Database Space ManagementThis article consists of all the Ready-To-Use SQL Scripts that can be used to monitor and manage the Oracle Database Space Usage. -- To find the Total Allocated Datafile Size for the Database / To find the Total DB Size: select sum(bytes)/(1024*1024...Oracle Database
Ben NormanforShield Replyshieldreply.hashnode.dev·Oct 16, 2024Oracle Database + APEX + Python Really Is Awesome! #JoelKallmanDayIntroduction #JoelKallmanDay is a special day for sharing with the community about all things Oracle. Over 5 years ago, Joel Kallman himself announced the exciting release of the Oracle Database Multilingual Engine (MLE) and how it can be used with P...1 like·230 readsUsing Python in Oracle APEXOracle
Ben NormanforShield Reply UKshielduk.hashnode.dev·Oct 16, 2024Oracle Database + APEX + Python Really Is Awesome! #JoelKallmanDayIntroduction #JoelKallmanDay is a special day for sharing with the community about all things Oracle. Over 5 years ago, Joel Kallman himself announced the exciting release of the Oracle Database Multilingual Engine (MLE) and how it can be used with P...Using Python in Oracle APEXOracle
Urh Srecnikblog.srecnik.info·Oct 13, 2024Reading Execution PlansI routinely do a "rehearsal" of my presentations with our DBA team and any other willing participants (they tend to be developers) to receive feedback and to share knowledge. In the last one, I've got quite an interesting question, which requires und...58 readsOracle Database
Carla Muñoz Lópezselectfromdual.com·Oct 11, 2024Consultar métricas de CPU en tiempo real desde BBDD con MGMTDBSi necesitas obtener métricas de CPU como IOWAIT_TIME, IDLE_TIME, SYS_TIME, USER_TIME, NICE_TIME y STEAL_TIME en Oracle en tiempo real y desagregadas, la vista V$OSSTAT puede no ser suficiente porque presenta valores acumulados desde que la base de d...1 like·287 reads#gimr
