The logical backup tool of Oracle Database - expdp data pump

Oracle database can export and import data through the data pump expdp tool. Before introducing the use of the tool, let's first say that when the newly created table after Oracle11g does not insert data, it will not allocate segment, that is to say, it will not allocate space, and when using expdp to e ...

Posted on Tue, 25 Feb 2020 20:57:56 -0800 by zxiny_chin

How do I use GROUP BY to connect to strings in SQL Server?

How to get: id Name Value 1 A 4 1 B 8 2 C 9 to id Column 1 A:4, B:8 2 C:9 #1 building One example is In Oracle, you can use the list AGG aggregation function. Original record name type ------------ name1 type1 name2 type2 name ...

Posted on Tue, 25 Feb 2020 06:19:43 -0800 by gabo

Column to row, multi row to single line function listagg() in Oracle

Occasionally, it is necessary to convert multiple rows of data into one row for display in work. Since it is not often used, this place is convenient for next view listagg(expr1,expr2) within group(order by expr3) expr1: the columns to be converted can be single column or multi column expr2: separator ...

Posted on Mon, 24 Feb 2020 22:09:26 -0800 by jarvis

Selected cases of seven principles of internal mental skill and software architecture design of Architects

1, Seven principles of software architecture design 1.1 open closed principle (OCP) The principle of opening and closing is that a software entity such as class, module and function should be open to extension and closed to modification. The so-called opening and closing is also a principle for expansion and modification. The emphasis is to ex ...

Posted on Tue, 18 Feb 2020 23:02:43 -0800 by techjosh

Record the process of automatic Down machine a few minutes after an Oracle startup

Recently, in the process of work, we encountered an Oracle failure. The phenomenon is that the Oracle database will automatically shut down within ten seconds after the startup. After a day and a half of processing, Oracle will be temporarily recovered. It is hereby recorded for follow-up tracking. 1. Observe the problem Find the Oracle excepti ...

Posted on Wed, 12 Feb 2020 21:55:19 -0800 by matecocido

Basic concepts and basic use cases of javascript

1. Characteristics of javascript and differences with java javascript is based on object and event driven language, application and client. Characteristics of js Interactivity: the dynamic interaction of information Security: unable to access local disk file Cross platform: in java, cross platform, virtual machine; javascript can ...

Posted on Fri, 31 Jan 2020 14:44:52 -0800 by robh76

Oracle EBS file upload and download (II) - customized OAF development

Business background In the project of XX company, it is required to upload the pictures, technical drawings, operation instructions and other files of all materials. Because the upload function files of Oracle EBS standard attachments are saved in the data table FND_LOBS, when the number of uploaded files is large, daily produ ...

Posted on Fri, 31 Jan 2020 11:28:26 -0800 by jc94062

Detailed Oracle stored procedure tutorial

Detailed Oracle stored procedure tutorial Don't get lost. Welcome to visit again! Catalog Detailed Oracle stored procedure tutorial 1, Create stored procedure syntax 2, Output case 3, Call stored procedure 3.1 declare keyword 3.2 do not declare the declare keyword 3.3call 4, Stored procedu ...

Posted on Sun, 19 Jan 2020 05:40:04 -0800 by Cynthia

Pure jdbc operation oracle database migration to mysql database (test 2000 tables, single table data more than one million, no OOM)

Article directory Preface Thinking before coding Realization demo structure Introducing dependency Implementation class optimization Source code Preface Data migration is always troublesome. If there is a need for oracle to mysql, data migration is a big problem Before data migration, baidu ha ...

Posted on Wed, 15 Jan 2020 04:14:48 -0800 by rudibr

Join usage in MySQL

Article directory Join usage in SQL #1 environment #2 create table and insert data #3 start #3.1 inner join #3.2 left join #3.3 right join #3.4 full join Join usage in SQL #1 environment MySQL5.7 Mac #2 create table and insert data Create two new tables tableA and tableB mysql> creat ...

Posted on Sun, 12 Jan 2020 00:04:57 -0800 by AbraCadaver