Category Archives: Oracle

All notes on Oracle..

Creating a JAVA Stored procedure on Oracle

In this blog, we will see how we can create a simple JAVA class on Oracle and calling the class using a simple function. Without taking more time, let us create one user on the Oracle database and then define a JAVA class and associate it with one Oracle function. Create one user to test […]
Read More »

OLE DB connection error while connecting Oracle database using SSIS

In this blog, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services. SQL Server Integration Service (SSIS) is a Microsoft product which is mainly used for automating importing and exporting data or Extract, transform and load i.e. ETL.  Here is the […]
Read More »

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 »

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 »

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 »

Using SQL Scripts in Oracle Application Express

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express. How it can be really helpful to use SQL scripts under SQL Workshop?Let us take an example […]
Read More »