Database Administrator

Create the wm_concat function on Oracle 12C The wm_concat function has been abandoned on Oracle 11gR2 and 12C. At that time, many of our programmers used this function in the program, leading to program errors. To reduce the workload of programmers

Overall physical migration of Oracle databases on Linux platforms Overall physical migration of databases on Linux platformsRequirement: machine A is no longer in use. You need to migrate the Oracle of machine A to machine B.I have previously

Preparation of RMAN backup policy for the DG Environment Database Preparation of RMAN backup policy for the DG Environment Database:Primary database (Primary) Full database backupArchive backupDelete historical foldersStandby database

ORA-00918 column ambiguously defined, ora00918In 11.2.0.1, the same SQL statement can be executed normally:Select -- coupon income'Voer er' as summode,A. billingdate,A. rdate,A. storeroomid,A. accountscode,G. accountsname,I. RELATED, -- business

SQL Study Notes (21) ---------- add Foreign keys and Study Notes ---------- I have been busy with exams recently! As soon as I saw the exam, I was covered! Completely blank brain, uncontrolled, coupled with abnormal invigilators, let alone how

The new 11g feature ENABLE_DDL_LOGGING initialization parameter and the new oracle11g feature ENABLE_DDL_LOGGING starts from 11g, but there are bugs in 11.2.0.2 and 11.1.0.7. This bug is described: Bug 12938609-ENABLE_DDL_LOGGING does not log RENAME

Error Code: 1414. OUT or INOUT argument 2 for routine company. new_procedure is not a variable or NEW, too loginout 1. Error description 16: 27: 36 call new_procedure (20150112,1) Error Code: 1414. OUT or INOUT argument 2 for routine company.

Converts column data separated by commas (,) in a column into a function for displaying row data. This is an example of a string segmentation function. select to_number (strvalue) as Value from table (fn_split ('1, 2, 3 ', ',') select to_char

Data Table field attribute query, data table field attribute --- Query all database table namesSelect id, name from sysobjects where xtype = 'U' order by name--- Query all the field attributes of a tableSelect * from syscolumns where id = object_id

Install MongoDB and windowsmongodb in Windows 7 1. Download The mongodb-win32-x86_64-2008plus-2.6.7-signed.msi (now the latest version has reached 3.0) 2. For a 64-bit operating system, double-click the mongodb-win32-x86_64-2008plus-2.6.7-signed.msi,

For Oracle RAC node eviction caused by heartbeat Network (not instance eviction), oraclerac Node eviction of Oracle RAC caused by heartbeat Network (not instance eviction)   Q:Suppose the following scenario: for the four node rac, the heartbeat

Filter conversion can be optimized at one time, and filter conversion can be optimized. There is a problem with SQL Performance. When a filter is found in the execution plan, you should be careful when it comes to it. Like nestloop, my previous blog

Large set of basic SQL statements and large set of SQL statements Every time I used to use SQL Sever to directly design the database, but did not pay enough attention to the SQL statements. I took the opportunity of restructuring the cooperative

Implement HTTP storage plugin and drillplugin in Drill Apache Drill can be used for real-time big data analysis: Inspired by Google Dremel, Apache's Drill Project is a distributed system that performs Interactive Analysis on large datasets. Drill

When inserting mysql database Chinese information in the cmd console, the insertion failure solution is as follows: mysql Chinese Information Fault code: Mysql> insert into t1 (name, sex, age, address) values ('zhang san', 'male', 11, 'shahe ');

MySQL database insertion speed adjustment, mysql database insertion Environment Introduction: CentOS 1, 6.5 MySQL 5.5.40 Hardware: 4-core, 4 GB Reference link:Http://dev.mysql.com/doc/refman/5.5/en/insert-speed.html

Application of Oracle timer and Oracle Timer Oracle timer. Once set, the restart of the server will not affect the execution of the Oracle timer (scheduled to be executed every day ), Begin sys. dbms_job.submit (job =>: job, what => 'check _ err; ',

Redis data structure (2) dictionary, redis Data Structure dictionary The Redis dictionary is actually a Hash table. Its implementation is similar to the hashmap structure in JAVA. Key-Value pairs are stored in Key-Value mode, but there are some

Binary Tree of DS A binary tree is another tree-type structure. It features that each node has at most two Subtrees (that is, a node with a degree greater than 2 in a binary tree), and, the subtree of a binary tree can be left or right, and its

[Blog recommendations] use shell scripts to automate Database Backup This blog post is from the Bkjia blogger Lemon. If you have any questions, go to the blog page for an interactive discussion!Blog: http://maomaostyle.blog.51cto.com/222