Sujan Haldarhsujan.hashnode.dev·Feb 12, 2025Cursors in PL/SQL : 4A Cursor is a database object that allows row-by-row processing of query results. It acts as a pointer to the result set of a SQL query and is used to retrieve and manipulate data efficiently. Types of Cursors in PL/SQL Implicit Cursor Created auto...PL/SQLPL/SQL
Sujan Haldarhsujan.hashnode.dev·Feb 9, 2025Composite Data Types in PL/SQL : 3In SQL and PL/SQL, composite data types are data structures that allow storing multiple values within a single variable. They help in managing and processing multiple pieces of data together, just like objects or structures in other programming lang...PL/SQLPL/SQL
Sujan Haldarhsujan.hashnode.dev·Feb 5, 2025Using SQL Commands in PL/SQL : 2PL/SQL is a powerful extension of SQL that allows procedural programming alongside SQL queries. It enables SQL and PL/SQL commands to be used together seamlessly within a PL/SQL block without requiring separate worksheets. DML and Transaction Control...PL/SQLPL/SQL
Sujan Haldarhsujan.hashnode.dev·Feb 3, 2025Introduction to PL/SQL : 1PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL. It is a powerful, block-structured language that enables developers to write complex database applications with procedural constructs like lo...PL/SQLPL/SQL
Anton Nielsenapexdebug.com·Jan 31, 2025Mark This DownYou may have heard me say it before, but I like writing documentation. That includes both help text within an application and the comments describing how to use APIs. I don’t, however, like writing documentation that never gets read. Or worse still, ...2 likes·248 readsOracle
Shariq Kadrishariqkadri.hashnode.dev·Jan 22, 2025How to Use JSON_TABLE in Oracle APEXHow to Use JSON_TABLE in Oracle APEX with a Real-Life Example Dealing with JSON data is a common task when building modern applications, especially when you're interacting with APIs. In Oracle APEX, you can take advantage of Oracle Database's powerfu...30 readsorclapex
Lázzaro Daudt da Costalazzaro.hashnode.dev·Jan 20, 2025APEX Background Process Progress BarWhen building pages in Oracle APEX, we often need to execute processes that can take some time to complete. A static loading screen with no feedback can create a poor user experience, leaving users uncertain about what’s happening. Fortunately, Oracl...8 likes·1.0K reads#oracle-apex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Jan 6, 2025VSCode & Copilot Free for PL/SQLThe latest update 1.96.1 of VSCode, enables the GitHub Copilot Free plan. You can compare the plans although basically the Free Plan provides: 2000 Code completions per month 50 Chat messages per month As long as you have a Github Account & an up...8 likes·1.0K readsorclapex
Data & Devrvats20.hashnode.dev·Dec 16, 202418 Useful Applications of SQL: A Comprehensive Exploration of Database Management and Analysis## Introduction Structured Query Language (SQL) is a powerful tool that extends far beyond simple data retrieval. Its versatility makes it an essential technology across numerous domains, from business intelligence to scientific research. This compre...SQL seriesSQL
Data & Devrvats20.hashnode.dev·Dec 11, 2024Mastering Oracle Database: A Comprehensive GuideOracle SQL is a powerful, declarative language used for managing relational databases in Oracle databases (e.g., Oracle 11g, 12c). It provides a wide range of features for querying, manipulating, and analyzing data. With its robust capabilities, Orac...SQL
