Techgoeasy

Sequence in Oracle: Use, Modify, Reset, Drop

What is Sequence in Oracle? Creating a sequence is done using the CREATE SEQUENCE [START WITH] [INCREMENT BY] [NO/MINVALUE] [NO/MAXVALUE] [NO/CYCLE] [NO/CACHE]; Description of each value Examples create sequence test_tech start with 1increment by 1maxvalue 10000cyclecache 20;Orcreate sequence test_tech1start with 1increment by 1maxvalue 4500000cyclenocache; How to use sequences To use sequence simply use the …

Sequence in Oracle: Use, Modify, Reset, Drop Read More »

Oracle cloud storage : Block Volume

Oracle, Oracle cloud

We will be checking about oci block storage in this post. What is block storage and what are the features of block storage What is Block Volume OCI Block storage is the NVMe SSD based storage that you can attach to any compute instance that was launched It can hold applications, installations, or even software …

Oracle cloud storage : Block Volume Read More »

Oracle Cloud :Infrastructure-as-a-Service Concepts

Oracle, Oracle cloud

Oracle Cloud: Infrastructure-as-a-Service Overview Oracle’s Infrastructure-as-a-Service (IaaS) provides a complete infrastructure for enterprise workloads, including compute services, storage services, and network services. It enables organizations to run any type of workload in the cloud and in particular run Oracle workloads in the most optimized way. This gives an excellent option to clients to not purchase …

Oracle Cloud :Infrastructure-as-a-Service Concepts Read More »

How to use Coalesce Function in Oracle

Oracle, Oracle Sql

What is Coalesce Function Coalesce Function is a useful function in oracle and it is very useful when we want to return the first non-null values in the list. This SQL tutorial provides explanations, examples for Coalesce Function in Oracle and the Difference between Coalesce & NVL expr1: This is returned if it is not …

How to use Coalesce Function in Oracle Read More »

Oracle Database Cloud Service Overview

Oracle, Oracle cloud

Introduction to Oracle Database Cloud Service (OCI Database Services) Oracle database cloud service is a service of Cloud Category PaaS. It enables businesses to reap all the benefits of Platform as a Service, including subscription-based, self-service access to reliable, scalable, and elastic cloud environments. Earlier you needed to purchase hardware, install OS, and then install …

Oracle Database Cloud Service Overview Read More »

How to clone R12.1 Environment

Oracle, Oracle Ebuisness Suite

We often need to clone the R12.1 environment to create another test environment. Here are the steps on How to clone R12.1 Environment Step 1: Prepare the Source System database tier for cloning 1. Log on to the Source System as the Oracle user.2. Source the Database tier environment file. cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>perl adpreclone.pl dbTier This …

How to clone R12.1 Environment Read More »