Complete IT Professional

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

Oracle ASCIISTR Function with Examples

In this article, I’ll explain what the Oracle ASCIISTR function does, and show you some examples. Purpose of the Oracle ASCIISTR Function The ASCIISTR function converts a string in any character set to a string in the database character set. If there are any...
Oracle DBTIMEZONE Function with Examples

Oracle DBTIMEZONE Function with Examples

In this article, I’ll explain what the Oracle DBTIMEZONE function does, and show you some examples. Purpose of the Oracle DBTIMEZONE Function The DBTIMEZONE function returns the timezone offset of the database, in the format of [+|-]TZH:TZM, or a time zone...
Oracle TO_NCLOB Function with Examples

Oracle TO_NCLOB Function with Examples

The Oracle TO_NCLOB function is a simple function and is used for conversion. Learn what it does and see some examples in this article. Purpose of the Oracle TO_NCLOB Function The purpose of the TO_NCLOB function is to convert a value from a LOB to an NCLOB value. You...
Oracle TO_CLOB Function with Examples

Oracle TO_CLOB Function with Examples

In this article, I’ll take a look at the Oracle TO_CLOB function, and show you some examples. Purpose of the Oracle TO_CLOB Function The TO_CLOB function converts a value in an NCLOB column (the national character set) to a CLOB (in the database character set)....
5 Stages of the Software Development Cycle

5 Stages of the Software Development Cycle

This is a guest post by Saurab Prabhakar. The Software Development Lifecycle (SDLC) defines a revolution. It is fundamentally a sequence of steps that display a model for the development and lifecycle management of certain software or even an application. The...
Oracle STDDEV Function with Examples

Oracle STDDEV Function with Examples

Have you ever seen the Oracle STDDEV function? In this article, I’ll explain what the STDDEV function does and show you some examples. Purpose of the Oracle STDDEV Function The purpose of the STDDEV function is to find the standard deviation of a set of numbers....
Oracle BFILENAME Function Explained with Examples

Oracle BFILENAME Function Explained with Examples

The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article. Purpose of the Oracle BFILENAME Function The BFILENAME function returns an object called a “BFILE locator” from a specified directory...
Oracle SESSIONTIMEZONE Function with Examples

Oracle SESSIONTIMEZONE Function with Examples

In this article, I’ll explain what the Oracle SESSIONTIMEZONE function is, and show you some examples. Purpose of the Oracle SESSIONTIMEZONE Function The SESSIONTIMEZONE function returns the timezone offset of your session, in the format of [+|-]TZH:TZM, or a...