Introduction to Rank Function in Oracle

In this blog, we will see how to use the RANK analytical function in an Oracle database and how it helps us in an analysis. What is the RANK function? The RANK function is an Oracle analytical function which calculates the rank of values which are retrieved, or against a set of rows. The same […]
Read More »

Partition By Clause in Oracle

An introductory discussion about how to use Partition by Clause in Oracle. What is a “partition by” clause in Oracle? It is used to break the data into small partitions and is been separated by a boundary or in simple dividing the input into logical groups. The analytical functions are performed within this partitions.  So […]
Read More »

Installing Oracle 18c on Windows Operating system

In this article, we will see how to install Oracle 18c on the Windows operating system.  To install 18c first we need to download the setup from Oracle.com. In my case, I have already downloaded and extracted locally on my windows machine. The below file will show the step by step guide on how to […]
Read More »

Tuples in Python

In this article, we will see what are Tuple and how we use them in Python programming. Tuples:   Tuples are one of the built-in types of sequences out of six and just like lists. There is another article published on how to use Lists in Python. We want to store the values for the rest of our […]
Read More »

Logical Operators in Python

In this article, we will see what is the logical operator and how we use them in Python programming. Logical Operators: There are basically three types of logical operators as below: And Or Not There above operators semantics or meaning is the same as their meaning in English.  To demonstrate we can take one simple […]
Read More »

Boolean in Python

In this article, we will see how to use Boolean in Python where it can be used to take any decisions if it is true or false, yes or no,  1 or 0. What is Boolean? It is just an integer that can have 1, 0,-1 or floats like 0.32, 3.32 etc. The output of the […]
Read More »

Using Break condition in Python

This article will show a step by step guide on how use Break in Python In many use cases, or due to certain business rules, we need to exit a loop in any programming language. Or, we need to stop a particular loop and continue with the rest of the code. This article will help […]
Read More »

Analytic Functions in Oracle

An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows. Analytic functions are used to calculate or compute aggregate values based on a group of rows, it is also called as a Window. This determines the range of rows used to perform the […]
Read More »

Using full redaction for masking the column values in 12c

This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle’s Advanced Security.   Why would we need to mask a column’s data? One of the most common uses is […]
Read More »

This article will show the step by step guide to install Tableau Business intelligence tool on Windows operating system.

Tableau is another powerful business intelligence application or tool which is used by many business users to represent the date virtually to get more inside on it. This tool can be connected to any type of data source, it can be live or an extract like CSV, Excel, text files etc… There are other tools […]
Read More »