Programmer Help

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

📚 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 ...

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 ...

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 ...

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 ...