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…

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:…

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…

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…

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…

ORA-10560: block type ‘KTU UNDO BLOCK’

In the middle of last month an oracle Data Guard standby database of our production system there had shown the very weird message in its ALERT log file.

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…

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…

SQL Quiz for Intersect

I noticed that there is a sql quiz of oracle database on the place where I seem like to not remember it a few days ago. But the stuff of this SQL Quiz should look like as below. When ended up reading the prior SQL topic and each choice I know the topic has certainly…

Two skills for Changing Password of A User

Have you known how many methods for changing password of a user in the oracle database? Might the common method is using the “ALTER USER username IDENTIFIED BY password” in the SYS schema or your own schema to change it. Recently I know another approach when learning the course Oracle Database 19c: SQL Workshop in…