Complete IT Professional

Helping Software Developers Get Ahead In Their Careers
Oracle 12c New Features for Developers

Oracle 12c New Features for Developers

Oracle 12c is Oracle’s latest version of their database engine. Learn about all of the new Oracle 12c new features for developers in this massive guide. Introduction Oracle 12c comes with a range of new features. Many of these features are great improvements for...
Oracle FROM_TZ Function with Examples

Oracle FROM_TZ Function with Examples

In this article, I’ll explain what the Oracle FROM_TZ function is and show you some examples. Purpose of the Oracle FROM_TZ Function The purpose of the FROM_TZ function is to convert a TIMESTAMP value and a specified TIME ZONE to a TIMESTAMP WITH TIME ZONE...
Oracle TZ_OFFSET Function with Examples

Oracle TZ_OFFSET Function with Examples

The Oracle TZ_OFFSET function is a useful datetime function. Learn how to use this function and see some examples in this article. Purpose of the Oracle TZ_OFFSET Function The purpose of the TZ_OFFSET function is to display a number that indicates the number of hours...
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....