Jon DixonProblog.cloudnueva.com·2 hours agoBuilding Integrations with the Oracle DB APEX & ORDS - Part 1Introduction There are many ways to integrate data between two systems. One way to start a lively conversation / fight between two developers is to ask them how they would move some data between system A and system B. There are also many Integration ...Discuss·1 like·95 readsorclapex
Bruno Cardosocardoso.hashnode.dev·Apr 15, 2024Simplifying Log Recording in Oracle DatabasesIntroduction In complex IT environments, especially those utilizing robust database management systems like Oracle, effective log recording is crucial. Logs are not only essential records for maintenance and troubleshooting but are also fundamental f...Discuss·27 readsOracle
Shiv IyerProshiviyer.hashnode.dev·Apr 14, 2024Understanding PostgreSQL: Advanced Techniques for Table Storage and Index OptimizationPostgreSQL is a powerful, open-source object-relational database system known for its robustness, scalability, and performance optimization features. A deep understanding of how PostgreSQL handles the storage and indexing of tables can significantly ...Discuss·104 readsPostgreSQL
Karla Cornejotoshareapex.hashnode.dev·Apr 12, 2024Multiple Selección / SelectionMuchas veces nos enfrentamos a requerimientos en donde nuestros usuarios necesitan ver información entre tener un report y a la vez graficas. En este post veremos cómo hacer que desde un reporte interactive, al seleccionar una o más registros, el grá...Discuss·119 readsApex
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 11, 2024Best Practices: Why Changing SET Options Within a Batch in SQL Server is DiscouragedChanging SET options within a batch in SQL Server can lead to unexpected behavior, performance issues, and compatibility problems. It's strongly recommended to avoid altering SET options mid-batch for several reasons: 1. Plan Caching and Recompilatio...DiscussSQL
Suraj RameshProsurajramesh.com·Apr 10, 2024How to Implement Full Stack Disaster Recovery in OCI: Best PracticesIn this blog, I will cover some of the best practices for implementing the OCI Full Stack DR for your business system. IAM Policies: Full Stack DR interacts with a variety of OCI services such as Compute, Oracle Database, Block Storage, File Storage...DiscussOCI Full Stack DRfullstackdr
Dominik Grabińskidgrabinski.hashnode.dev·Apr 10, 2024This is my story of how I became a speaker and and why you sometimes feel like a rock star? Part 3 of 3Now I would like to compare Kscope to a dream concert. Why? Because I see a lot of similarities with a surprising finale. Imagine that your favourite band or singer comes to your neighbourhood. What are you doing? You wait with a flushed face for the...Discusskscope
Jamey Bartondbajamey.hashnode.dev·Apr 10, 2024How to Use the CREATE SEQUENCE Statement in OracleIn this article, we are going to talk about the Oracle CREATE SEQUENCE statement, the primary purpose of which is to offer a reliable means of generating unique and sequential numeric values, often utilized for primary key fields within database tabl...DiscussOracle
Phil Grinhamphilgrinham.hashnode.dev·Apr 9, 2024Oracle APEX Theme Update Left Me Spinning.My experience with the ever-reliable, fantastic Oracle APEX is that it is normally ever-reliable and fantastic, but like any tool there can be a few occasions when you are left scratching your head wondering why something isn't working quite right. O...Discuss·55 reads#oracle-apex
Shiv IyerProshiviyer.hashnode.dev·Apr 8, 2024Interlocked PostgreSQL functionsIn PostgreSQL, interlocked functions refer to operations that ensure atomicity and thread safety when accessing or modifying data. These functions provide a way to perform operations that cannot be interrupted or corrupted by other concurrent threads...Discuss·46 readsPostgreSQL
