Database Administrator

Use OCCI to access the Oracle database (3), occioracle Now I am writing the code. I don't really want to write it. Let's compile it with an example. In the F: \ PProject \ oci \ 32 \ instantclient-sdk-nt-11.2.0.4.0 \ instantclient_11_2 \ sdk \

Personal notes-oracle, notes-oracle Sequence select * from user_sequences select last_number from user_sequences where sequence_name='T_JGXX_POLY_SEQ';alter sequence T_JGXX_POLY_SEQ increment by 1;SELECT T_JGXX_POLY_SEQ.NEXTVAL FROM DUAL; Meger

The concurrent manager Process of EBS, ebsconcurrent First, use sqlplus to connect to the database and check the connection session. select * from v$session where username='APPS' and program like 'sqlplus%'; View the session information of the

What's shared pool duration ?, Sharedduration This article is the moderator's reply after a PUB asks a question. A shared pool has subpools (starting with 9i) and each subpool has sub-subpools or durations (starting with 10gR2 I think ). it's easy

The random relationship between SQLServer and Oracle corresponds to sqlserveroracle The requirements are as follows: Now we need to complete the singing fields in tb1. The condition is to search for songs sung by the same artist in tb2 and randomly

Mysql extension mysqli and mysqlmysqli Mysqli is the best and fastest mysql extension, and the only drawback is that it only applies to mysql operations. First, check whether mysql has extended mysqli (using phpinfo () function output). Generally,

Sqlserver query data by Pinyin and sqlserver pinyinDirectly execute the following functions and pass the corresponding parameters in the background to query data. Create function f_GetPy (@ str nvarchar (4000) returns nvarchar (4000) as begin

How to start MongoDB as a windows Service, mongodbwindows Service MongoDB is used in recent projects. It is very troublesome to run commands in cmd every time you start the system. Although these commands can be written as bat scripts, this window

Meaning of Oracle create index on (colname, 0), oraclecolname Today, I saw an index, create index index_name tableanme (colname, 0). It's strange that I have never seen it before. After tests, it was found that it was an item relative to the Union

Oracle deadlock and oracle deadlockManually modify the record of a table. The following error is displayed:Then, try to use PL/SQL statements to modify the record. After more than 10 minutes, the record is displayed as being executed;Conclusion: The

The impact of the resource role on the quota of quota tablespaces. resourcequota Two days ago, I saw a brother in the Forum saying that the user set the table space's quota, but the data volume that exceeds the quota can still be inserted into the

Hadoop-2.6.0 pseudo distribution-install and configure hbase, hadoop-2.6.0hbase Hadoop-2.6.0 pseudo distribution-install and configure hbase 1. hadoop and hbase used:   2. Install hadoop: For installation details, refer to this blog

Write a process to dynamically call the queried field and the string value in the where condition, where string Take the emp table in scott user as an example to compile a stored procedure to query the values of a field in the emp table. However,

Reconstruction-User Logon summary, reconstruction Summary At the beginning of the reconstruction, the master asked to implement a main line of login, and then gradually fill in according to this. There are many problems encountered in this phase.

Solve the Problem of installing mysql garbled in ubuntu, and garbled tumysql   Installing mysql in ubuntu   1. Problem description: Insert Chinese characters: Garbled display:   2. solution: Run the following command: Add the

Database Design Process and database Process Get started with user requirements Main functions of the software: Because users are divided into average users, operators, and administrators. The first column is the administrator's function, the

Modify the default encoding in MySQL Linux. The younger brother recorded the modification of the default MySQL encoding here, and changed the default encoding to utf8. I hope this article will help you. Thank you! Environment: Linux: centeros 6.6

Simple operations in MySQL Linux (Service Startup and shutdown, startup and shutdown, view version), mysqllinux Today, the younger brother recorded the simple use of MySQL in the Linux system, as follows: Environment Linux: centeros 6.6 (as shown

6. Basic Redis commands-ordered set, redis command-Set1. Ordered Sets are implemented by hash tables and skip tables. Therefore, even if there are more elements, the process of retrieving intermediate elements is fast.2. An ordered set associates a

Mysql master-slave synchronization and linuxmysql master-slave synchronization in LinuxI. test environment preparation: Master: CentOS release 5.9 x86_64 IP: 10.45.172.40 Mysql Ver 14.12 Distrib 5.0.95 Slave database CentOS release 5.9 x86_64 IP: 10.