Author Archives: slobaexpert

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 »

Install JDK9 on Linux Mint

In this article we will see how we can install JDK9 i.e. Oracle Java 9 on Linux mint version. Execute the below commands in sequence on Linux Mint machine: While executing the above you will see the get the aggrement options where we need to click ok and proceed. After the above steps setup Java […]
Read More »

0% [Connecting to archive.ubuntu.com ] Error

I encountered this error while using “apt-get” command on  my Linux mint server and it got stuck for 12-3 mins. Here is the details on my error that I faced : The issue is on the IPv6 taking more time to execute. Now let us check if my IPv6 is enabled or disabled. Based on […]
Read More »

Append row into a CSV file on SFTP

In this post I am going to show how we can append a row into CSV file using simple bash command. To demonstrate this I am using Linux virtual machine, the OS is on Mint 18.3 64bit.  First me create a sample file on my Linux Machine as like below. Once the file is created […]
Read More »

Reorder the columns in CSV file using Python

Many time we work on files to load or process the flat files. In this post, I am showing if we receive the file but the columns are not in order then how to rearrange them in the right format. There are multiple ways to handle this but here I am using a simple python […]
Read More »

Access Windows shared directory from Ubuntu 16.04.3 LTS VirtualBox Guest

In this post I am going to show how to access windows shared directory from Ubuntu 16.04.3 LTS virtual machine. First create a directory on the host. For example I am creating one directory called on my E drive [ My host is Windows 7 ] . Now open VirtualBox go to settings of your Ubuntu […]
Read More »