Complete IT Professional

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

Oracle CUME_DIST Function with Examples

Thu, 2016-11-17 05:00
In this article, I’ll cover what the Oracle CUME_DIST function is and show you some examples. Purpose of the Oracle CUME_DIST Function The purpose of the CUME_DIST function is to find the cumulative distribution of a value in a list of values. The value that is returned will be between 0 and 1. The function […]
Categories: Development

Oracle TO_DATE Function Explained with Examples

Mon, 2016-11-14 21:26
The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I’ll explain how to use the TO_DATE function in this article. Purpose of the Oracle TO_DATE Function The purpose of the TO_DATE function in Oracle is to convert a character value to a […]
Categories: Development

12 Tips for Finding an IT Job on Twitter

Mon, 2016-11-14 05:00
Twitter is one of the most important and most popular social networking sites. It can also be used for finding a job in the IT industry. As of 2016, Twitter has: 310 million monthly active users Average of 500 million tweets per day One great way you can use Twitter is to find a job […]
Categories: Development

50 Awesome Career Tips For IT Professionals

Sun, 2016-11-13 21:00
The IT industry is a large field, and as a result, it can be hard to stand out from the rest of the people in the industry. There are some things you can do to improve your career, improve the way you do work, and make yourself look better for your company. Have a read […]
Categories: Development

Oracle CHARTOROWID Function with Examples

Thu, 2016-11-10 12:11
In this article, I’ll explain what the Oracle CHARTOROWID function is and show you an example. Purpose of the Oracle CHARTOROWID Function The purpose of the CHARTOROWID function is to convert a value from a several character data types into a ROWID data type. The supported data types that this function can convert are: CHAR […]
Categories: Development

The Complete Guide to the Oracle INSERT INTO Statement

Mon, 2016-11-07 05:00
The Oracle INSERT INTO statement is one of the most popular commands in Oracle, and it’s one of the first commands you learn to use. Read how to insert data and how to use the full functionality of the INSERT statement in this guide. What Is the INSERT INTO Oracle Statement? The Oracle INSERT INTO […]
Categories: Development

Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions

Thu, 2016-11-03 06:00
In this article, I’ll explain how to use the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH functions with some examples. I’ve grouped all of these functions into a single article because they are quite similar and are related functions. Purpose of the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions The purpose of these functions […]
Categories: Development

How To Create a Pivot Table Structure in SQL

Mon, 2016-10-31 06:00
As part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article. What Did I Need To Do? For the web app, I needed to output a table of data. This table needed to display row […]
Categories: Development

Oracle GROUP_ID Function with Examples

Thu, 2016-10-27 06:00
In this article, I explain what the GROUP_ID function does and show you some examples. Purpose of the Oracle GROUP_ID Function The GROUP_ID function is used to assign a number to each group that results from a SELECT query clause with a GROUP BY clause. It’s used to identify any duplicate groups in your output, […]
Categories: Development

A Guide to the Oracle Data Types

Mon, 2016-10-24 06:00
In this article, I explain what the different data types are in Oracle database and everything you need to know about them. What You’ll Learn about Oracle SQL Data Types There are many data types in the Oracle database. There are character, number, date, and other data types. When you create a table, you need to […]
Categories: Development

Oracle EMPTY_CLOB Function with Examples

Thu, 2016-10-20 06:00
In this article, I’ll explain what the EMPTY_CLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_CLOB Function The EMPTY_CLOB function is used to initalise a CLOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising a […]
Categories: Development

Why I Moved from CompleteITProfessional to DatabaseStar

Sun, 2016-10-16 13:26
Complete IT Professional has been renamed and rebranded to Database Star. I’ll explain what that means and why I made this change in this article. What Was The Change? You’re probably reading this on the new DatabaseStar.com website, wondering why you’re here instead of on CompleteITProfessional.com. Well, the reason is that I have decided to […]
Categories: Development

OTN Appreciation Day: Easy Execution Plans

Tue, 2016-10-11 13:54
As part of the #ThanksOTN idea on Twitter, my favourite Oracle feature is the ability to easily view and analyse execution plans for queries. Time and time again I’ve needed to see how a query is running, and Oracle databases make it easy to view the execution plan. You can view it in either a text format […]
Categories: Development

4 Things To Spend Money On for Work

Mon, 2016-10-10 06:00
There are many things that your workplace will provide as part of your employment. Notebooks, pens, computer, and a chair. There are some other things that, if you spend money on, they can really improve the quality and efficiency of your work. 1 – A Decent Pen Every office I’ve worked in has had a […]
Categories: Development

Oracle EMPTY_BLOB Function with Examples

Thu, 2016-10-06 06:00
In this article, I’ll explain what the Oracle EMPTY_BLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_BLOB Function The EMPTY_BLOB function is used to initalise a LOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising […]
Categories: Development

Overview of Oracle Character Sets

Mon, 2016-10-03 06:00
I’ve been working with databases for a long time, and the topic of character sets took me a while to understand. This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database. What is a Character Set? As defined by Webopedia: […]
Categories: Development

Oracle TO_SINGLE_BYTE Function with Examples

Thu, 2016-09-29 06:00
The Oracle TO_SINGLE_BYTE function is useful for databases with different character sets. Learn how to use it and see some examples in this article. Purpose of the Oracle TO_SINGLE_BYTE Function The purpose of the TO_SINGLE_BYTE function is to convert a string with multi-byte characters into single-byte characters. To use this function, your database character set needs […]
Categories: Development

Oracle NCHR Function with Examples

Wed, 2016-09-28 06:00
In this article, I’ll explain what the Oracle NCHR function is and show some examples. Purpose of the Oracle NCHR Function The NCHR function returns a character based on the specified number code in the national character set. It’s very similar to the CHR function, but it uses the national character set.   Syntax The […]
Categories: Development

How to Calculate the Mean, Median, and Mode in Oracle

Mon, 2016-09-26 06:00
Calculating the mean, median, and mode in Oracle SQL is a task often performed by report developers or anyone else working with SQL. Learn how to calculate these three values from a range of data in this article. What is the Mean, Median, and Mode? Mean, median, and mode are three kinds of average values […]
Categories: Development

Oracle NEW_TIME Function with Examples

Thu, 2016-09-22 06:00
In this article, I’ll explain what the NEW_TIME function does and show you some examples. Purpose of the Oracle NEW_TIME Function The NEW_TIME function converts a date from one timezone to another timezone.   Syntax The syntax of the NEW_TIME function is: NEW_TIME ( input_date, timezone1, timezone2 )   Parameters The parameters of the NEW_TIME […]
Categories: Development

Pages