Melissa Yap’s Post

The top five reasons for wanting to move on from Oracle include cost (42%), preference for open-source (40%), Oracle’s sales tactics (37%), uncertainty around changing licenses and pricing (36%), and restrictive Oracle policies (33%). ... https://lnkd.in/dzKC49A8

1.    Oracle APEX is cloud-compatible. You can even run a full database in the cloud (Oracle’s so-called Autonomous Database, or a non-autonomous solution such as AWS or Azure), which means you don’t need to manage and maintain the infrastructure on-premise. You also get all the great benefits ofmigrating to the cloud – automated backups, recovery, and patching. 2.    As of version 24.1, Oracle APEX is an AI-ready platform. The solution provides an AI assistant that can help you generate, explain, optimize, and debug SQL queries (though you can also use it with HTML, CSS, PL/SQL, and JavaScript). Integrating AI capabilities into your apps is also very easy thanks to the new APEX_AI API, an abstraction layer for AI service configuration at the Workspace level, and a dedicated Dynamic Action for enabling AI-powered conversational experiences. 3.    You don’t need Oracle WebLogic licenses to use APEX. You still need to deploy Oracle REST Data Services (ORDS) to the server to access APEX applications, but it doesn’t need to be done via the WebLogic Server. You can use free, open-source solutions such as Eclipse Jetty or Apache Tomcat (though Tomcat is the only solution supported officially). This helps lower licensing costs even further (and means greater flexibility for the developers). 4.    As a true low-code platform, APEX is even easier to use than Forms, and it means that more non-technical people (so-called citizen developers) can take part in software development. When you convert Oracle Forms system to an APEX one, you continue to use the same tech stack. That means your company doesn’t have to acquire new IT specialists 

Mastering Oracle Triggers: The Pros and Cons of MAX + 1 vs. Sequences  In Oracle databases, triggers often handle auto-generating unique IDs for new records. While sequences are the preferred method, many developers still explore the MAX + 1 approach. Let’s dive into both and understand the challenges, especially the infamous mutating table error.   --- 1️⃣ Using a Sequence  The gold standard for generating unique IDs:  :new.id := my_sequence.nextval; Key Advantages:   - Concurrency-Friendly: Sequences are isolated and can generate unique values regardless of simultaneous transactions.   - Efficient: They don’t scan the table or depend on its state, keeping performance optimal.   -- 2️⃣ Using MAX + 1   This approach calculates the next ID dynamically:   SELECT MAX(id) + 1 INTO :new.id FROM my_table; When MAX + 1 Works:   - Single-Row Inserts: For straightforward `INSERT` statements, MAX + 1 will generally work without errors.   - Controlled Environments: If your application guarantees no concurrent inserts, MAX + 1 might suffice.  ⚠️ The Mutating Table Error in Multi-Row Inserts   The mutating table error occurs when a row-level trigger tries to query or modify the table it’s monitoring during multi-row operations.  For example, consider this statement:   INSERT INTO my_table (id, name)  SELECT NULL, some_data FROM another_table;   Here’s what happens:   1. The trigger fires for each row being inserted.   2. The trigger’s logic (`SELECT MAX(id) + 1`) queries the same table (`my_table`).   3. Oracle prevents this to avoid inconsistent or partially committed data.  This results in the classic => ORA-04091: table is mutating, trigger/function may not see it.  Why Does Oracle Enforce This?   - Consistency: During an `INSERT...SELECT`, the table is in a state of flux. Allowing queries on the same table could lead to inconsistent reads.   - Concurrency Safety: Prevents conflicts when multiple rows are inserted simultaneously.  --- Additional Drawbacks of MAX + 1   - Performance Bottlenecks: Scanning the table for the MAX value adds overhead as the table grows.   - Concurrency Issues (Application Layer): If MAX + 1 logic is in the application, two users can calculate the same value simultaneously, resulting in duplicate IDs.  --- Best Practices for ID Generation   - Use Sequences: They eliminate mutating table errors, are highly efficient, and support concurrency effortlessly.   - Avoid MAX + 1 for Multi-Row Inserts: The risks of mutating table errors and performance penalties outweigh any perceived simplicity.  --- 💡 Understanding these nuances is key to building robust, high-performing Oracle database applications. Have you encountered the mutating table error or had to troubleshoot MAX + 1 challenges? Share your experiences in the comments! #OracleDatabase #Triggers #DatabaseDesign #SQL #MutatingTableError #APEX #oracle_apex #oracleApex

Downloading and installing **MySQL** is a straightforward process for SQL enthusiasts looking to set up their database environment. Here’s a step-by-step guide tailored for beginners: --- ### **Steps to Download and Install MySQL** #### 1. **Visit the Official MySQL Website** - Go to the official MySQL website: [https://lnkd.in/gasY4Bhr). #### 2. **Navigate to the Downloads Page** - On the homepage, click on **“Downloads”** in the top navigation bar. - Select **“MySQL Community (GPL) Downloads”** under the "MySQL Community Edition" section. #### 3. **Choose the MySQL Installer** - On the MySQL Community Downloads page, select **MySQL Installer for Windows**, or choose the appropriate option for your operating system (Windows, macOS, Linux). #### 4. **Select the Installation Package** - For **Windows**: - Choose the installer type: - **Web Installer**: Smaller file, downloads additional components during installation. - **Full Installer**: Contains all components in one package. - For **Linux/macOS**: Download the relevant package, such as RPM for Red Hat-based systems or DMG for macOS. #### 5. **Download the Installer** - Click on the download link. - You may be prompted to log in or sign up for an Oracle account, but this step can usually be skipped by clicking **"No thanks, just start my download."** #### 6. **Install MySQL** - Run the downloaded installer and follow the instructions: 1. **Choose Setup Type**: Select a setup type (e.g., Developer Default, Server Only, or Custom). 2. **Configure the Server**: Define the server type, port number (default is 3306), and authentication method. 3. **Set Root Password**: Create a secure root password and, optionally, additional user accounts. 4. **Complete Installation**: The installer will download and configure all components. #### 7. **Verify Installation** - After installation, open the **MySQL Command Line Client** or **MySQL Workbench** to ensure MySQL is running properly. - Test the connection using your root credentials. --- ### **Additional Resources for SQL Enthusiasts** 1. **MySQL Workbench** - A GUI tool for designing, managing, and querying MySQL databases. - Download from the same MySQL site. 2. **Documentation** - Explore the official MySQL documentation for tutorials and best practices: [MySQL Documentation](https://dev.mysql.com/doc/). 3. **Community Support** - Join forums like [Stack Overflow](https://stackoverflow.com/) or [MySQL Forums](https://forums.mysql.com/) for troubleshooting and discussions. --- ### **System Requirements** Ensure your system meets the minimum requirements for MySQL: - **Windows**: Windows 10/11 or Server editions. - **macOS**: macOS 10.13 or later. - **Linux**: Distributions like Ubuntu, Red Hat, or CentOS. - Minimum 1 GB RAM and adequate disk space. ---

🚀 #New in Oracle Container Registry! 🚀 The APEX image has been updated with the latest version 24.1, and I have a detailed guide for you on how to containerize Oracle Database, ORDS, and APEX using Docker Compose. 🐳📦 Want to learn how to take advantage of new features and simplify managing your applications? Check out my article! 👉 https://lnkd.in/dhDDFFEx Don't miss the chance to stay up-to-date with the solutions for Oracle developers! 🌐💡 #Oracle #Docker #APEX #ORDS #DevOps #IT #Technology #News

Looking to enable centralized, controlled and password-less data access to your application users? Check out how you can enable Identity Access Management (IAM) with Oracle Database to your Node.js apps: https://lnkd.in/g-hnvukK #oracle #nodejs #iam #developers #database

10 Tech Terms You're Probably Pronouncing Wrong! 🤔💡 You might have heard these terms mispronounced quite often, but it's time to get them right: 1) Nginx = "Engine-X" 2) PostgreSQL = "Post-gres" 3) MySQL = "My-S-Q-L" 4) SQL Server = "Sequel Server" 5) Kubernetes = "Koober-netties" 6) SAP = "S-A-P" 7) Cache = "Cash" 8) Adobe = "Ado-bee" 9) SCSI = "Scuzzy" 10) Huawei = "WAH-way" 💡 How many of these were you saying wrong? Let us know in the comments!👇 - 👍 Hit like, if you found it helpful! 🔖 Save it for the future! 📤 Share it with your connections! 💭 Comment your thoughts! - #TechTerms #PronunciationMatters #DevOps #CloudComputing #Kubernetes #Database #Nginx #IT #Technology #BAZTechKnow

One is more suitable for dynamic startups and agile tech companies. The other is designed for heavy-duty enterprise environments where scalability and security are the primary concerns. Yes, we're talking about PostgreSQL and Oracle Database. 🔍 PostgreSQL, the open-source favorite, celebrated for its adaptability and community-driven development. It's the go-to choice for organizations that value customization and cost efficiency, perfect for those who need a powerful database without fees that go over the moon. 🔍 Oracle Database is the titan of industry, equipped to handle great amounts of data with unbeatable performance and ironclad security measures. It's tailored for large enterprises that require a database system capable of supporting extensive and complex transactions. Which database to adopt? Weigh all of the factors such as budget, scale, and specific functional needs, before you decide #DatabaseManagement #PostgreSQL #Oracle #BusinessGrowth #DBA

🚀 New Blog Post Alert! 🎉 Are you ready to easily run Oracle Database in Docker? 🐋📦 In my latest post, I guide you step-by-step on how to set up and connect to an Oracle Database instance using Docker. Perfect for developers looking for a quick and efficient setup! 👉 Check it out here: Easily Run Oracle Database in Docker 💡 Highlights: ✅ Step-by-step guidance ✅ Common errors explained ✅ Quick tips for smooth integration Let's make database setups easier together! 🛠️ #Docker #OracleDatabase #DevOps #Programming #DatabaseIntegration #DevTo https://lnkd.in/gJcj3YXh

Simplifying a long-standing developer issue, Oracle Database 23c introduces JSON Relational Duality Views. This standard feature allows developers to work with JSON and relational models seamlessly, without adding another layer of logic. By integrating JSON directly with the database, it provides a more efficient and streamlined approach for #developers. See why it’s a revolutionary advancement. https://lnkd.in/e36c_yYs