Do you need to create a table in MySQL? We show you how to do it with a small example. Continue reading “MySQL database table creation”
The Oracle DECODE function
The Oracle DECODE function can be considered an IF/ELSE variation. It compares the very same expression with other or others. Continue reading “The Oracle DECODE function”
Listing all columns from an Oracle database
In this short post, we are going to learn how to list all columns of every table in an Oracle database.
We want to get the name of the column, the name of the table it belongs to and the type of date for that column. Continue reading “Listing all columns from an Oracle database”
Oracle date format
Let’s review Oracle date formatting.
This is useful for functions like TO_DATE, TO_CHAR or alter session to modify nls_date_format. Continue reading “Oracle date format”
Oracle numeric format
Let’s take a look at the Oracle numeric format masks. Continue reading “Oracle numeric format”
The Oracle NULLIF function
The NULLIF function evaluates two expressions in the following way:
- If they are equal, it returns NULL.
- If they are not equal, it returns the first expression.