Database Administrator

This article describes how to use ASP to display data records in Oracle. I. Introduction Pagination is required when you access a table with a large amount of data through a browser. ASP can display database records by page through the ADO object

The default MySQL Character Set provided by the system is not gbk. Therefore, it brings great inconvenience to the database promotion and application and the development of Chinese programs, the endless conversion between GBK and UTF8 consumes

The DB2 UDB Security Model consists of authentication and authorization ). Figure 1. DB2 UDB Security Model 1 2 3 4 5 6 7 8 9 Next Page [Content

Because of its competitive prices and ease of use, MySQL has gradually increased its market share. The open source code community has developed a database connector that can be used in. Net Framework (. NET Framework) to extend the scope of use of

I now have a table with the same data. Now I want to modify one of the data in this field (the letters and so on after the data ),The table is as follows:Mysql> desc test;+ ------- + ---------- + ------ + ----- + --------- + ------- +| Field | Type |

Now there is a Linux server with Oracle installed on it. We want to use the conn/as sysdba statement to log on to the database and manage the database. However, there is always an error, the error such as Service Name cannot be found. What is the

The system crontab is used to regularly execute Backup files and save the backup results by date to achieve the purpose of backup.1. Create the path to save the backup file/mysqldata# Mkdir/mysqldata2. Create the/usr/sbin/bakmysql file.# Vi/usr/sbin/

To enable normal display of Your webpage on more servers, add "set names UTF8" (you can select the appropriate encoding, such as gb2312 ), even if you do not add this sentence, you can access it normally. Let's talk about the character set of MySQL.

Install MySQL in CentOS5Create a mysql user group and user[Root @ centos] # groupadd mysql[Root @ centos] # useradd-g mysql[Root @ centos] # cd homexule[Root @ centos] # chmod 755 mysql-5.0.22.tar.gzCompile and install MySQL[Root @ centos] # tar

1.Mysql -- xml (-X) is used to display MySQL query results in XML format;Mysql -- html (-H) is used to display MySQL query results in HTML format;This output makes it easy to integrate with other programs.(For example, the query results obtained in

Two different Oracle database servers read the data of a user under another database server from one database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database. When creating dblink, you need to know

Main functions in DBMS_ SQL Encapsulation1. OPEN_CURSOR: returns the ID of the new game subject.2. PARSE: PARSE the statement to be executed3. BIND_VARIABLE: connect the specified quantity to a specific variable.4. DEFINE_COLOUMN: defines a field

Related links: Brief Introduction to MongoDB (installation) I. Start the service 1. Bind the virtual IP address of LVS on each RS (Real Server) and suppress ERP [Root @ LVS_RS_104 ~] #/Etc/rc. d/init. d/lvs_dr.sh startRealServer Start OK[Root @

Select comm from emp;-- Query the employees with the highest salariesSelect ename, job, sal from emp where sal = (select max (sal) from emp );Select ename, job, sal * 13 + nvl (comm, 0) * 13 s from emp order by s desc;-- Query average salary and

Purpose: Do not memorize scripts. You can use them without having to understand the meaning of the view.Including: V $ SYSTEM_EVENT/V $ SESSION_EVENT/V $ SESSION_WAIT/V $

-- Create a partition tableCreate table test (x int, y int)Partition by range (X)(PARTITION PART0 values less than (100 ),PARTITION PART1 values less than (MAXVALUE));-- Create an indexCreate index IDX_TEST_X on test (X) LOCAL;Create index

When online backup is performed, the output is modified to dynamically upload the output content to the browser page.   Import java. io. BufferedReader;   Import java. io. IOException; Import java. io. InputStream; Import java. io.

In the database O & M process, Shell scripts provide great convenience for O & M. The passing of shell script parameters as variables to SQL and SQL scripts is also a common situation for DBAs. This article mainly discusses how to pass parameters of

The Oracle monitoring index feature allows us to roughly determine whether an index is used. This is because the index is monitored when statistics are collected in Oracle 10 Gb, which is not produced by SQL statements. In the case of 11g, there is

Unlike SQL Server, which uses # In the stored procedure, you can create a temporary table to cache the data to be processed. Oracle mainly needs to create a temporary table structure physically and use the global temporary table keyword. Syntax: --