oracle

The magic of sql subquery use it as a subtable after from, use it as a subcondition after where, and use it as a subfield after select

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 * …

The magic of sql subquery use it as a subtable after from, use it as a subcondition after where, and use it as a subfield after select Read More »

Stand-alone One-click installation of Oracle 19C database

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 »

Single machine One-click installation of Oracle 12CR2 database

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 »

RAC One-click installation of Oracle 12CR2 database

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 »

Oracle Analytical Function Summary (Super Full)

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 …

Oracle Analytical Function Summary (Super Full) Read More »

Navicat connects Oracle to import dmp file and reports error …XXX.dmp may be an original export dump file Solution

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 …

Navicat connects Oracle to import dmp file and reports error …XXX.dmp may be an original export dump file Solution Read More »