A Guide to the Oracle TRUNCATE TABLE Statement

A Guide to the Oracle TRUNCATE TABLE Statement

The Oracle TRUNCATE TABLE statement is a useful statement for removing data in Oracle SQL. I’ll explain what the statement does and show you some examples in this article. What Does the Oracle TRUNCATE TABLE Statement Do? The Oracle TRUNCATE statement, or...
Oracle MEDIAN Function with Examples

Oracle MEDIAN Function with Examples

In this article, I’ll explain what the Oracle MEDIAN function is, and show you some examples. Purpose of the Oracle MEDIAN Function The MEDIAN function returns the median of the set of provided values. The MEDIAN is the middle value in a set of values. So, for...
Oracle SINH, COSH, and TANH Functions with Examples

Oracle SINH, COSH, and TANH Functions with Examples

In this article, I’ll cover what the Oracle SINH, COSH, and TANH functions are, and show you some examples. Purpose of the Oracle SINH, COSH, and TANH Functions These three functions are used to calculate the hyperbolic sine, cosine, or tangent of a number:...
What Is Professional Networking and Why Should I Do It

What Is Professional Networking and Why Should I Do It

Networking is a common term in the IT industry. It can have two meanings – the process of linking computers and other devices together so they can communicate, and the process of meeting and talking to other people to help your IT career. This article is about...
A Guide to the Oracle UPDATE Statement

A Guide to the Oracle UPDATE Statement

Have you ever needed to update data that was already in a table in Oracle? Learn how to do this with the Oracle UPDATE Statement. What Is the Oracle UPDATE Statement? The Oracle SQL UPDATE statement allows you to change data that is already in a table in SQL. The...
Oracle SQRT Function with Examples

Oracle SQRT Function with Examples

In this article, I’ll explain the Oracle SQRT function and show you some examples. Purpose of the Oracle SQRT Function The purpose of the Oracle SQRT function is to find and return the square root of a provided number. The square root of a particular number...
Oracle LNNVL Function with Examples

Oracle LNNVL Function with Examples

In this article, I’ll explain what the Oracle LNNVL function does and show you some examples. Purpose of the Oracle LNNVL Function The purpose of the LNNVL is to perform a “logical not null” on the expression that has been provided. It allows you to...
Why You Need a Long Term Career Plan and How to Create One

Why You Need a Long Term Career Plan and How to Create One

Why should you have a career plan? Do you even need to know what your job will be in the long term? Learn why and how to create a career plan in this article. The answer is “yes”. You need to know what your career will look like, long term. Or at least...
A Guide to the Oracle ALTER TABLE SQL Statement

A Guide to the Oracle ALTER TABLE SQL Statement

The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide. What Is The Oracle ALTER TABLE Statement? The ALTER TABLE SQL statement lets you change a table that has already been created....
Oracle LN Function with Examples

Oracle LN Function with Examples

In this article, I’ll explain what the Oracle LN function is, and show you some examples. Purpose of the Oracle LN Function The purpose of the Oracle LN function is to calculate the natural logarithm of a number. if you’re not sure what the natural...