SQL/PLSQL Playbook: Reusable Code for DevelopersAs a database developer, you want to leverage code repositories for collaboration, version control, documentation, CI/CD pipelines, and…Sep 24Sep 24
Data Pipelines help you move your data into Autonomous DatabaseIt’s now an accepted norm to you want to have a single source of truth for all your data and Oracle Autonomous Databases is the perfect…Jun 10Jun 10
Search for text in your files using your databaseAutonomous Database (ADB) is a powerful converged data platform that is multi-modal, multi-tenant and multi-workload. It’s an ideal…May 3May 3
Cloning Oracle Pluggable Databases on DBCSCloning pluggable database works to create a clone of a PDB or a non-CDB. The idea is to create a clone of current database to in its own…May 30, 2022May 30, 2022
Connecting to Autonomous Database without a WalletAutonomous Database now allows you connect to the database without using the wallet file (mandatory for secure connection). Autonomous…Mar 15, 2022Mar 15, 2022
How to Upload Large Files to OCI OSSThere are many times when you have to upload large files to Oracle Cloud Infrastructure (OCI) Object Storage (OS). Especially when it comes…Mar 7, 2022Mar 7, 2022
MV2BUCKET: Easy way to move Oracle DB Cloud Service backupsOracle database automated backups are stored in Oracle Managed Object Store Buckets ( which essentially reside in the same region as the…Jan 23, 2022Jan 23, 2022
Does it matter to have Group By in Subquery in 11gYesterday I was working with a customer and they presented a query to me, it looked like an odd query. The query in itself was a simple…Dec 8, 2021Dec 8, 2021
Rename / Remove DBCS Domain NameStep 1 : Log into DB Server and sqlplus into the databaseNov 23, 2021Nov 23, 2021