Oracle's DBV Tool

DBV(DBVERIFY) is a command-line tool provided by Oracle, which can check the consistency of data files both physically and logically. However, this tool does not check the matching relationship between index records and data records, which must be checked using the analysis validate structure command.This tool has the following characteristics: ...

Posted on Fri, 28 Jun 2019 15:57:45 -0400 by jansky

10-MySQL Data Query Application (Actual Warfare) (I)

There are two data tables emp and dept as follows: Employee Information Sheet: emp Departmental table: dept Table field description: Data to be inserted in two tables emp Table: INSERT INTO emp VALUES(7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20); INSERT INTO emp VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300, ...

Posted on Fri, 28 Jun 2019 15:54:58 -0400 by benyhanna

Enterprise RAC+DG Architecture Deployment

 Summary The full name of RAC is Real Application Clusters, translated as "Real-time Application Clusters" in Chinese, is a solution provided by ORACLE Oracle to build a high-availability database system on low-cost servers. It is free to deploy and can achieve multi-node load balancing and failover functions without purchas ...

Posted on Thu, 27 Jun 2019 20:18:07 -0400 by tinyang

The usage method and precautions of c3p0

Today, learning about database connection pool, we found that C3P0 needs to import the following two jar packages. Otherwise, it will make a mistake. A download link to the jar package is attached here. c3p0 download link By the way, learn how to use c3p0 connection pool. First of all, we need to know why we need to use connection pool: be ...

Posted on Thu, 27 Jun 2019 16:42:40 -0400 by not_skeletor

A brief introduction to Annotation in Java

1. Examples Let's start with an example: @Override public String toString() { return "xxxxx"; } The purpose of @Override is to tell the compiler that this method rewrites the method of the parent class. If the compiler finds that there is no such method in the parent class, it will make an error. Find the implementation of @Override pack ...

Posted on Thu, 27 Jun 2019 13:53:13 -0400 by davestewart

ASP+PHP Standard sql Injection Statement (Full Version)

1. Determine if there is an injection point ' ; and 1=1 and 1=2 2. The name of a table in general is admin admin user user pass password, etc.. and 0<>(select count(*) from *) and 0<>(select count(*) from admin) ---Judging whether there is admin This table 3. Guess the number of accounts If you encounter 0<Return to ...

Posted on Thu, 27 Jun 2019 13:08:39 -0400 by ojeffery

Pre-optimization analysis of sql

General steps for optimizing sql statements Know how often various commands are executed by the show status command mysql> show status like "%com%"; +-----------------------------+-------+ | Variable_name | Value | +-----------------------------+-------+ | Com_admin_commands | 0 | | Com_assign_to_keycache ...

Posted on Wed, 26 Jun 2019 16:45:13 -0400 by Jeremy_North

python+requests+unittest API interface test

Black Bear looked up the data related to the lower interface test on the internet, mostly in the form of data-driven, and maintained the use cases in text or tables without explaining how to generate the desired use cases. Questions: When testing interfaces, such as parameters a, b, c, I want to test a parameter first, there are (no transmissio ...

Posted on Sun, 23 Jun 2019 19:03:28 -0400 by patricklcam

A simple example of FLask-Login user login

To configure For login systems, we will use extensions, Flask-Login. The configuration is as follows (file app/init.py): from flask_login import LoginManager lm = LoginManager() lm.init_app(app) Reconstructing User Model Flask-Login extensions require specific methods to be implemented in our User class. But how classes implement these m ...

Posted on Sun, 23 Jun 2019 16:01:44 -0400 by leony

MyBatis -- Associated Query

MyBatis - Associated Query When the query content involves multiple tables with association, it is necessary to use association query. According to the relationship between tables and tables, Association queries can be divided into four types: One-to-one Association query One-to-many Association queries Many-to-one Association query Multi-t ...

Posted on Sun, 23 Jun 2019 15:09:43 -0400 by pmcconaghy