The query result of a view will be different than before if whose related table has subsequently inserted some new data

A few days ago I once published a SQL script about how to check and monitor the used size of several big tables in your oracle database on my Github repo. Here I have to illustrate that I use a VIEW to simplify/mask the complex query result of retrieving big tables using a SQL statement… Continue reading The query result of a view will be different than before if whose related table has subsequently inserted some new data

Autonomous Database Quick Start Tutorial – 3

In this tutorial I will show you how to visualize my data in my Oracle Autonomous DataWarehouse (the ADW database instance of Oracle Autonomous Database). Before you read this post you need firstly read my another two number of blog posts have been published a couple of days ago. They are in sequence as follows:… Continue reading Autonomous Database Quick Start Tutorial – 3

Autonomous Database Quick Start Tutorial – 2

In the previous tutorial I have finished provisioning an Oracle Autonomous Data Warehouse and connecting to it with SQL Worksheet. Therefore, in this tutorial I will guide you how to loading data into my autonomous database (ADW) instance. I will upload some files to Object Storage of the Oracle Cloud Infrastructure (OCI) and create sample… Continue reading Autonomous Database Quick Start Tutorial – 2

Autonomous Database Quick Start Tutorial – 1

With Oracle Autonomous Database we make it quick and easy for you to create a secure, fully managed database service in the Oracle Cloud which allows you to start loading and analyzing your data immediately. What is an Autonomous Database? Oracle Autonomous Data Warehouse (ADW) and Oracle Autonomous Transaction Processing (ATP) are built around the… Continue reading Autonomous Database Quick Start Tutorial – 1

Three Approach finding out the different entries between two LOG files

I guess some guys and friends who have followed my social media on both Twitter and LinkedIn may have noticed that a couple of days ago I once announced A demo with secure copying RMAN EXP[DP] backup files to another server has been added into my Github repository. Especially full_and_incr_scp_oracle_rman_expdp_or_exp_3.sh is one of my most… Continue reading Three Approach finding out the different entries between two LOG files

Request a Workspace to start my APEX journey

I knew that there has an alternatively free APEX workspace to be requested on https://apex.oracle.com/en/learn/getting-started/. Take a looking at the following screenshot. As you can seem from the prior image I click the button “Request a Free Workspace” with green color to start requesting a free workspace of Oracle APEX on another new tab page… Continue reading Request a Workspace to start my APEX journey

Getting my account of Oracle Cloud Free Tier in 2021

I have found the signup page of Oracle Cloud Free Tier has significantly changed in 2021 because I remembered that I was always stuck to that step of my credit card verification on May, 2020. At that moment I described my issue on Twitter, pretty luckily Jeff Smith retweeted my message to his boss Jenny… Continue reading Getting my account of Oracle Cloud Free Tier in 2021