--- title: Best Oracle posts of 2024 | daily.dev description: The most upvoted Oracle posts of 2024, curated by the daily.dev community. canonical: https://daily.dev/tags/oracle/best-of/2024 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/oracle/best-of/2024 og:type: website og:site_name: daily.dev og:title: Best Oracle posts of 2024 | daily.dev og:description: The most upvoted Oracle posts of 2024, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of Oracle — 2024 1. 1 [](/posts/the-2024-database-admin-roadmap-t27awqg0r "The 2024 Database Admin RoadMap") Article Javarevisited · 2y The 2024 Database Admin RoadMap This guide outlines the roadmap to becoming a Database Administrator in 2024, covering essential skills like SQL, database systems, advanced SQL topics, database administration, and cloud databases. Recommended learning resources include courses for SQL, Linux, Oracle, and PostgreSQL. The role is highly in-demand and offers robust career prospects. 70 2. 2 [](/posts/difference-between-sql-select-unique-and-select-distinct-eexstw7dd "Difference between SQL SELECT UNIQUE and SELECT DISTINCT") Article SQL Shack · 3y Difference between SQL SELECT UNIQUE and SELECT DISTINCT Learn about the difference between SQL SELECT UNIQUE and SELECT DISTINCT, the use of UNIQUE constraint, and the syntax for executing these statements in Oracle. Both statements are used to fetch unique values from a column that may have duplicate values. 28 2 3. 3 [](/posts/comparing-sql-engines-by-cpu-instructions-for-dml-rirwuy3ib "Comparing SQL engines by CPU instructions for DML") Article DEV · 2y Comparing SQL engines by CPU instructions for DML This post compares the CPU usage of different SQL engines, such as PostgreSQL, Oracle, SQL Server, MySQL, TiDB, YugabyteDB, and CockroachDB, for simple DML operations. The results show that despite their different implementations, PostgreSQL, Oracle, and SQL Server perform well in terms of CPU usage. TiDB, YugabyteDB, and CockroachDB exhibit higher CPU utilization due to their distributed and scalable architectures. Overall, the performance varies depending on the database engine and workload. 22 4. 4 [](/posts/java-basics-what-is-weblogic--a6t4vxckv "Java Basics: What Is WebLogic?") Article JRebel · 2y Java Basics: What Is WebLogic? WebLogic is a scalable enterprise Java application server, acquired by Oracle from BEA Systems in 2008\. It's used for deploying Java-based web applications and offers robust, highly available, and secure environments for critical applications. The post compares WebLogic with other popular servers like Tomcat and JBoss/WildFly, highlighting WebLogic's comprehensive enterprise features and commercial support, making it suitable for production environments with heavy loads. 16 5. 5 [](/posts/what-s-new-in-mysql-9-0-itj0d4vwv "What’s new in MySQL 9.0") Article InfoWorld · 2y What’s new in MySQL 9.0 Oracle has released MySQL 8.0.38, MySQL 8.4, and MySQL 9.0, marking the latter as a significant innovation release. MySQL 9.0 introduces features such as a new Vector data type, JavaScript Stored Programs, and updated libraries and compilers. Deprecated features include the removal of SHA-1\. Future updates are expected every three months, with the next major LTS releases anticipated in October. 14 6. 6 [](/posts/build-a-cloud-compute-instance-with-java-concepts-inside-java-udhpgvqqr "Build a Cloud Compute Instance with Java Concepts – Inside.java") Article Inside Java · 2y Build a Cloud Compute Instance with Java Concepts – Inside.java The post explores how to use Java with Pulumi to provision Oracle Cloud Infrastructure (OCI) instances. It provides a step-by-step guide on setting up the project, configuring Maven dependencies, and storing environment parameters in configuration files. Key tasks include setting up Pulumi stacks, configuring Java projects to interact with Pulumi, and writing code to build infrastructure as code. The post also suggests creating keys for secure access and offers tips on managing certificates and secrets for long-term projects. 13 7. 7 [](/posts/simplify-your-deployment-workflow-introducing-oracle-java-releases-public-apis-ough0thr7 "Simplify Your Deployment Workflow: Introducing Oracle Java Releases Public APIs") Article Inside Java · 2y Simplify Your Deployment Workflow: Introducing Oracle Java Releases Public APIs Oracle has launched Java Releases Public APIs, designed to simplify access to Java release information. These RESTful APIs, available via Oracle Cloud Infrastructure, support seamless CI/CD integration, automated compliance checks, and timely release notifications, enhancing efficiency for IT administrators, DevOps professionals, and developers. 10 8. 8 [](/posts/how-to-pivot-tables-in-sql-jey2i90lg "How to Pivot Tables in SQL") Article Towards Data Science · 2y How to Pivot Tables in SQL A comprehensive guide on creating pivot tables in SQL for enhanced data analysis using DECODE() and PIVOT() functions. 10 9. 9 [](/posts/what-s-faster-count-or-count-with-limit-in-sql-let-s-check-rv7lljmed "What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check") Article JOOQ · 3y What's faster, COUNT(\*) or COUNT(\*) with LIMIT in SQL? Let's check Learn the recommended way to check for the existence of values in SQL and the difference between using LIMIT and COUNT(\*) for checking the number of rows. 10 [See all Oracle archives](/tags/oracle/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/oracle/best-of/2024#page","url":"https://daily.dev/tags/oracle/best-of/2024","name":"Best Oracle Posts of 2024","description":"The most upvoted Oracle posts of 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/oracle/best-of/2024#items","numberOfItems":9,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/the-2024-database-admin-roadmap-t27awqg0r","name":"The 2024 Database Admin RoadMap"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/difference-between-sql-select-unique-and-select-distinct-eexstw7dd","name":"Difference between SQL SELECT UNIQUE and SELECT DISTINCT"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/comparing-sql-engines-by-cpu-instructions-for-dml-rirwuy3ib","name":"Comparing SQL engines by CPU instructions for DML"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/java-basics-what-is-weblogic--a6t4vxckv","name":"Java Basics: What Is WebLogic?"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/what-s-new-in-mysql-9-0-itj0d4vwv","name":"What’s new in MySQL 9.0"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/build-a-cloud-compute-instance-with-java-concepts-inside-java-udhpgvqqr","name":"Build a Cloud Compute Instance with Java Concepts – Inside.java"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/simplify-your-deployment-workflow-introducing-oracle-java-releases-public-apis-ough0thr7","name":"Simplify Your Deployment Workflow: Introducing Oracle Java Releases Public APIs"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/how-to-pivot-tables-in-sql-jey2i90lg","name":"How to Pivot Tables in SQL"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/what-s-faster-count-or-count-with-limit-in-sql-let-s-check-rv7lljmed","name":"What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"Oracle","item":"https://daily.dev/tags/oracle"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/oracle/best-of"},{"@type":"ListItem","position":5,"name":"2024"}]}]} ```