All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
How the Change Tracking Feature Works in SQL Server – Querychat
In this article, we learn how the change tracking feature works in SQL Server for a database table changes. Providing examples of tracking DML changes to a table specified with the SQL Server CHANGETABLE function. SQL Server provides tracking mechanism features in all editions since version 2008. It tracks Data...
The Difference Between DELETE And TRUNCATE in Oracle – Querychat
In this article, we will discover the syntax of the DELETE and TRUNCATE commands.. Also, we will find out the difference between these two commands. The Oracle DELETE command syntax This command allows us to delete one specific row (or more) from our table based on a condition. We can...
MySQL Select and Delete Top 10 Rows – Querychat
Sometimes we need to know the top 10 (or any other number) list of items or names that are the first in our result set. In this article, we will discover how to select and delete the top 10 rows in MySQL using some examples.  MySQL SELECT  Let’s start by...
SQLite Case Insensitive Comparison – Querychat
In this article, we will discover how to make SQLite ignore case when comparing strings. There are two ways to do this; one way is by using the LOWER and UPPER functions and the other way is by using SQLite COLLATE NOCASE comparing function.  Case insensitive query with LOWER and...
SQLite Full Text Search – Querychat
In this article, we will discover what is Full Text Search in SQLite, also known as FTS, how it works and how we can use it. We will consider some examples as well. What is SQLite FTS Using the FTS we can find the word we are looking for in...
Alternatives to ISNUMERIC Function in Oracle – Querychat
In this article, we will discover how to check whether a value is numeric or not in Oracle. We will use several functions such as TRANSLATE, REGEXP_LIKE, and TO_NUMBER, which are alternatives to SQL ISNUMERIC function. We will start with the basic concepts of NUMBER data type and then discuss...
Oracle SQL Query To Remove Duplicates – Querychat
In this article, we will deal with the problem of duplicates in our tables. We will discover the query to find and remove duplicates in Oracle. Do not be afraid, this task is easier than it seems, we will give the illustrative examples. Getting started Let’s create a table with...
How to Fix the SQLite No Such Column Error – Querychat
In this article, we will talk about the “no such column” SQLite error, that anyone can have. We can be absolutely sure that the column exists, but the SQLite cannot see it. Here we will find the solution to fix this problem. Reasons for the SQLite “no such column” error...
How to Parse a String in Oracle SQL – Querychat
In this example, we will discover how to operate with comma-separated values and the values that we need to be separate. In this article, we will find out how to do this with the use of REGEXP_SUBSTR. Oracle REGEXP_SUBSTR syntax In Oracle, we have a REGEXP_SUBSTR, which can help us...
SQL Server: Fill columns with increment numbers – Querychat
Unique numbers of data in a database table can be created in several ways. One of them is the incremental numbers that generate a sequence of numerical values. A sequence in incremental numbers can be done when creating a table structure with columns given the IDENTITY property. The following is...
1 2 13 14