kuchatom.hashnode.devA guide to implement Faceted search with ANY region in Oracle APEXYou probably know what Faceted search is, and you implemented it many times. But it may be possible, that you don’t use it, because it does not pair well with Interactive grid or Interactive report and you will have to strip you report functionality ...Jan 13·4 min read
kuchatom.hashnode.devStep-by-Step Guide to Interactive Grids with Dynamic Column types / InputsSometimes we reach the limits of native oracle apex components and we have to improvise and do some workarounds to implement functionality we need. Multiple input types in one interactive grid column can be one of the desired functionalities. In this...Sep 24, 2025·8 min read
kuchatom.hashnode.devHow to Easily Parse JSON into Oracle Database TablesIn my previous article, I described my first encounter with the new Oracle Database 23ai functionality called JSON-Relational Duality Views. It is a very useful feature, especially if you have to parse or create JSON objects in your Oracle database. ...Jul 29, 2024·5 min read
kuchatom.hashnode.devA Beginner's Guide to Using Chart Patterns in Oracle APEXIn my presentation about Accessibility in Oracle APEX, which you could see this year at Apex Alpe Adria in Maribor or Oracle User Group Norway in Oslo, I mentioned that one of the possible problems to be aware of are the charts and especially the col...Jun 14, 2024·5 min read
kuchatom.hashnode.devExploring Oracle Database 23ai: A First Look at JSON-Relational Duality ViewsOne of the new features in Oracle Database 23ai is JSON-Relational Duality Views that will allow you to use JSON representation of your relational model. You can create hierarchical JSON documents and use it to modify data in tables and many more. If...May 27, 2024·6 min read
