As part of learning the Oracle SQL tutorial, Here is good detail on the group by Oracle Group by Oracle We use Group by in the select statement to group rows into summary rows using column or expression. We often used aggregate or group functions on the group to obtain the summary rows Syntax SELECT col1, […]
Group by Oracle: Syntax, Uses, Restrictions Read More »
Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to
How to check block corruption in Oracle database and Fix it Read More »
Oracle Provides Automatic Managed Backup Service on DBCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy How to configure Automatic Managed Backup Step 1Open the navigation menu. Under Oracle Database, click Base Database service.Step 2Choose your Compartment.A list of
How to configure Automatic Managed Backup on DBCS Read More »
Oracle Database Cloud Backup Module How to download the Oracle Database Cloud Backup Module Download the Oracle Database Cloud Backup Module from Oracle Technology Network (OTN):https://www.oracle.com/database/technologies/oracle-cloud-backup-downloads.html Accept the license agreement, click All Supported Platforms, and provide your OTN username and password when prompted. Then download the ZIP file that contains the installer (opc_installer.zip) to your
How to install Oracle Database Cloud Backup Module Read More »
What is Essbase Oracle Essbase is a multidimensional database management system (MDBMS) providing a multidimensional business analytics platform. It is commonly used for budgeting, forecasting, and planning in enterprise environments. What is Essbase 11g Essbase 11g is the old version of Oracle Essbase where the latest patchset is 11.1.2.4This is the latest On-Prem Essbase version
Difference between Essbase 11g and Essbase 21c Read More »
This is part of the Oracle SQL tutorial and has good examples and explanations of the Oracle LISTAGG Function. Oracle LISTAGG function Oracle LISTAGG function is an analytical function that allows us to concatenate the strings for measure_column for each GROUP based on the order_by_clause. This is present in Oracle from 11gR2 The syntax for the LISTAGG
How to use Oracle LISTAGG Function Read More »
