Category Database
Amazon Web Services has been gaining popularity in the last few years since cloud computing has been in the spotlight.…
If you want to do migration of databases, the first and foremost thing is you must be able to connect…
1. Install Brew on your Mac http://osxdaily.com/2018/03/07/how-install-homebrew-mac-os/ 2. Install AWSCLI using Homebrew on Mac Make sure you have Python3 installed…
DynamoDB is one of the hidden gems of the NoSQL world. It is true serverless database. It is amazing that…
Oracle 19c is now available to use on Oracle Live SQL
One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
In my previous article we had fun with Shell Scripts by automating birthday alerts via email. Using the same logic…
Shell scripting is one of the most entertaining ways to learn programming. Shell scripting is infact a programming language in…
In my previous article I showed you how to use Letsencrypt to secure a production Apex instance. This is specially…
Download the client credentials from your Oracle Cloud account for your Autonomous Data Warehouse Instance. Make sure you note down…
Oracle has been an incumbent to the cloud space having lost a lot of ground to Amazon and Microsoft.But that…
— Replace duplicate values only in consecutive records with NULL [duplicate]– SELECT CASE WHEN lag(tran_id) over(order by NULL) = tran_id…
Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…
While creating a on-premise 18c (18.3) database with DBCA in the silent mode I got the below error dbca -createDatabase…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
On my test server I have got 2 ORACLE_HOMES 12cR1 (12.1.0.2) and 12cR2 (12.2.0.1) My listener.ora file on my server…
Create a new interactive report based on SQL Query. Make sure the column where image is store is populated in…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…