Database Administrator

How to extract Chinese character strings from Oracle In actual work, we often need to use the function of removing special characters, especially the data inserted into the database. To ensure the data quality, we often need to clean the data, that

Use pt-table-checksum to verify data consistency The consistency check of Master/Slave Data is a headache. It is frustrating to be occasionally complained about inconsistency between master and slave data or data inconsistency between several slave

ORA-00600 [kqlInvObj: user] Processing Today, our brother called us to say that after I installed 11.2.0.1.0 on the Development Database (win7 64bit), I had a problem with the Data Pump derivative, which was hard to solve. Then I ran the SQL

Ing SQL Server database users to login users Recently, a friend of mine accidentally shot the SQL server database. After several twists and turns, the data restored the database to the new environment. After recovery, there will be a user name at

Oracle 11gR2 Active Data Guard adjustment case [1] The customer's environment is Oracle RAC Database 11.2.0.3 for Linux x86_64bit + Oracle Database 11.2.0.3 for Linux x86_64bit (ADG slave Database). RAC uses ASM and the slave Database uses the file

Oracle Database cannot be accessed using localhost and 127.0.0.1 I recently learned about Oracle databases and installed Oracle 10g (Version: oracle_10g_10.2.0.20.win32) in Windows XP SP3 on a virtual machine ). After the installation is complete,

RedHat6.5 install Oracle 12C RAC 12c RAC Installation Process Note: The following configurations are executed on both nodes.1. Network Configuration Take rac01 as an example. Both nodes must be configured. Eth0 and eth1 are bond0 Eth2 and eth3 are

Be careful when using with in Oracle -- predicate cannot be promoted Today, we can see that a SQL statement uses with in large quantities. For logic clarity, developers cache some result sets first with, and there are many places to use this result

Oracle source code for verifying the correctness of bank card numbers, oracle source code Create or replace function checkBankCard (p_bankcard IN varchar2)RETURN varchar2 -- RETURN OK when the request is correct; otherwise, RETURN the correct

MySQL (I) and mysql (I)1. Start the MySQL service and log on to the MySQL database 1. Start the MySQL Service   1. Click the Start Menu of a single machine. In the displayed menu, select the run command to open the run dialog box. 2. Enter "services.

Oracle start with... connect by prior implements recursive query and oracle recursive query Basic Syntax: select... from where start with connect by ; : Filter condition, filters all returned records. : Conditions for restarting the root node

I. mongodb sharding: add and remove shards on multiple simulated nodes in win7 environment. mongodbwin7 This article describes how to simulate mongo sharding on a win7 computer. If you have multiple servers, you can deploy each mongo on a single

Summary of common mysql commands and common mysql commands I. Database-level operations 1. log on to mysql The common format is mysql-u user_name-p. Press enter and enter the password and press enter again. 2. view all existing databases Show

Mysql batch imports text data into the database C language (c api), mysqlapi In fact, the principle is very simple. I think everyone should have read the article I wrote (a code learns to operate databases in C) on linux, the basic student

Firebird Database On MacOSX, firebirdmacosxFirebird Database Firebird, as an excellent embedded (one function), is most suitable for desktop development. I have also used SQLITE to do some gadgets before, but it does not perform well in terms of

Oracle set feedback, oraclefeedback 1. set feedback on Oracle will give feedback when an SQL statement is sent by default.For example, execute the following table creation statement: Create table t_test_lll (id varchar2 (10 )); The command line

How does mysql make order by and mysqlorderby? Order by clsesIn general, the optimizer will skip the sort procedure for the order by clause if it sees that the rowsWill be in order anyway. But let's examine some predictional situations. For the

Common memcache monitoring methods: memcache monitoring Common memcache monitoring methods 1. graphical mode: Reference: http://jingyan.baidu.com/article/6525d4b11f482bac7d2e94da.html Download memcache in http://pecl.php.net/package/memcache,

[Monogdb] MongoDB's top 10 application design skills: monogdbmongodbTip 1: a compromise between speed and integrity Data used in multiple documents can be embedded (Anti-paradigm) or referenced (paradigm. This strategy has no advantages or

Implement POSTGRESQL cross tabulationHere I will demonstrate how to implement cross-tabulation display in POSTGRESQL. As for what a cross-tabulation is, I will not talk much about it.The raw table data is as follows: t_girl=# select * from score;