Tag

#dml

19 posts0 followers

Explore Hashnode

Alternatives

SapotaCorpJul 12 · 7 min read

DML Partial Success in Apex: Database.SaveResult and Savepoints

A bulk update processes 5,000 records. Validation rules reject 12 of them. The remaining 4,988 are clean. Should the 4,988 commit, or should the whole batch roll back? The answer is business-specific.

sapotacorpvn.hashnode.dev

Johnny Hideki Kinoshita de FariaOct 22, 2025 · 3 min read

🚀 High-Performance Data Processing in PL/SQL: BULK COLLECT, FORALL, MERGE, and SAVE EXCEPTIONS

Oracle PL/SQL offers powerful tools for handling large volumes of data efficiently. Among the most effective are BULK COLLECT, FORALL, MERGE, and SAVE EXCEPTIONS. This article explains how each works, when to use them, and includes practical examples...

johnnyhideki.hashnode.dev

Lord AbiollaJul 30, 2025 · 8 min read

Querying Data

Data Structures Data Structures can be defined as containers that hold and organize data in specific formats. Data structures also determine how data are stored, accessed or modified. Data structures can be categorized into two main types; Primitive...

alx-data-analytics.hashnode.dev

AkankshaJul 2, 2025 · 3 min read

SQL – The Heart of Data & DevOps Foundations

Today I officially kicked off my journey with SQL (Structured Query Language) — the backbone of relational databases and a crucial skill in the DevOps and Cloud Engineering toolbox. Whether you're spinning up Amazon RDS, building a backend pipeline, ...

akanksha-devops.hashnode.dev

SoyuliaMay 17, 2025 · 1 min read

[ 데이터베이스 ] DDL vs DML

목표 : SQL에서 DDL과 DML의 차이점, 각각의 대표적인 명령어들의 용도확인하기. ❓DDL (Data Definition Language) 구조를 정의하는 언어이다. 생성 , 수정 , 삭제 등 전체적인 구조를 결정하는 역할을 한다. DB를 구현할 때, 가장 먼저 사용하는 언어이다. SCHEMA , DOMAIN , TABLE , VIEW, INDEX를 설정한다. create : 데이터베이스 , 테이블 등 생성 alter : 테이블 수정...

soyulia.hashnode.dev

RishithaMay 15, 2025 · 2 min read

🚀 Day 7: Types of SQL commands

Welcome back to Day 7 of the SQL tutorial series! 👋 Today, let’s explore the 5 main types of SQL commands — this will help you organize your learning and know whyyou’re writing a specific SQL statement. 📌 The 5 Types of SQL Commands CategoryPur...

thelearningcurve.hashnode.dev

Sudesh Rajendra SawantJan 31, 2025 · 3 min read

Retrieving Data with SELECT (DQL)

Introduction Data Query Language (DQL) is a subset of SQL used to retrieve and manipulate data stored in databases. The SELECT statement is the most commonly used DQL command, allowing users to fetch specific data from tables based on various conditi...

datawithsql.hashnode.dev

Sudesh Rajendra SawantJan 31, 2025 · 2 min read

Inserting, Updating & Deleting Data in SQL (DML)

Introduction Data Manipulation Language (DML) in SQL is used to manage data within tables. The three most important DML commands are: INSERT INTO – Adds new records. UPDATE – Modifies existing records. DELETE – Removes records from a table. 1. ...

datawithsql.hashnode.dev

Vedant SagolaleDec 11, 2024 · 7 min read

DDL and DML commands

DDL (Data Definition Language) Commands DDL commands are used to define, modify, and manage the structure of a database and its objects (such as tables, schemas, etc.). CommandDescriptionExample CREATECreates a new database object (table, view...

dbforpuredevelopers.hashnode.dev

Eshita SharmaOct 8, 2024 · 4 min read

Understanding DDL and DML Statements in SQL

In database management, SQL (Structured Query Language) is an essential tool that allows users to interact with databases. SQL is divided into several sub-languages, two of the most critical being Data Definition Language (DDL) and Data Manipulation ...