Database Administrator

0. differences when querying groups When using Group By grouping in Oracle databases, the columns after select must be group Columns (Group by (columns) or lie with Aggregate functions. However, MySQL does not need to be grouped as needed. Mysql>

Problem description: Oracle installed in Linux by a colleague, the default character set is not modified. WE8ISO8859P1 is used and Chinese characters are not supported, The problem is that the Chinese data entered by the client can be displayed.

// Has the following binary tree and converts it into a table structure: Parent_id child_id weight ------------------- A B 2 B c 3 C d 4 B e 7 C f 2 // Calculate the product of the edge weight between the leaf node and the root node: Leaf

Guidance: MySQL has four transaction isolation levels: Read-uncommitted, Read-committed, Repeatable-read, and Seriailizable. I believe everyone knows their similarities and differences, if you are not clear, you can refer to another technical

Linux This method should be the quickest way to solve Chinese Garbled text. You do not need to change the mysql encoding, but only use it in linux: 1. In the main function of main. cpp of the QT program, the three sentences of QTextCodec ''' are as

DML (Data Manipulation Language) is a Data Manipulation Language, one of the types of SQL, in addition to the Data Definition Language (DDL) Data Definition Language and Data Control Language (DCL) Data Control Language. DML includes INSERT, UPDATE,

/* Obtain the pinyin corresponding to the name of the Oracle function */ Create or replace function F_GET_PY (V_XM varchar) RETURN VARCHAR2 ISS_py varchar2 (100 );Z_hz varchar2 (2 );Z_py varchar2 (10 );I number (3 );I _jls number (5 );BEGINS_py: = ''

We usually need to configure the core parameters of the Linux system when installing and setting the Oracle database on Linux or replacing or upgrading the hardware, and then adjust the parameters of the Oracle system. Kernel. shmall is the physical

After mysql is installed, you can start the bin-log function to record database data operation records and recover data when necessary. mysql logs are divided into the following types: Error log:-log-err Query log:-log Slow query

If you cannot create an Oracle table, log on to the server and check it. I tried to create a table, prompting you That the tablespace is insufficient. If you want to expand the tablespace, you will be OK, the following two errors are reported: ORA-0

Environment:Rhel-server-5.5-i386-dvd #! /Bin/bashEcho "kernel. shmall = 2097152">/etc/sysctl. confEcho "kernel. shmmax = 2147483648">/etc/sysctl. confEcho "kernel. shmmni = 4096">/etc/sysctl. confEcho "kernel. sem = 250 32000 100 128">/etc/sysctl.

Database Version Oracle11gR2SQL> select * from v $ version where rownum = 1; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production Create a manually

Install_mysql_CentOS5.6Conclusion: in fact, the answer is always in front of us, but we are always easy to ignore them. I thought, quietly, and the answer is there.1. download mysql-5.1.56.tar.gz to/opt/src2. $ cd/opt/src3. $ tar-zxvf

I want to monitor a Job. The session is in the Library cache lock wait state. The database has two nodes.SQL> select inst_id from gv $ instance; INST_ID----------21 SQL> select inst_id, sid, serial #, event, p1raw, machine, status from gv $ session

1. When installing cluster in Oracle 10g, the following error is prompted during the period from 61%: WARNING: Error while copying directory/home/oracle/app/oracle/10R2/crs with exclude file list 'null' to nodes 'rac2 '.[PRKC-1002: All the submitted

-- Oracle paging statements-- Id of each recordSelect t1. *, rownum rn from (select * from emp) t1;-- Retrieve the first 10 recordsSelect t1. *, rownum rn from (select * from emp) t1 where rownum -- Extract 6th to 10th records. This statement can be

Database Version:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0Create a test table:SQL> create table a as select * from all_objects;Table created.SQL> set autotrace on statistics;Insert data (hint append ):SQL> insert/* + append */into a

Because a lot of data is on the Hadoop platform, when migrating data from the hadoop platform to the hive directory, the default delimiter of hive is \, In order to smooth migration, you must specify the data delimiter when creating a table. The

1Error prompt SlaveI/O:ErrorConnecting to master 'backup @ 192.168.1.x: 100'-retry-time: 60 retries: 3306, Error_code: 86400 Solution (f ā ng f ǎ) Delete all binary log files from the server, including one data

Today the customer's Oracle 11.2.0.2 database encountered the ORA-600 error. The error details are as follows: Fri Sep 16 15:23:52 2011Errors in file/u01/diag/rdbms/ora1/ora1/trace/ora1_ora_20382140.trc (incident = 169704 ):ORA-00600: Internal error