Database Administrator

MySQL database Event Scheduling) The event scheduler in MySQL can regularly add, delete, and execute operations on the database, which is equivalent to a temporary trigger in the database. It is the same as the execution plan task in Linux, which

The 0RA-01400 error is reported when the materialized view is refreshed. Background: materialized view is one of the three major tools for data warehouse refresh. In actual work, it is used for data extraction on heterogeneous platforms. Today,

Change the MySQL root Password from null to 123456 Requirement: Change the MySQL root Password from null to 123456. Use mysqladmin Mysqladmin-u root-p password mypasswd After entering this command, enter the original root password (empty), and

Oracle PL/SQL Composite data types Composite data types can be roughly divided into two types. The first type is record type, which is suitable for processing single row and multiple columns of data, a bit similar to VO in java; the first type is

How to enable or disable Oracle ARCHIVELOG Mode How to enable or disable Oracle ARCHIVELOG Mode 1. Connect to the database as an administrator C: \ Users \ Administrator> sqlplus sys/sys @ prjdb as sysdba SQL * Plus: Release 11.2.0.1.0 Production on

Configure Oracle ASMLib and disk multi-path on Linux Configure Oracle ASMLIB and multi-path Disks The following documents describe how to use Oracle asmlib to access a multi-path disk on the linux platform, no matter which multi-path software you

In MSSQL, with as and timeline are used to calculate the details and total number of news releases. With cr as (SELECT AddTime, [edit name 1], [edit name 2], [edit name 3] FROM (SELECT NewsID, AddTime, AuditingUser FROM News) AS a distinct (COUNT (.

Install and start mongodb in linux.1. decompress the downloaded package to the directoryLamp @ QA-clg server $ tar-zxvf mongodb. tgzAfter installation, check:[Lamp @ QA-clg Co., mongodb-linux-x86_64-2.4.6] $ cd bin[Lamp @ QA-clg bin] $ lsBsondump

Oracle unlocked and blocked accounts (1) We have a management account in the last step when installing Oracle, which can unlock the account we need, but many people sometimes do not unlock it, Next, we will study how to use the command line to

Project error due to Oracle 10g empty table export failure -- the table or view does not exist, oracle10 g View This afternoon, the data in the remote database is exported and imported to the local database. After the deployed project connects to

Oracle Character Set modification (ORA-29275), oracleora-29275 Today, a friend of the database ORA-29275 part of the multi-byte characters, the corresponding field can only use to_char to query the normal, it is a character set problem. You have

SQL Server Character Processing (LastIndexOf usage), STUFF, CHARINDEX, REVERSE, LEN, charindexDECLARE @ s VARCHAR (100)SET @ s = 'r1-1-1 'Get the number after the last "-"Select REVERSE (@ s) Return Value: 1-1-1R reversed characters select LEN (@ s)

UNION and union all operators, unionall OperatorsUNION operator The UNION operator is used to merge the result sets of two or more SELECT statements. Note: 1. SELECT statements within UNION must have the same number of Columns 2. Columns must also

Mysql RAND () casually query record efficiency issues and solutions to share, mysqlrand Efficiency has always been a problem during our development, especially for a lot of large data operations. Today we have a random query of data, at the

JDBC is used to read Oracle's US7ASCII Encoded chinese garbled characters and the bytes occupied by Chinese Characters in different encodings. Database Version: Oracle 10g Character Set: SIMPLIFIED CHINESE_CHINA.US7ASCII JDK: 1.6.0 _ 45 Oracle

Oracle databases cannot be accessed using localhost and 127.0.0.1. oraclelocalhost 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

Change the Mysql root Password from null to 123456 and root123456 After using mysqladminmysqladmin-u root-p password mypasswd to enter this command, enter the original root password (empty) and change the root password to mypasswd. [Work @ master

NBU7.0 RMAN recovery from different machines not found in NetBackup catalog, rmannetbackup   Problem description: RMAN> run {2> allocate channel t1 type 'sbt _ tape ';3> send 'nb _ ORA_SERV = netbackup, NB_ORA_CLIENT = hz1 ';4> restore controlfile

You can use the table name and field name to query the field type. Today, I encountered a problem: I want to obtain the field type of this field through the table name and field name. I found a lot of methods on the Internet, but I was not

[MongoDB] The Access control of mongodb, mongodbaccess In this blog we mainly talk about the access control including limitation of ip, setting listen port and usage of username and password. in the official document, mongodb server start without