Author Archives: slobaexpert

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 »

Getting monthly data with latest records in oracle

In this blog I am going to show how we can get monthly data for a given set of records. In many cases we try to get the data into reports with monthly , weekly etc. To achive this we can use N number of tools which are provided but sometime we have to write […]
Read More »

SQL Error: ORA-00921 in Oracle 12c

How to solve if you get SQL error “ORA-00921” while dropping an existing user in Oracle 12c. I got one user existing on my database called “SLOBA”. Now let us try to drop it.   Output as error:   Now alter the system session “_oracle_script” to true. Output : Now let us try to drop […]
Read More »