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