# Development

### 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 evaluate data that contains a NULL value, which is something […]

Categories: Development

### Markus Winand on Database Optimizers

If you are a DBA or a developer and would like to learn more about database optimizers, there is no one better in the world than Markus Winand to learn from!

Markus is hosting a free webinar on December 15th. Attend his webinar and learn how you can build better performing applications.

Register at this link.

Markus is hosting a free webinar on December 15th. Attend his webinar and learn how you can build better performing applications.

Register at this link.

Categories: Development

### 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 have an […]

Categories: Development

### 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. Using the CREATE TABLE statement lets you create […]

Categories: Development

### 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 logarithm means, you can read more here. I’m not a […]

Categories: Development

### Oracle TAN Function with Examples

In this article, I’ll explain the Oracle TAN function, what it is, and show you some examples. Purpose of the Oracle TAN Function The purpose of the Oracle TAN function is to calculate the tangent of a number. The tangent is ratio of the length of the side opposite the angle to the length of the […]

Categories: Development

### Oracle Certification Dumps Can Ruin Your Career

Are you looking to get certified? Want to get your hands on some Oracle certification dumps for an exam to help you pass? That’s a bad idea. I’ll explain why in this article. What Is a Brain Dump? So what is a brain dump, when you talk about IT certifications? A brain dump is a […]

Categories: Development

### New York OUG Winter Event

On December 7th, Gitora founder Yalim Gerger will be at the NYOUG Winter Event to talk about version control of PL/SQL using Git. Click here for the full agenda. We hope to see you there!

Categories: Development

### Oracle SIN Function with Examples

In this article, I’ll explain what the Oracle SIN function is and show you some examples. Purpose of the Oracle SIN Function The purpose of the SIN function is to calculate the sine of a number. The sine is the ratio of the length of the side of the triangle opposite the angle to the […]

Categories: Development

### Oracle COS Function with Examples

In this article, we look at the Oracle COS function and see some examples. Purpose of the Oracle COS Function The COS function will return the cosine of a number. If your knowledge of cosine is a bit rusty (like mine), then you might find this definition helpful. Syntax The syntax of the COS […]

Categories: Development

### Video&Slides: Version Control for PL/SQL

Last week we hosted a webinar about how PL/SQL developers can manage their PL/SQL code bases with Gitora, the version control tool for PL/SQL. Many thanks to everyone who attended. You can watch the recording of the webinar and view the slides below.

The webinar consist of two parts:

1) Version Control Strategies for PL/SQL

2) Live Demo of Gitora

The webinar consist of two parts:

1) Version Control Strategies for PL/SQL

2) Live Demo of Gitora

**Video**:**Slides:**
Categories: Development

### 11 Tips to Improve Focus and Concentration at Work

Do you often find yourself not focusing at work? Or, you try to focus, but something else comes along and distracts you? I know how this feels. I’ve listed eleven ways to remove distractions and increase focus in this article. I’ve been able to improve my focus by removing some of the distractions I have […]

Categories: Development

### A Guide to the Oracle DROP TABLE Statement to Delete Tables in SQL

How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article. How Can I Delete a Table in Oracle SQL? To delete a table in Oracle SQL (or any SQL for that matter), you run a statement called DROP TABLE. It’s called DROP because […]

Categories: Development

### Oracle VARIANCE Function with Examples

In this article, I’ll explain what the Oracle VARIANCE function is, and show you some examples. Purpose of the Oracle VARIANCE Function The purpose of the VARIANCE function is to, well, return the variance of a set of numbers. A variance is a mathematical concept, which represents how different the values are in a set […]

Categories: Development

### Oracle CORR Function with Examples

In this article, I’ll explain what the Oracle CORR function does and show you some examples. Purpose of the Oracle CORR Function The Oracle CORR function returns the “coefficient of correlation” of a set of number pairs. What is a coefficient of correlation? Here’s an definition of what it means. This function can be used […]

Categories: Development

### Version Control for PL/SQL webinar now at 376 signups!

Many thanks to 376 people who have registered already!

We are hosting a free webinar to talk about how to manage PL/SQL code bases. Attend and learn how you can use Gitora, our new product that links Oracle Database to Git, to manage your PL/SQL source code.

Register at this link.

We are hosting a free webinar to talk about how to manage PL/SQL code bases. Attend and learn how you can use Gitora, our new product that links Oracle Database to Git, to manage your PL/SQL source code.

Register at this link.

Categories: Development

### 12 Great Tips on How To Be More Professional At Work

Professionalism in the IT world is desirable. Some people have it, some don’t. The ones that do have it, the ones that are professional, are treated with more respect and are usually better at their jobs. Below, I share five tips that you can use to be more professional in your workplace. Dress Code Wherever […]

Categories: Development

### Oracle DELETE SQL Statement – The Complete Guide

The DELETE SQL statement allows you to delete records from a table. I’ll explain more about the Oracle DELETE SQL statement in this article. What Is The Oracle DELETE SQL Statement? The Oracle DELETE SQL statement is a statement you can run to delete records from a table. There are statements to INSERT and UPDATE […]

Categories: Development

### Oracle BIN_TO_NUM Function with Examples

In this article, I explain what the Oracle BIN_TO_NUM function does and show you some examples. Purpose of the Oracle BIN_TO_NUM Function The BIN_TO_NUM function converts a bit vector to a number. A bit vector is a combination of values to make up a binary number. For example, the binary value of 1 is equal […]

Categories: Development

### Oracle CUME_DIST Function with Examples

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