Using 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, dedicated, and cloud@customer). You can modify the configuration of an
Read more
The 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 Paid Status column. SQL> CREATE TABLE invoices(invoice_num VARCHAR2(10), paid_status BOOLEAN);Table
Read moreOracle 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 * FROM department_2; DEPTNO DNAME LOC_________ __________________________ ___________ 10 Accounting-10(New
Read moreOracle 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 ENAME JOB MGR HIREDATE SAL COMM DEPTNO________ _________ ____________ _______
Read more
I 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. We have created a table EMP and we will load
Read more
In 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 on Oracle Database and then on Autonomous Database. You should
Read more
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 it together!!! Once you have logged into you Oracle Cloud
Read more
We 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 can spend some time to do these context switches. Usually
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, 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
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
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
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 