Programmer Think

Using Java Sources in Oracle Database Because of some special requirements, the password of the user table in the database needs to be changed to "user name + specified character". Therefore, the encryption algorithm in the program is changed to java sources, function call, convenient to update data. Environment: Ora ...

If you need to check the sql usage of a system, you can query the $sql, $sssession, $sqlarea of Oracle for statistical troubleshooting Check the basic information of $sql and $session before troubleshooting select * from v$sql a, v$session b where b.SQL_ADDRESS = a.ADDRESS and b.SQL_HASH_VALUE = a.HASH_VALUE and b.SQL ...

The first is typeorm's Official Address， Someone in the country has doubled Chinese version , timeliness is not guaranteed / Install the following packages via npm: typeorm //typeorm connection database @types/node//type system typescript //ts base oracledb //oracle base ts-node //nodejs compiles tools that run ts; / Root Path Config ...

Oracle Active Data Guard and Automatic Block Repair Starting in Oracle Database 11g Release 2 (11.2), the primary database automatically attempts to repair the corrupted block in real time by fetching a good version of the same block from a physical standby database. This capability is referred to as automatic block repair, and it allows corrup ...

1. Install yum repo There is no mysql in the yum source of centos (you can try to use the installation command directly: Yum install mysql server). You need to download the yum repo configuration file on mysql's official website, and then install: #download wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm #repo inst ...

Mysql Management Operations Database management operations View database structure Create and delete libraries and tables Manage records for tables Basic Operational Commands View database list information SHOW DATABASES [root@localhost ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your ...

The ABCR function of Oracle 11gr2 has been introduced. When a damaged database is retrieved, it will be automatically repaired. Now test whether the database will be automatically repaired when the database block is damaged and the instance is forced to close.First, test the general user table, baiyang.t'ou objs(I) current active and standby en ...

1) install Mysql database [root@localhost ~]# rpm -q mysql mysql-server Package mysql is not installed Package MySQL server is not installed [root@localhost ~]# yum -y install ncurses-devel [root@localhost ~]# rpm -q ncurses-devel ncurses-devel-5.9-14.20130511.el7_4.x86_64 Install configuration tool cmake [root@localhost ~]# tar xf cmak ...

Catalog MySQL highly available Galera Cluster Galera Cluster Galera Cluster features Disadvantages of Galera Cluster Galera Cluster working process Official document of Galera Cluster Galera Cluster consists of two components WSREP replication implementation PXC princ ...

Previously, colleagues encountered this error while writing views. I'll sort out the simplified sentences as follows: 1: select 2: '2016' as nf, 3: qxdm, 4: round(sum(tbdlmj)/10000,2) as csydmj--Unit conversion, 2 decimal places 5: from dltb_2016@dblink_td_tdxz m where dlmc='City' 6: group by m.qxdm order by m.qxdm 7:  ...