NAV: SLTechnology News&Howtos > Database >

• 

  Summary of oracle Analysis function-- for reference only

  / * Directory: 1. Grammar 2. Common functions and usage 2.1 sort function 2.2 wm_concat () can merge different lines with the same field! Be cautious in production environment 2.3.windowing usage 2.4percentage function ratio_to_r

  2022-06-01 12:29:00 Views: 293
• 

  Oracle sequence sequence

  Sequence meaning Oracle database provides sequence objects, self-growing serial numbers provided by the system, usually used for self-growing primary keys or serial numbers of database data records; creating syntax formats and instructions Create sequencemysequ

  2022-06-01 12:29:00 Views: 260
• 

  Find threads of MySQL 8.0 processes through Linux system threads

  View MySQL process IDps-ef | grep mysqld View MySQL system thread top-Hp 14809 View MySQL thread select * from performa through system thread

  2022-06-01 12:28:51 Views: 299
• 

  Oracle dynamic View Table Field

  Select a.COLUMN_NAME |'('| a.data_type | |')'as data_type,t.comments | |'('| | a.COLUMN_NAME | |'

  2022-06-01 12:28:51 Views: 246
• 

  Navicat for MySQL performs table partitioning operation (illustration)

  1. To create a table partition, the condition of the partition (using the timestamp type) should be set to the primary key (must), or the entire table does not have a primary key (which can be added after the partition is completed) or 2. Switch to the partition operation interface 3. Setting general partition condition setting is not satisfied with partition operation.

  2022-06-01 12:28:26 Views: 284
• 

  Oracle modify data file name / move data file

  The migration of data files is sometimes used in production. The following examples show several migration methods of data files. Database version sys@ORCL > select * from vested version * select * from vested versionterBanner

  2022-06-01 12:28:17 Views: 212
• 

  Redis exercise (6) Building redis Master-Slave Mode

  Redis is a distributed-oriented Nosql product, which naturally supports the active / standby mode, and it is very simple to configure a complete set of active / standby mode. For redis, the configuration of active / standby mode is very simple, but it is of great significance online. The main content of 1.CAP theory 2. Simple red

  2022-06-01 12:28:17 Views: 236
• 

  Oracle Archive File Management

  Archive management oracle archive files are often full or cannot be mounted. Here is a brief introduction to a full case. Backup archive files: Backup archivelog all; backup archive log 1, sql > alter system ar

  2022-06-01 12:28:05 Views: 236
• 

  Create a database DBCA silent installation

  The test environment sometimes requires database instances to be installed. To be lazy and easy, use the following script: vi a.sh content dbca-silent-createDatabase-templateName General_Purpose.d

  2022-06-01 12:28:05 Views: 219
• 

  STM configuration

  Log in to the home page and select service to create a host group to enter an unassigned IP address the IP will generate a VIP edit connection pool input node on the host, you can edit the virtual host with port number to select the connection pool, and the corresponding vip can be set negative under the directory of the connection pool

  2022-06-01 12:28:05 Views: 207
• 

  [MySQL] backup binary log-Binlog Server

  The mysqlbinlog will disguise as a slave and connect to the specified binlog file requested by the main library. After receiving this request, the main library creates a binlog dump thread to push the binlog to the mysqlbinlog server.

  2022-06-01 12:28:04 Views: 212
• 

  Oracle series: (19) add, delete and modify data

  Prepare col empno for 9999ten col ename for a10, job for a10, mgr for 9999ten, col hiredate for a12, sal

  2022-06-01 12:27:46 Views: 249
• 

  Oralce record collection

  Oracle record collection records PL/SQL supports three types of records: table-based (table-based), cursor-based (cursor-based), and programmer defined (programmer-defined) table-based records

  2022-06-01 12:27:45 Views: 298
• 

  Sql development specification

  (benefits of precompilation: 1. The execution plan can be reused to reduce the time required for sql compilation. two。 It is used many times at a time. 3. Avoid sql injection. ) (implicit conversion occurs when columns and parameter types are inconsistent) not in may cause index invalidation, for example, sql injects a

  2022-06-01 12:27:15 Views: 229
• 

  Database-Mysql (JDBC implementation & solving the problem of storage garbled)

  Database-Mysql (JDBC implementation & to solve the storage garbled problem) 1. The solution to the garbled problem is very simple! First, specify the character set as utf-8 when you set up the database, and then when you program JDBC, add a parameter after the url of the following code

  2022-06-01 12:27:12 Views: 285
• 

  Simple login verification

  Write a simple login verification process first create a directory structure model is to manipulate the database table related admin.py is corresponding to the database in the mysql database member under the admin table utility is about operating the database related conf

  2022-06-01 12:27:12 Views: 298
• 

  Open-falcon building

  Environment prepares yum install-y redisyum install-y mysql-server### installation and boots self-booting # export HOME=/home/workexport WORKSP

  2022-06-01 12:27:09 Views: 264
• 

  QT 5 configure MySQL process logging

  Record the configuration process. When you get old, you have a poor memory. 0 installation environment Win10x64+Qt5.5 (x86) + VS2010 (x86) 1 installation MySQL Note: the following is installed according to x64 version, and there is no difference in the installation process of x86 version. MySQ

  2022-06-01 12:26:39 Views: 209
• 

  Basic knowledge of JavaWeb Mysql database

  1.1.Install database    take mysql56 as an example, store it on d disk, open cmd, and enter the following command: (1) d: (2) cd   mysql56 (3) cd   bin (4) mysqld  -install can be installed. 1.

  2022-06-01 12:26:10 Views: 228
• 

  Oracle session NLS_LANGUAGE

  The following code can be added to the package to modify the language parameters of the current session. -- set the session language PROCEDURE p_Set_Nls_Language (Pi_Nls_Lang IN VARCHA

  2022-06-01 12:26:10 Views: 249