Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
Oracle INITCAP Function with Examples

Oracle INITCAP Function with Examples

The Oracle INITCAP function is a handy string manipulation function. Learn what it does and see some examples in this article. Purpose of the Oracle INITCAP Function The Oracle INITCAP function translates a specified string into another string which has the first...
Oracle LOWER Function with Examples

Oracle LOWER Function with Examples

In this article, I’ll take a look at the Oracle LOWER function, explain how it works, and see some examples. Purpose of the Oracle LOWER Function The LOWER function converts all letters within the specified string to lower case.   Syntax The syntax for the...
Oracle RAWTOHEX Function with Examples

Oracle RAWTOHEX Function with Examples

The Oracle RAWTOHEX function is a simple conversion function. Learn how to use it and see some examples in this article. Purpose of the Oracle RAWTOHEX Function The purpose of the RAWTOHEX function is to convert from a RAW value into a hexadecimal value. As mentioned...
Oracle HEXTORAW Function with Examples

Oracle HEXTORAW Function with Examples

The Oracle HEXTORAW function is a basic conversion function used in Oracle SQL. Learn how to use it and see some examples in this article. Purpose of the Oracle HEXTORAW Function The purpose of the HEXTORAW function is to convert a hexadecimal value into a raw value....
What is the DUAL Table in Oracle?

What is the DUAL Table in Oracle?

Have you seen SQL statements with the word DUAL in them? Wondering what it is? Find out what the dual table in Oracle is in this article. The DUAL Table in Oracle You might have seen some SQL statements with the keyword DUAL in them. These would have been SELECT...
Oracle SOUNDEX Function with Examples

Oracle SOUNDEX Function with Examples

The Oracle SOUNDEX function is one of the most interesting functions I’ve used in Oracle. Learn what it is and how it works in this article. Purpose of the Oracle SOUNDEX Function The Oracle SOUNDEX function allows you to check what a value sounds like. It...
The Importance of Routine

The Importance of Routine

In the last two weeks, I’ve learnt about the importance of a routine. How does it relate to your career, and why should you care? The Last Two Weeks So, you might have noticed there hasn’t been a post on Complete IT Professional in the last week or so. I...
Oracle CURRENT_DATE Function with Examples

Oracle CURRENT_DATE Function with Examples

The Oracle CURRENT_DATE function is another Oracle function for returning a date from the system. Find out what it does and how it’s different from the other functions in this article. Purpose of the Oracle CURRENT_DATE Function The CURRENT_DATE function is used...