Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 25, 2024Recover Lost or Overwritten Code on Oracle Autonomous DatabaseIf you are reading this, I presume you’ve just lost some code. Take a reading of you smartwatch heart rate and post it in the comments later. This blog is aimed at Autonomous Database; for non-Autonomous Database, click here. If you don’t have time f...Discuss·3 likes·95 readsOracle
Jon Dixonblog.cloudnueva.com·Nov 21, 2024SELECT AI is Not a Toy!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...Plamen Mushkov and 3 others are discussing this4 people are discussing thisDiscuss·5 likes·920 readsSELECTAI
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 20, 2024Solved: Misalignment Between Oracle APEX Interactive Report Headers and Column ValuesDo 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...Discuss·3 likes·235 readsorclapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 7, 2024Update network access for Autonomous DBIn 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...Discuss·2 likes·115 readsorclapex
Baskarbaskarblogspot.hashnode.dev·Jul 7, 2024How to download multiple files together from OCI Object Storage to Oracle Autonomous Database Directory such as DATA_PUMP_DIRThis 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...DiscussGET_OBJECT
Baskarbaskarblogspot.hashnode.dev·Jul 7, 2024How to delete multiple files together from Oracle Autonomous Database Directory Object such as DATA_PUMP_DIRThis 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...DiscussDATA_PUMP_DIR
Baskarbaskarblogspot.hashnode.dev·Jul 7, 2024How to create a Credential in Oracle Autonomous DatabaseThis 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', ...DiscussOCI Credential
Baskarbaskarblogspot.hashnode.dev·Jun 27, 2024How to list all the Objects from OCI Bucket Storage via SQL Query in Autonomous DatabaseThe 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...DiscussOCI Bucket
Baskarbaskarblogspot.hashnode.dev·Jun 16, 2024How to Upgrade the TimeZone File Version in Oracle Autonomous Database?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...Discusstimezone file version
Walid Hajeri (WalidHaj)walidhajeri.hashnode.dev·Aug 28, 2023Auto-refreshing Oracle Autonomous Database Refreshable ClonesUnderstanding 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,...Discuss·128 readsOCI
