Programmer Think

Background description System a is a dual node RAC. System a is short of disk space, so apply to Party A and add 1T disk to system a; System B is a single instance. System B has the remaining 500G disk and 800G disk DATA disk space. The archive storage location is in the DARA disk. The archive space size is set to 800G. Apply to Party A. s ...

[Oracle] CentOS 7.4 installation and deployment Oracle19c Project requirements         In the production environment, according to the business development and project requirements of the enterprise, the business database will be selected according to the importance of the business, and the data model and database design ...

Article catalog 1 Overview2 example description 2.1 flashback query2.2 flashback version query2.3 flashback transaction query2.4 flashback table2.5 flashback deletion 3 expansion 1 Overview In order to recover Oracle database from misoperation quickly, Oracle has introduced flashback technology.This blog mainly shares the flashbac ...

Single line function Single line function: Operation data object Accept parameters and return a result Transform only one row One result per row Data types can be converted Can be nested The parameter can be a column or a value function_name [(arg1, arg2,...)] Single-Row Functions Character function LOWER('SQL Course')--sql course UPPER ...

Environmental Information red hat linux64  gi 11.2.0.4  oracle 11.2.0.4 Problem Phenomena After installing gi software and oralce database software, the database is built through the dbca user interface. It is found that the database can be built normally on node1, not on node2. The dbca library building process errors on node2. Figur ...

SQL parsing order Next, let's take a look at the past and present life of an SQL statement. First, let's look at the sample statement: SELECT DISTINCT < select_list > FROM < left_table > < join_type > JOIN < right_table > ON < join_condition > WHERE < wh ...

1. Problem description I do project services: start in the Intranet environment, all links related to the Internet need to go through transparent agent.Alibaba cloud sdk: encapsulate all operations related to http. We can't configure HTTP related settings. To solve the problem 1: how can intranet serv ...

Array and linked list are two kinds of data structures commonly used in the program, and they are also one of the interview questions often tested in the interview. However, for many people, they just vaguely remember the difference between them. Maybe they still don't remember it right. And every time they come for an interview, they have to r ...

In an Oracle database, Oracle to_ The date () function is a frequently used function. Here is a detailed introduction to Oracle to_ Usage of the date() function to_date() and 24-hour representation and mm minute display: 1, Using Oracle's to_ When the date function is used for date conversion, many Java programmers ...

This is a brief introduction to how to export and import table structure definitions using the datapump tool of the ORACLE database.Because business scenarios can be very simple, you won't encounter any problems, or business scenarios can be very complex, and you will encounter a lot of problems.Here's a brief description of what you need.A bat ...