Skip to content

Category: SQL

Handling NULL value in SQL

In this article we will quickly look how to handle the NULL value in an SQL table. A field with a NULL value is a field with no value. The […]

Alter table column size in Oracle

In this post, we will learn how to modify the size of an column in an Oracle table. It’s easy to alter the column size using the ALTER TABLE MODIFY statement. Sometimes […]

Oracle INSERT INTO SELECT

In this post, we will see how to insert a data into a table with the result of select statement. Sometimes we want to move the data from one table […]

Import CSV files into MySQL table

In this quick post, let’s see how to import data from csv formatted files into MySQL / MariaDB table. MySQL provides LOAD DATA LOCAL INFILE command to import data from […]

Escape Single quote in SQL

Inserting string with special characters is a pain in the butt, it would seem. It’s easy to escape a string with single quote or ampersand in SQL statements. To escape […]