Development

Oracle COS Function with Examples

Complete IT Professional - Thu, 2016-12-01 05:00
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

Gerger Consulting - Mon, 2016-11-28 18:45
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

Video:



Slides:

Categories: Development

11 Tips to Improve Focus and Concentration at Work

Complete IT Professional - Mon, 2016-11-28 05:00
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

Complete IT Professional - Mon, 2016-11-28 05:00
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

Complete IT Professional - Thu, 2016-11-24 05:00
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

Complete IT Professional - Tue, 2016-11-22 05:00
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!

Gerger Consulting - Mon, 2016-11-21 13:59
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.


Categories: Development

12 Great Tips on How To Be More Professional At Work

Complete IT Professional - Mon, 2016-11-21 13:00
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

Complete IT Professional - Mon, 2016-11-21 05:00
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

Complete IT Professional - Fri, 2016-11-18 05:00
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

Complete IT Professional - 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

Complete IT Professional - 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

Version Control for PL/SQL

Gerger Consulting - Mon, 2016-11-14 15:47
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.

170+ people have already signed up! :-) Register at this link.


Categories: Development

12 Tips for Finding an IT Job on Twitter

Complete IT Professional - 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

Complete IT Professional - 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

Complete IT Professional - 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

Complete IT Professional - 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

Complete IT Professional - 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

Complete IT Professional - 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

Complete IT Professional - 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

Pages

Subscribe to Oracle FAQ aggregator - Development