DBMS_CLOUD: installed on 19c and 21c local databases

This article describes how to install DBMS in local 19c and 21c databases_ Cloud package. The package is installed in the database on the Oracle cloud. Related articles: DBMS_CLOUD PackageOracle Cloud Infrastructure (OCI) : Create an Object Storage BucketOracle Cloud : Autonomous Database (ADW or ATP) - Load Data from an Object Store (DBMS ...

Posted on Sun, 05 Dec 2021 13:23:53 -0500 by slick101

Table design of Oracle notes

1, Design table Premise: the design table should first follow the three paradigms as needed Review 3NF: 1NF – > column is the smallest atom that cannot be subdivided (avoid duplication);2NF – > primary key dependency (unique);3NF – > eliminate the transfer dependency (establish the primary foreign key Associati ...

Posted on Thu, 02 Dec 2021 19:58:22 -0500 by anoesis

CentOS 8.5 installing Oracle 19c

This article installs Oracle 19c for Centos8 1, Update yum source (under root user) Before installing, it is recommended to update the yum source: yum update -y Or dnf update 2, Installation related dependencies (under root user) yum install -y binutils* compat-libstdc* elfutils-libelf* gcc* glibc* ksh* libaio* libgcc* libstdc* make* syssta ...

Posted on Sun, 28 Nov 2021 04:23:15 -0500 by JParishy

Summary of common functions for Oracle personal learning

This document is to record common functions Oracle functions sysdate date function sysdate: used by Oracle to obtain the date and time select sysdate from dual; #Get current date Specific common methods: https://i.csdn.net/#/user -center/collection-list?type=1&spm=1001.2101.3001.4506 rowid and rownum rowid: used to locate a piece ...

Posted on Fri, 26 Nov 2021 07:27:52 -0500 by brianb

Oracle database 21c new feature: password step-by-step switching strategy

Hello, everyone. I'm Mr. Tony, who only talks about technology and doesn't cut his hair. Changing the database user password on a regular basis may result in the interruption of the application. Usually, we need to plan downtime, modify the database user password, then modify the connection information in the application server, and finally re ...

Posted on Wed, 24 Nov 2021 19:12:55 -0500 by bmcewan

Detailed explanation of ADG three mode switching

Introduction to AGD Data Guard can open the database in a read-only mode, but at this time, the process of data synchronization using logs by Media Recovery stops. If the physical standby database is in the process of recovery, the database cannot open queries, that is, the log application and read-only opening are mutually exclusive (before 1 ...

Posted on Tue, 23 Nov 2021 19:12:22 -0500 by iMiles

❤️ Liver explosion for 3 days! 20000 word graphic SQL zero basic entry, not afraid you can't learn, just afraid you don't collect! ❤️

📚 preface SQL language has a history of more than 40 years. Since it was applied, it has been almost everywhere. Every payment record we consume, every user information we collect and every message we send will be stored in the database or its related products, and the language to manipulate the database is SQL! SQL is almost a necessar ...

Posted on Sat, 20 Nov 2021 06:42:25 -0500 by phpBever

Solutions to errors in ORACLE SELECT INTO syntax ORA-01422 and ORA-01403

background In Oracle functions or stored procedures, the following syntax is usually used to assign values to variables: -- Single variable assignment SELECT [Field 1] INTO [Variable 1] FROM [data sheet] WHERE [query criteria]; -- Multivariable assignment SELECT [Field 1], [Field 2] INTO [Variable 1], [Variable 2] FROM [data sheet] WHERE [qu ...

Posted on Fri, 19 Nov 2021 01:45:29 -0500 by lead2gold

Oracle developer intermediate Lesson 8 (Merge) experiment

summary This experiment refers to the in DevGym Experimental guide. Create environment create table bricks_for_sale ( colour varchar2(10), shape varchar2(10), price number(10, 2), primary key ( colour, shape ) ); create table purchased_bricks ( colour varchar2(10), shape varchar2(10), price number(10, 2), pr ...

Posted on Tue, 16 Nov 2021 11:24:25 -0500 by jstngk

ORACLE stored procedure batch table creation - Notes

catalogue 1, Introduction to stored procedures and basic syntax 2, Table creation statement analysis 3, Write stored procedures and test them 4, Record of problems encountered this time 5, Appendix 1, Introduction to stored procedures and basic syntax (1) Definition     Stored procedure is a set of SQL statements to complete ...

Posted on Fri, 12 Nov 2021 05:18:25 -0500 by aromakat