Complete IT Professional

Subscribe to Complete IT Professional feed Complete IT Professional
Practical advice for database developers
Updated: 17 hours 17 min ago

Oracle NANVL Function with Examples

Wed, 2016-09-21 06:00
The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). It’s useful for floating-point numbers such as […]
Categories: Development

Creating a Web App – One Year On

Mon, 2016-09-19 06:00
One year ago I decided to create a web app for an organisation a friend of mine works with. I’d like to share where it’s at and what I’ve learnt. One Year On I wrote a post where I decided to create a web app. It’s a customised reporting tool for a group of sports […]
Categories: Development

Oracle DECOMPOSE Function with Examples

Thu, 2016-09-15 06:00
The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article. Purpose of the Oracle DECOMPOSE Function The DECOMPOSE function is used to transform a string into a Unicode string. It will split a character with an accent into two separate characters. For example, […]
Categories: Development

How I Organise Email At Work To Keep Track Of It All

Mon, 2016-09-12 06:00
Email. It can be a mess. Have you ever looked at your inbox at work and seen a massive list of emails, and not know what to do with them? I used to get that as well. This was until about a year ago when I changed the way I handle my email at work. […]
Categories: Development

Oracle COMPOSE Function with Examples

Thu, 2016-09-08 14:40
In this article, I’ll explain what the Oracle COMPOSE function is and show you some examples. Purpose of the Oracle COMPOSE Function The COMPOSE function allows you to provide a string or a string expression, and return a Unicode string of that input. It’s helpful for turning letters and accent characters into an accented letter. […]
Categories: Development

Why Do Some Companies Have Teams with People from Multiple Contracting Companies?

Mon, 2016-09-05 06:00
Do you work for a company that hires contractors? Have you ever wondered why they use several companies instead of just going to one company for all of their work? This happens quite often, so i wanted to explain why it happens. Why would this be good to know? If, like me, you work for a contracting company, it’s good to […]
Categories: Development

Oracle TO_LOB Function with Examples

Thu, 2016-09-01 14:05
The TO_LOB function is an Oracle conversion function. Learn what it is and see some examples in this article. Purpose of the Oracle TO_LOB Function The purpose of the TO_LOB function is to convert LONG or LONG RAW values to LOB values.   Syntax The syntax of the TO_LOB function is: TO_LOB ( long_value ) […]
Categories: Development

Oracle LOCALTIMESTAMP Function with Examples

Thu, 2016-09-01 06:00
In this article, I’ll explain what the Oracle LOCALTIMESTAMP function does and show some examples. Purpose of the Oracle LOCALTIMESTAMP Function The LOCALTIMESTAMP function will return the current date and time of the session time zone. This means it’s likely in the time zone that you’re located in (as opposed to the server time zone). […]
Categories: Development

What Does Oracle PARTITION BY Do?

Mon, 2016-08-29 06:00
Have you ever seen the PARTITION BY keyword used in Oracle queries? If so, do you know what it does and how to use it? Learn about the Oracle PARTITION BY keyword and see some examples in this article. What is the Oracle PARTITION BY Keyword? PARTITION BY is a keyword that can be used […]
Categories: Development

Oracle ASCIISTR Function with Examples

Thu, 2016-08-25 16:17
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 characters that are not ASCII, they are converted to a format […]
Categories: Development

Oracle DBTIMEZONE Function with Examples

Thu, 2016-08-25 06:00
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 region name. It’s helpful when working with dates to know what timezone the database […]
Categories: Development

65 Business Jargon Phrases to Stop Using and What Do Use Instead

Mon, 2016-08-22 06:00
If you’ve worked in an office for any length of time, you’ve probably heard one of these phrases. A phrase that makes no sense at all unless you explain it. A word that is used by management in not quite the correct way. A sentence that has a bunch of words but doesn’t really say […]
Categories: Development

Oracle TO_NCLOB Function with Examples

Fri, 2016-08-19 06:00
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 may not use it very often, […]
Categories: Development

Oracle TO_CLOB Function with Examples

Thu, 2016-08-18 06:00
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).   Syntax The syntax of the TO_CLOB function is quite […]
Categories: Development

5 Stages of the Software Development Cycle

Mon, 2016-08-15 16:46
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 procedure can differ from business to business, but the standards remain firm. The software development […]
Categories: Development

Oracle STDDEV Function with Examples

Fri, 2016-08-12 06:00
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. The standard deviation is a mathematical concept, which is […]
Categories: Development

Oracle BFILENAME Function Explained with Examples

Thu, 2016-08-11 06:00
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 and filename. This function is often used in PL/SQL to access the data […]
Categories: Development

Why Asking Myself How To Add Value At Work Is The Best Thing I’ve Done This Month

Mon, 2016-08-08 06:00
I’ve been doing something at work which has been getting great results. I only started doing a lot of it a few weeks ago. But, I’ve had a few people notice, and I can see the positive impact it’s having on the team. I want to share it in this article so you can try […]
Categories: Development

Oracle SESSIONTIMEZONE Function with Examples

Thu, 2016-08-04 06:00
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 time zone region name. This can be helpful to know, especially if you’re doing a lot of […]
Categories: Development

Oracle 12c New Features for Developers

Mon, 2016-08-01 06:00
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 developers, and some of them are more focused on database administrators. […]
Categories: Development

Pages