In my previous blog, we learnt about the pre-requisite steps for provisioning an Oracle Generative AI RAG Agent in Oracle Cloud Infrastructure (OCI). In the subsequent blog, Creating a Knowledge Base for creating Oracle Generative AI RAG Agent, we learnt how to create a storage bucket and then created a knowledge base which derives the data from the text files
Read moreThis is the second blog of the series Create an Oracle Generative AI RAG Agent. For simplicity, I have broken the post down into 3 parts: In my previous blog, we discussed the steps that you need to perform if your tenancy is not subscribed to any of the regions where OCI Generative AI Services are available. In this blog,
Read moreWhat are Generative AI RAG Agents? Generative AI Agent is a fully managed service that combines the power of Large Language Models (LLMs) with AI technologies, to create intelligent virtual agents, that can provide accurate, personalized and contextually-relevant responses to end-user queries, and creates a highly engaging customer experiences. The method of augmenting the user requests with private organizational data
Read moreThis post would be particularly useful for those who are just starting their learning journey with Oracle Integration Cloud. We will create a basic and fundamental integration to call and invoke a simple REST web service in an orchestrated integration. We will learn how to: So let us begin. Create Project It is always recommended that you create an integration
Read moreIn one of the previous posts we learnt how to create a Oracle Integration 3 instance. In the next one, we saw how to enable the File Server. In this particular post, we will explore some of the basic configuration for the File Server from the Oracle Integration instance. More specifically, we will look into the following topics: So lets
Read moreYou can create an user or user groups if you are granted identity domain administrator or user administrator role in the Administrators page Identity Cloud Services console(IDCS). In this blog we’ll learn how to create users and user groups from the IDCS page within the OCI console. Create User To create an user, login to OCI console using an user
Read moreIf you are looking to design a file-based integration, then you need to use a File Server. Oracle Integration comes bundled with an SFTP server which you can use to store, share, and receive files, including files for SaaS integrations and third-party transfers. Oracle provides you with 500 GB of free storage. When you provision an Oracle Integration Cloud instance,
Read moreOracle Integration Cloud instances help you to design integration between the cloud applications and on-premise applications. It is a fully managed, pre-configured environment loaded with hundreds of pre-built adapters to connect with Oracle and other third-party applications. You can automate business processes, develop visual applications, use an SFTP-compliant file server to store and retrieve files, and exchange business documents with
Read more
In this blog we will look at how we can bulk upload Value Sets into Oracle Fusion. We will learn the process to import both Independent and Dependent Value Sets. Similar to Bulk Upload Lookup Types and Lookup Codes, we will be using File Based Loader. The process consists of the following steps. Prepare Files for Upload First step is
Read more
In this blog we will look at how we can bulk upload Lookup Types and corresponding Lookup Codes into Oracle Fusion. We can use File Based Loader for this purpose. The process is fairly simple and consists of the following steps. So let’s understand each step in more detail. Prepare the Lookup Files for Upload First step is to create
Read moreIn 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. Parameters Description user OCID of the user for whom the
Read more
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
Oracle 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 or a Mixed Workload Database. In this session, we will
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
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
RishOraDev's Oracle Blogs 