Oracle 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 this post, let’s have a look at the much awaited
Read moreIn 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 any SQL data type ( BLOB,CLOB, JSON, VARCHAR2, or VECTOR
Read more
Oracle 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 try to understand this new feature. What is JSON Relational
Read more
In 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 a Command line window, and execute the following command. docker
Read more
If 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 open source, it’s free, and it is a super-powerful editor.
Read more
Oracle 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 this post, I will show how easy it is to
Read more
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 into Oracle Fusion using FBDI. On a high-level, the following
Read more
I 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 the great man, #JoelKallman, by writing something about the application
Read more
In 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. This is the first time I used Oracle Linux 8.
Read more
Oracle 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. In this post, I will show a step-by-step process of
Read more
Very 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 the Home Page after you login into an E-Business Suite
Read more
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 organizations in each quarter, and b. showing the total quantity
Read more
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 rows into columns, aggregate the data in the process of
Read more
Oracle has released the On-Premise version of Oracle Database 21c ( only on Linux for now ), last week. You can download it from either MOS or Oracle edelivery: https://www.oracle.com/database/technologies/oracle-database-software-downloads.html https://edelivery.oracle.com This release is an “Innovation Release”, which means it comes with only 2 years of Premier Support and no extended support, as opposed to a “Long Term Release” which
Read more
RishOraDev's Oracle Blogs 