Replace is most common in the production environment. There are many occasions we need to do data manipulation in the application
The SQL functions are highly beneficial for SQL developers and ETL developers. Read best examples on TRIM, LTRIM and RTRIM.
Source: It career coach SQL QUERY DEVELOPMENT MODULE 1: THE SELECT STATEMENT What is the SELECT statement? How to eliminate
The four different types of SQL functions to read quickly and to get knowledge instantly.
RDBMS means relational database management system. This post gives an idea on top rdbms databases.
As a routine, I am listening to mind music. Then I got an idea to write a post on DB2
DB2 performance you can improve by following these ideas useful for your project.
DB2 SQL error codes given for interviews as well as to use in your development or production support project.