-
Continue reading →: Generating an API Signing Key through OCI Console
In this post, we will look into the step-by-step process of how you can generate a private key/public key pair from the OCI Console. When the OCI console is used to generate the API signing key pair, a configuration file preview snippet is generated with the following keys and OCIDs.…
-
Continue reading →: Step-by-Step Guide to Oracle Database API for MongoDBUsing Oracle Database API for MongoDB, you can manipulate collection of JSON documents stored in an Oracle Database. If you are using ORDS version 22.3 or later, then you can use Oracle Database MongoDB API with any Oracle Database Release 21c or later, or Oracle Autonomous Database 19c or later(serverless,…
-
Continue reading →: Configuring Oracle Cloud Infrastructure (OCI) Bastion ServiceOracle Cloud Infrastructure Bastion provides restricted and time-limited access to target resources that don’t have public endpoints. Bastions let authorized users connect from specific IP addresses to target resources using Secure Shell (SSH) sessions. The target instance can be a compute instance or a DB system, an Autonomous Database for Transaction Processing…
-
Continue reading →: Oracle Database 23ai: Boolean Data TypeThe Boolean Data Type has been introduced in Oracle Database 23ai. In this post, we will look at how we can use this new data type. Let us create a table called INVOICES with two columns – Invoice Number and Paid Status. We use the Boolean Data Type for the…
-
Continue reading →: Oracle Database 23ai: Direct Joins for UPDATE and DELETE Statements
Oracle 23ai allows directs joins in update and delete statements. Let us understand how this works. Lets say we have two tables DEPARTMENT1. SQL> SELECT * FROM department_1; DEPTNO DNAME LOC_________ _____________ ___________ 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON And DEPARTMENT_2. SQL> SELECT…
-
Continue reading →: Oracle Database 23ai : Group By and Having using Column Aliases
Oracle Database 23ai allows us to use Column Aliases in GROUP BY and HAVING clauses. It also allows us to use Column-position in GROUP BY clause. Let’s see, how. To demonstrate this enhancement, we will work with the EMP table and the DEPT table. SQL> SELECT * from emp; EMPNO…
-
Continue reading →: Uploading File from OCI Object Storage to Oracle Autonomous DatabaseI have shown in my previous post, how you can create an Oracle ATP Database 23ai on Oracle Cloud free Tier. In this post let us understand, how we can create Upload a File containing data from OCI Object Storage to a table in the database, using the DBMS_CLOUD Package.…
-
Continue reading →: User Creation in ORACLE Cloud Autonomous Database 23aiIn my previous post, we saw how we can create an Autonomous Database 23ai on Oracle Cloud. In this post we will see, how we can create an user and connect to the user. User Creation To create an user, login to your OCI console. From the Navigation Menu, click…
-
Continue reading →: Oracle Autonomous Database 23ai on Oracle Cloud
In my previous posts, I had demonstrated how you can configure Oracle Database 23ai Free on Oracle VM or on docker. In this post, we will see how we can configure Oracle Autonomous Database 23ai on Oracle Cloud free Tier. It is fairly simple to setup. So let’s jump into…
-
Continue reading →: Oracle 23ai New Feature: Automatic SQL TranspilerWe know that both SQL and PL/SQL have their own execution engines. Every time we call a user defined PL/SQL function from a SQL query, or execute an SQL query in within a PL/SQL code, there is a context switch between the SQL and PL/SQL engines. The cost based optimizer…
-
Continue reading →: Oracle Database 23ai Vector Search in actionOracle has just announced the release of Oracle Database 23ai, the next long-term support release of the industry-leading Oracle Database, on 2nd May 2024. You can find the announcement here. The new release is packed with tons of new features, strongly focusing on artificial intelligence (AI) and developer productivity. In…
-
Continue reading →: ORA-40478: output value too large – JSON_SERIALIZE
In my previous posts, while explaining JSON Relational Duality Views, I mentioned that I encountered ORA-40478: output value too large. So, in this post, let’s look at the available options to by-pass ORA-40478. But first, the basics. Let’s understand what the JSON_SERIALIZE functions does. The function takes JSON data of…
-
Continue reading →: Oracle Database 23ai: JSON Relational Duality ViewsOracle has just announced the release of Oracle Database 23ai on 2nd May 2024. You can find the announcement here. The new release is packed with 300+ new features. One of the features introduced is the JSON Relational Duality View. In this post we will look at the basics and…
-
Continue reading →: Installing Oracle Database 23ai on DockerIn my previous post, I have shown how you can install Oracle Database 23ai Free in VirtualBox Box. In this post we will see the steps to configure Oracle Database 23ai Free on Docker. Prerequisites Download Docker from here. Installation Once you have installed Docker, login to Docker. Open up…
-
Continue reading →: Run SQL Developer from Microsoft VS CodeIf you have been using Oracle SQL Developer for decades, then there is news for you. Oracle SQL Developer is entering it’s new life!!! You can now run Oracle SQL Developer from Microsoft Visual Studio Code. Microsoft Visual Studio Code is one of the top development platforms available today. It’s…
-
Continue reading →: Getting started with Oracle DB 23ai VirtualBox ApplianceOracle has just announced the release of Oracle Database 23ai, the next long-term support release of the industry-leading Oracle Database, on 2nd May 2024. You can find the announcement here. The new release is packed with tons of new features, strongly focusing on artificial intelligence (AI) and developer productivity. In…
-
Continue reading →: Journal Import using File-Based Data Import (FBDI)As part of the data migration process, when you are moving financial data from your legacy system to Oracle ERP Cloud, you might need to import journals in bulk. We often use File-Based Data Import (FBDI) for this purpose. In is blog I’ll discuss how the process of importing journals…
-
Continue reading →: Intro: Extending Oracle E-Business Suite R12 using Oracle APEX #JoelKallmanDayI have been thinking of writing a series of blogs about Integrating Oracle APEX with Oracle E-Business Suite, for quiet a while now. When I saw the following post from Tim Hall couple of weeks ago, I said to myself that there is no better way to pay tribute to…
-
Continue reading →: Create Custom Application in Oracle EBS R12.2Create Custom Application in Oracle EBS R12.2
-
Continue reading →: Installing Oracle Database 19c on Oracle Linux 8In one of my previous posts, I showed how to install Oracle Database 21c on Linux 7. In this post, I will show the step-by-step process of how to install and set up an Oracle Database 19c on Oracle Linux 8. For most of my installs, I use Linux 7.…
-
Continue reading →: Install Oracle Database 21c XE On Linux 7Oracle have released Oracle Database 21c Express Edition on Linux. Oracle Express Edition or XE is the free to use version of the database. You can download it from the following link: https://www.oracle.com/database/technologies/xe-downloads.html In one of my previous posts, I demonstrated how to install Oracle Database 21c on Linux 7.…
-
Continue reading →: Change Corporate Branding in Oracle EBS R12.2Very often, there is a requirement to change the corporate branding, from the standard Oracle logo to the logo of the company or customer. How do we do this? In this post, I’ll show you how. The corporate branding image is visible at two places. On the top-left corner of…
-
![Fun with Oracle Analytics SQL #1 : PIVOTS [ PART II ]](https://blog.rishoradev.com/wp-content/uploads/2021/09/pivot_33769_hd.jpg)
Continue reading →: Fun with Oracle Analytics SQL #1 : PIVOTS [ PART II ]In my previous post, I showed how to rotate rows into column using the PIVOT operation in Oracle. I pivoted a single measure and dimension. But wait! When we create a PIVOT Table in spreadsheet, we get additional aggregated columns, a. showing the total quantity of items ordered across all…
-
Continue reading →: Fun with Oracle Analytics SQL #1 : PIVOTS [ PART I ]
Creating a “Pivot Table” using a spreadsheet is pretty straight forward, and it enables you to transpose rows into columns. But, can we do the same operation using Oracle SQL? Yes, it can be done, indeed. The pivot_clause of the Select statement serves this purpose. It enables us to rotate…
