11 docs tagged with "dml"

Deleting Duplicate Rows | Data Cleaning in SQL

Learn professional techniques to identify and remove duplicate records from your SQL tables using CTEs, Row IDs, and Group By.

Oracle DML Basics | INSERT, UPDATE, & DELETE

Master Data Manipulation Language in Oracle. Learn how to add, modify, and remove data from your tables with safety and precision.

Oracle INSERT ALL | Multi-Table Inserts

Learn how to use Oracle's INSERT ALL statement to add data into multiple tables in a single operation. Master conditional and unconditional multitable inserts.

Oracle MERGE Statement | The 'Upsert' Command

Master the Oracle MERGE statement. Learn how to perform an Insert or Update in a single operation based on data existence.

Oracle SELECT Statement | Querying Data from Single Tables

Master the Oracle SELECT statement. Learn how to retrieve data, use expressions, and perform arithmetic in Oracle Database.

SQL Data Operations | CRUD in SQL

Master the 4 core data operations in SQL: SELECT, INSERT, UPDATE, and DELETE. Learn how to manipulate data within your tables.

SQL DELETE Statement | Removing Records Safely

Master the SQL DELETE command. Learn how to remove specific rows, clear entire tables, and understand the difference between hard and soft deletes.

SQL INSERT INTO Statement | Adding Data to Tables

Learn how to add new records to your database using the SQL INSERT INTO statement. Covers syntax for partial and full row insertion.

SQL Multiple Inserts | Bulk Loading & Copying Data

Learn how to insert multiple rows in a single query and how to copy data from one table to another using INSERT INTO SELECT.

SQL SELECT Statement | Retrieving Data from Tables

Master the SQL SELECT statement. Learn how to fetch specific columns, use aliases, and perform calculations on retrieved data.

SQL UPDATE Statement | Modifying Existing Data

Learn how to modify records in a table using the SQL UPDATE command. Understand how to update single or multiple columns safely with WHERE clauses.