Introduction I must admit that when I first saw a demo of SELECT AI, I thought it was somewhat of a novelty. However, I changed my mind after completing a proof of concept for a real-world business use case. This post will introduce SELECT AI, descri...
Do you sometimes get Oracle APEX Interactive Report Headers disconnecting from the Column Values? like this… Why does this happen? Interactive Reports typically size the column widths perfectly for the data returned by the region source. However a m...
In Oracle Cloud Infrastructure (OCI) > Autonomous Database (ADB), the "Choose Network Access" setting lets you control how users can connect to your database. Important: If you make a change, it changes the connections in the Wallet. So you must re-d...
This article guides you with the commands for downloading multiple files together from OCI Object Storage to Oracle Autonomous Database Directory Object such as DATA_PUMP_DIR. Remember that we don't have OS access for our Autonomous Serverless Databa...
This article guides you with the commands for deleting multiple files together from your Oracle Autonomous Database Directory Object such as DATA_PUMP_DIR. Remember that we don't have OS access for our Autonomous Serverless Database. So, to access or...
This article quickly guides you on how to create and drop the credential in Oracle Autonomous Database. To create a Credential, you can use the following command: BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'MY_CLOUD_CREDENTIAL', ...
The following queries can be used to list all the objects from your OCI Bucket Storage. -- First Create a Credential using the following code. -- In the below code, the 'username' parameter expects your "Tenancy" Username which you can find in your O...
This article will guide you with the steps to upgrade the TimeZone File Version in Oracle Autonomous Database. In Oracle Autonomous Database, the timezone file version upgrade is very simple. i.e. The manual way of upgrading the timezone file version...
Understanding the role of Refreshable Clones Autonomous database Refreshable clones are a very useful feature to maintain a clone of an Oracle Autonomous Database in Oracle Cloud Infrastructure. If you want to know more about the Autonomous Database,...
