Programmer Group

1. Download and install ODT for VS2015_121025 to restart VS on Oralce's official website 2. Project reference Oracle.ManagedDataAccess.dll 3. Database connection string: user id = xxxx; password = xxxx; data source = 192.168.0. xxx: 1521/orcl (database name) 4. Use method: OracleConnection con = new OracleConnection(); con.ConnectionStri ...

postgresql has provided rollup/cube/grouping sets grouping functions since 9.5, which is more convenient to use. Especially when sql is used directly to produce reports, one sql can get all the details and summary values. https://www.postgresql.org/docs/9.5/static/sql-select.html https://www.postgresql.org/docs/9.5/static/queries-table-expres ...

Test environment: Server: oracle server in docker, service name is jaw, reference Docker Installation of oracle and mysql under unbuntu Client: instantclient client client, reference Create a streamlined version of oracle client and pro*c compiler environment under ubuntu Configure the service name XE in / opt/oracle/product/network/admin/tn ...

[Re-learning Java Foundation] [JavaIO Stream] [Part.6-2] Stream Decoder and Stream Encoder StreamDecoder Summary This class is under the sun.nio package In the previous Oracle official JDK, you can only download OpenJDK to see the source code. Or check it online at grepcode openJDK Online Source But since Java 9, O ...

In 12.1, all PDB s in one instance can only share the same UNDO table space. In 12.2, they all have their own undo table spaces. This new management mechanism is called the local undo model. At the same time, in previous versions, it has now become a shared undo mode. I. shared undo to local undo mode 1. Query the current mode SQL> select ...

Summary It is difficult to avoid the problem of SHP file storage when using Oracle Spatial. Although there are shp2sdo tools, they are not used to it, so this paper describes how to realize shp2sql conversion with geotools. Effect Implementation code package com.lzugis.geotools; import com.lzugis.CommonMethod; impo ...

Oracle database server DG can not complete data synchronization after restarting from the database. The specific error information is as follows: I. Misinformation alter log error reporting *********************************************************************** Fatal NI connect error 12547, connecting to: VERSION INFORMATION: TNS f ...

This example mainly aims at Oracle table space full problem processing method to do a step-by-step sharing. I. Warning Information After receiving zabbix alarm information, the usage rate of table space SYSAUX is more than 95%, and that of system table space sysaux is more than 95%. Processing steps 1. Log on to the specific database and do th ...

os: centos 7.4 database: 12.2.0.1 + dbf This deployment is in the form of oracle database 12.2.0.1 + dbf, and rac + asm will be recorded later. At any time, there are three modes: Maximum protection: maximize protection maximize performance Maximum availability alter database set standby to maximize protection; alter d ...

1. Download Compressed Files on mysql Official Website https://dev.mysql.com/downloads/mysql/5.7.html#downloads 2. Copy the downloaded files to the / opt directory of centos system III. Start installation 1. Decompress mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz [root@centosDemo opt]# tar -zxvf mysql-5.7.22-linux-glibc ...