Database Administrator

MySQL full-width conversion to half-width Preface: When a user entered a fullwidth mobile phone number during registration, the text message system failed to send the text message based on the mobile phone field. Now the question is, how can I

Create an Oracle 11g database using commands This document describes how to create an Oracle database that complies with the OFA specification using the create database Command of the Oracle database. 1. Set the environment variable (vi.

Basic knowledge about NoSQL Databases This article is from: NoSQL database getting started. For details about how to download the PDF version, seeWhat is NoSQL? Have you heard of NoSQL? In recent years, this word has received a lot of attention.

Oracle simple script example, oracle example Oracle simple script example 1. Add a table -- Modified on: 2014.09.21 -- Modifier: Yi xiaoqun -- Modified: added the purchase payment form. DECLARE VC_STR VARCHAR2 (5000 ); VN_COUNT NUMBER; BEGIN --

MySQL variable definition and assignment, mysql variable assignment Variables can be declared and used in subprograms (functions, stored procedures, anonymous blocks). These variables are used in the BEGIN... END program.Syntax format for defining

Oracle (replace + substr) function used in combination, oraclesubstr select replace('33021622221111',substr('33021622221111',7,4),9527) from dual; How to Use the substr function in oracle SubstrTruncates string functions in

Exp/imp encounter two problems (ORA-00904 and the objects were exported by ABC not by you), ora-00904exported Recently, I was responsible for setting up the user environment of a system, which involved importing data from the test environment. due

Cannot update identity column 'xxx', identitycolumn Sqlserver -- how can I modify the id of the primary key to be updated manually? #1 open the table Design Interface #2 Change the is Identity attribute of the primary key id to No In this

ORA-12705: Cannot access NLS data files or invalid environment specified, ora-12705nlsIf an accident occurs due to the configuration of the oracle client, you can directly Delete NLS_LANG from the environment variable.ORA-12705: Cannot access NLS

Understanding of DRM in oracle 10g RAC, racdrmSummary of DRM1. What is DRM?Dynamic Resource Management (DRM) is a new feature of oracle 10 Gb. in oracle rac environment, ORACLE uses GRD (Global Resource Service) to record Resource information of

Data room charging system-stored procedure and stored procedure I wrote a view and a trigger on my blog two days ago. I didn't want to write a stored procedure. I just wanted to use it. however, I encountered a lot of problems in the process of

SVM-based data classification prediction-Italian wine classification identification, svm Italy Wine data comes from the UCI database and records the chemical composition of wine 13 of different varieties in the same region of Italy, so as to achieve

Petelai project experience collection (4) ___ reverse engineering of SQL SERVER, import the database to PowerDesigner, petelai PD is a good database design tool. In the project of petelai, at first, the partner designed 10 tables with PD. We

Queries the average number of transactions per second and the average number of transactions per second1. Directly query the view select * from DBA_HIST_SYSMETRIC_SUMMARY where metric_unit = 'transactions Per second'METRIC_NAME metric indicator

Chapter 1 Securing Your Server and Network (11): transparent database encryption, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

The Oracle HR example uses 10g, 11g, and oracle11g. Oracle HR example users can create 10g, 11g First, add the 10. SQL files in the attachment (see the end of the article) to this path: $ ORACLE_HOME/demo/schema/human_resources   Script

Data room charging system-Additional database, additional data room Charging System When attaching a database, the following error occurs: "An error occurred while appending a database. For details, click the hyperlink in the" message "column

Concept Structure Design and Billing System Structure Design The general process of database design must be known to everyone. People who do not know can easily find relevant information on the Internet. Generally, we divide database design into six

Redis memory fragments and Redis memory fragments Redis uses jemalloc to allocate memory by default. According to the best article in fast '14, when a variable-length key-value load occurs, the fragmentation problem may occur: low memory utilization,

Optimize hundreds of millions of data queries in 10 minutes and query hundreds of millions of data records A user developed QQ to contact me a few days ago, as shown below: Free dolphins. 16:12:01 Island Lord, I cannot find the result of one of my