Phil Grinhamphilgrinham.hashnode.dev·Jul 22, 2024Just Passing ThroughDatabase links have been a key feature of the Oracle database for a long time, allowing one database instance to interact with another. These "remote" databases do not have to be Oracle databases; the heterogeneous gateway allows for ODBC connectivit...Discuss·53 readsOracle
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 30, 2024Regex Searching APEX Apps for use of Deprecated FeaturesI wrote a story recently on deprecated APEX APIs and in there I wrote "You have to make proactive steps to resolve [deprecated APEX APIs]". So how do you spot that you're using deprecated features so that you can be proactive? The Advisor is not advi...Discuss·3 likes·85 readsorclapex
Azam Sajidaazamsajid.hashnode.dev·May 29, 2024Unlocking Efficiency in Data Analytics: The Power of Materialized Views in Oracle SQLIntroduction In the fast-paced world of data analytics, efficiency and performance are paramount. As data professionals, we often grapple with the challenge of optimizing query performance to deliver insights swiftly and accurately. One powerful yet ...Discussoracleapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 19, 2024Inline Instructions UX Pattern for APEXRecently I started a piece of research on Inline Application Help. I wanted to find examples of guiding the user, helping them completing the page, without being too obtrusive, annoying or taking up valuable screen area. After not too long, I found t...Discuss·8 likes·570 reads#oracle-apex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 7, 2024A story about APEX Debug's advice on Deprecated FeaturesI made a small discovery whilst looking a the Customers Starter Application and decided to share some thoughts. Here we go... I have a piece of code that checks the build option status. No big deal, it works fine. The page displays No errors in th...Discuss·2 likes·557 readsOracle
Viraj Sabhayavirajsabhaya23.hashnode.dev·Mar 18, 2024Database Developer Interview Questions1. What is the difference between PL SQL and SQL? ComparisonPL/SQLSQL ExecutionSingle command at a timeBlock of code ApplicationSource of data to be displayedApplication created using the data from SQL Structures includeDDL and DML based que...DiscussSQL
Yasith Wimukthiyasithwimukthi.hashnode.dev·Jan 22, 2024Mastering the Power of PL/SQL: A Comprehensive Guide to Efficient Database ProgrammingPL/SQL, or Procedural Language/Structured Query Language, is a programming language that's a big deal in the world of Oracle databases. It's like the secret sauce that makes your database applications robust and efficient. Think of it as the wizard b...Discuss·78 readsSQL
Sahitya Guptasahityagupta25.hashnode.dev·Jan 11, 2024How to group data , Sub-queries & questions: Enhancing(SQL) (Part-4)PRE-REQUISTES PART-1 (Understand concept of all keys (theory) and what are anomalies in database) PART-2 (CRUD operations in database , learn syntax & understand concept by doing) PART-3 (1st Normal form , 2NF , 3NF , Partial Dependency , Transitive ...DiscussFundamentals & Core Concepts of Database Management System (SQL)BlogsWithCC
pradnya dhongadepradnyaa.hashnode.dev·Jan 1, 2024Concept of DevOpsIf you want to build better software faster, DevOps is the answer. In today's fast-paced digital landscape, businesses are constantly seeking ways to deliver high-quality software faster and more efficiently. This is where DevOps comes into play. Dev...Discuss·33 readsDevops
Sahitya Guptasahityagupta25.hashnode.dev·Dec 26, 2023Super Key , Primary key , Candidate Key , Functional Dependency , Anomalies: Enhancing (SQL) (Part-1)What is Normalization? Normalization is the process of organizing the data in the database. It simply means there should be no redundancy . Redundancy means duplicate data , so avoid redundancy we should use normalization. If you are managing the Du...Discuss·28 readsFundamentals & Core Concepts of Database Management System (SQL)BlogsWithCC