Oracle instr function usage and (oracle uses instr to replace like), oracleinstr Oracle instr function appeared in the recent project, so I found some information about it on the Internet. Usage of INSTR and SUBSTR in Oracle INSTR usage in
The reason why the oracle task process is not executed after it is submitted is /* Run the following command in SQL * Plus */-- check steps when the task is not running -- 1. check whether the instance session is RESTRICTED by select instance_name,
Hibernate-tree ing and hibernate treeTree Map Hypothesis: The structure of a table is as follows: Id Parent_id Name The company's organizational structure is tree-like ing Example: Package com. zgy. hibernate.
Set the password after installing Mysql in Linux. After Mysql is installed in Centos, the root password is not used by default. The default password is press Enter, You need to change the password for convenience. If there is no password for
Abnormal TXT and logslaveupdates Recently, it was verified that a specific table was copied from the slave database to another master database for adjustment. If log-slave-updates is not configured, the table cannot be synchronized normally. The
Ora-12514 tns listeners cannot identify the Service requested in the connection descriptor, ora-12514tns Today, when you remotely connect to a linux server, this error occurs: tnsnames. ora and listener. ora file configuration is not wrong, but is
MYSQL registration Start and Stop unmount batch processing script (Supplement), mysql Batch Processing The batch file that was written earlier when the mysql interface was debugged. Register and start my_install.bat @echo offset MYSQL_DIR=%~dp0rem
Use of TTL in ssdb and use of ssdbTTL[Nerd @ QA tools] $./ssdb-cli-p 8999Ssdb (cli)-ssdb command line tool.Copyright (c) 2012-2014 ssdb. io'H' or 'help' for help, 'q' to quit.Server version: 1.8.0Ssdb 127.0.0.1: 8999> TTL 01: 00000:
MySQL backup script based on Innobackupex, innobackupexmysql Innobackupex is part of Xtrabackup, and its essence is to call xtrabackup. The main difference is that Xtrabackup not only supports the innodb engine, but also supports the xtradb engine.
Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2), connectmysql. sock When mysql is installed in linux, the following error occurs: Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2) This error occurs,
View and add table partitions in MYSQL, and add partitions in mysql View and add table partitions in MYSQL 1. View table partitions SELECTPartition_name part,Partition_expression expr,Partition_description descr,FROM_DAYS (partition_description)
Mysql optimization practice (explain & Index) and mysql practiceLab environment: 1. SQL tool: Navicat2 and SQL database. Use openstack database as an example. I. mysql index Query Show index from instances Result field
SQL anti-pattern: "fear of unknown", SQL anti-Pattern NULL 1. select A | B from table; If one of the fields A or B is null, the result of A | B is null; 2. Use of NULL (identify the suspended value ): (1) Replace uncertain values (2) Replace a value
MongoDB-installation and configuration, MongoDB-installation ConfigurationZookeeper Recently, we formed a team to welcome a new BS project, campus video management, and many people thought about MongodDB when we talked about videos. At that time,
Oracle Performance Optimization Operation 15th: function-based index requires equality matching and oracle Performance Optimization In the previous blog examples, we have created a function-based index, but if you execute the following query:
Oracle Performance Optimization Operation 16: Using partition indexes, oracle Performance Optimization When you use analysis commands to analyze partition indexes, the range of data values of each partition is stored in the Oracle Data dictionary.
Oracle performance optimization operation 18: determines whether to use full table scan or index. oracle Performance Optimization Like all tips, the last trick will go back to the starting point. Finally, let's discuss whether to create an index,
Django many-to-many relationships, django many-to-Relationship Django 1, 1.7 Use ManyToManyFiled to define multiple-to-multiple relationships. In this example, the Article can be published on multiple publications, and the Publication can have
PostgreSQL registration Start and Stop unmount batch processing script, postgresql Batch Processing Register to start pg_install.bat: echo offset PGSQL_DIR=%~dp0if not "%PGSQL_HOME%"=="" ( if not "%PGSQL_HOME%"=="%PGSQL_DIR%" ( echo
Oracle performance optimization operations: Summary, oracle Performance Optimization These articles about oracle performance optimization can be used in combination with each other. In addition, various methods are closely related to each other.