Yesterday, when I went to the client’s side and asked the client’s sister to query a piece of sql for me, I found that the sql [subquery] can also be written like this: SQL subqueries can not only appear after from as a table structure, for example: select t1.company_id,t1.company_name,t1.department_id,t2.department_name from company t1, ( select * …
foreword This article will demonstrate the whole process of how to use the script to install the Oracle 19C stand-alone database with one click. Preparation before installation In the production environment, the Linux operating system and network are generally not configured by the DBA. In order to be more suitable for production use, this script …
Stand-alone One-click installation of Oracle 19C database Read More »
foreword This article will demonstrate the entire process of how to use a script to install the Oracle 12CR2 stand-alone database with one click. Preparation before installation In the production environment, the Linux operating system and network are generally not configured by the DBA. In order to be more suitable for production use, this script …
Single machine One-click installation of Oracle 12CR2 database Read More »
Create test data: CREATE TABLE TEST_DEPT(ID varchar2(10) NOT NULL,NAME varchar2(200),PID varchar2(10)); INSERT INTO TEST_DEPT( ID , NAME , PID) VALUES ( '1000' , 'Head Office' , NULL ); INSERT INTO TEST_DEPT( ID , NAME , PID) VALUES ( '1001' , 'Beijing Branch' , '1000' ) ; INSERT INTO TEST_DEPT( ID , NAME , PID) VALUES …
Oracle recursive query -start with connect by prior usage Read More »
alter table emp add e_sex varchar2(50);
2. http://www.xuebuyuan.com/2023482.html Internal storage method of SCN: Inside Oracle, SCN is stored in two parts, called scn wrap and scn base. In fact, the SCN length is 48 bits, that is, it is actually a 48-bit integer. It’s just that it may be artificially divided into low 32 bits (scn base) and high 16 bits (scn …
(Notes)) Oracle SCN abnormal growth problem and ORA-19706 Read More »
foreword This article will demonstrate the whole process of how to install Oracle 12CR2 RAC 2 node database with one click using script. Preparation before installation In the production environment, the Linux operating system and network are generally not configured by the DBA. In order to be more suitable for production use, this script is …
RAC One-click installation of Oracle 12CR2 database Read More »
The first half of the data source is the employee information table under Oracle’s own HR user: EMPLOYEES. If the creation example is not checked when creating the library, you can download the sql file here to create the related table and data source. (Baidu network disk link: [https://pan.baidu.com/s/1axlyRjfEGi0pOi8xmRewrA] Password: t3yy) The data source …
wrong description Error when importing dmp file using [Navicat data pump] [ERR] ORA-39001: invalid argument value [ERR] ORA-39000: bad dump file specification [ERR] ORA-39143: dump file "/xxx.DMP" may be an original export dump file Cause Analysis It is literally understood that the export method of this file does not support the import and export methods …