Database Administrator

Many of my friends only use Oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your

I. data definition language)A document language is a language defined for the format and form of a document. It is the first thing that every database needs to create, the table relationships, column primary keys in the table, and the reference

One of the top 10g features of Oracle is the Advisory Framework, which is a collection of optimization consultants that can help you make full use of your database. One of them, the SQL Access Advisor, recommends that you change the indexes and

At the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for querying SQL statements and writing complex views, however, after

Today, we will learn how to operate on the MYSQL installed by default in Red Hat LINUX9.Let's start from the start.Start MYSQL:#> Service mysqld startLog on to MYSQL:#> Mysql-u root-pNote: Here-u represents the user name, while root represents the

1. Add a login user and group for 'mysqld 'to run as: Add a login user and group for 'mysqld'Shell> groupadd mysqlShell> useradd-g mysql2. ExtractShell> gunzip | mysql-5.0.15.tar.gz | tar-xvf-Shell> cd mysql-5.0.153. Configure the release and

In Oracle, how does one add time? Today, due to project requirements, I am responsible for writing the stored procedures in Oracle. I have never touched on it before. This is a very good learning opportunity and a good grasp! However, you may

(1) back_log:The number of connections that MySQL can have. When the main MySQL thread receives a lot of connection requests in a very short period of time, this works, and then the main thread takes some time (although very short) to check the

Mysql5.x: http://dev.mysql.com/downloads/mysql/5.0.htmlThe above is the official address of mysql. There are too many mysql versions above, and the speed is very slow. We recommend that you renew them from the Chinese website Mysql tool download:

Recently I wrote an Oracle job, which runs at an interval of 1 minute. However, I found that this job was not running. I initially suspected that the time interval was incorrect, but I found that the time interval was not an error. I also suspected

I. How to start mysql in Ubuntu:/Etc/init. d/sudo mysqld 2. Add a userBin> mysql-u rootMysql> grant permission 1, permission 2,... Permission n on database name. Table name to user name @ user address identified by 'Connection password '; Permission

Log on to Linux as an Oracle user Start Oracle: Sqlplus "scott/tiger as sysdba" Startup After entering sqlplus: Take importing and exporting to xzfw as an example. You must have the write permission for/Oracle/oradata/xzfw to perform the

Method 1: sqlplus "User/password as sysdba" sqlplus "sys/sys as sysdba"Method 2: sqlplus/nolog SQL> conn/as sysdbaSQL> shutdown immediate;SQL> startup mountSQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES =

Today, we encountered an Oracle Function problem when using the Hibernate development project. During project development, all document numbers are generated using a Function. this Function has some DML syntax, so you cannot use select fun _... ()

Connect by is used in structured queries. Its basic syntax is:Select... from tablename start with cond1Connect by cond2Where cond3; Example: Select * from classStart with parentid = 27362Connect by prior id = parentid Simply put, a tree structure is

The following is a summary of installing MySQL in Ubuntu 12.04 over the past few days: There are three ways to install MySQL in Linux: the first is to install the rpmbinary file separately, the second is to install the source code after compilation,

1. Create an array first Create or replace type t_ret_table is table of varchar2 (20 ); 2. Use a custom function to implement 1. Use the function to return an array.Create or replace function f_split_string (var_str in string, var_split In String)

Q: How can I use Slave to filter delete operations in the MySQL master-Slave replication structure. Problem Analysis: this problem corresponds to the preservation of all records, including the delete records. The granularity of MySQL filter rules

1. SQL and PL/SQL code Terminator SQL code uses ";" to indicate code termination PL/SQL code uses "." To indicate code termination, and uses "/" to indicate code execution. Scott @ ORCL> select * from emp where empno = 7788;   EMPNO ENAME JOB MGR

1. Definition Trigger: it is associated with a table or database event. When a trigger event occurs, the trigger defined in the table is triggered and executed. Trigger trigger order 1) execute the BEFORE statement-Level Trigger; 2) for each row