Database Administrator

Oracle string truncation and splicing applications Today, someone asked me a question about Oracle string truncation and concatenation. I asked him to write an SQL statement. After reading the Problem description, I tried to solve it clearly, using

Oracle cascade operations When you add a foreing key constraint, you can also specify the cascade operation type, which is mainly used to determine how to process the foreign key fields in the subtable When deleting a record in the (on delete)

Oracle mobile table When creating a table, you can specify a storage space for the table. If not specified, Oracle will store the table to the default tablespace. You can move a table from one tablespace to another as needed. Syntax: Alter table

Oracle query Sequence Oracle queries the sequence of a user, where user_name is the login name of your current database SQL> select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'user _ name '; SEQUENCE_OWNER

Oracle clusters and cluster tables A cluster consists of multiple tables that share the same data block. It stores the related rows of these tables in the same data block, which can reduce the disk read volume required to query data. After creating

DS sequence tables merge two non-decreasing linear tables, ds linear As early as I wrote a linear table, I mentioned this complicated operation. Today we will merge it. It is known that the data elements in the order table La and Lb are arranged in

DS sequence stack and Chain team to realize retrieval judgment and ds sequence Retrieval The basic operations of the sequence stack and the chain team will not be listed one by one. To realize the retrieval judgment, first understand what is the

SQL Server can concurrently obtain the maximum document number in the subscription database to test and solve the bill !, SQL Server Act Note: Many transaction systems require document numbers, and it is a headache to obtain document numbers

LeetCode OJ Employees Earning More Than Their Managers, leetcodeoj TheEmployeeTable holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. + ---- + ------- + -------- + ----------- +

Database Tuning tutorial (9) index TuningIii. Index 6. Several Common possibilities of indexing but not being used I talked about when to avoid using indexes, but sometimes I don't know how to use indexes. Below are several cases where indexes

ORACLE exercises, oracle1. Create a new table a with the same table structure and data as emp.Create table a as select * from emp;2. Add primary key constraintsAlter table a add constraint pk_a_01 primary key (EMPNO );3. Add a field 'birthdate' for '

Use of database indexes and database Indexes I found a problem today. The problem is probably like this. I can query the interface information and use the local database locally for access. However, the access speed will be very busy after being

JAVA transaction attribute ACID; java transaction attribute acidATOMICITY ):A transaction must be completely completed or canceled without ambiguity. When an error occurs in any operation, the effect of all operations that constitute the transaction

Oracle purchase price (III)-x86 price, oraclex86Read Oracle purchase price research (2)Read more Today, the article "New Directions for distributed database applications in the ORACLE to MYSQL-post-prism age" in a company's technical Magazine

Connection Pool technology and technology Concept The connection pool is a buffer pool technology for creating and managing a connection. After the connection pool is ready, it will be used by any thread that needs them. The technology that

SQL and SQL tutorialsAn inner join is a join in which the values in the columns being joined are compared using a comparison operator. In the ISO standard, inner joins can be specified in either the FROM or WHERE clause. this is the only type of

Data replication between tables We can use insert between two tables to implement simple replication (the two tables have the same structure). The example is as follows: SQL> create table T (2 tid number (4 ), 3 tname varchar2 (10) default 'abc ', 4

Use SQL server with the doscommand and SQL server with the doscommandIn general, we can use SQL server under the DOS command and use the DOS command to use SQL server as follows:1. Connect to the database server:The osql command can be used to input

Oracle cascade operations, oracle-levelWhen you add a foreing key constraint, you can also specify the cascade operation type, which is mainly used to determine how to process the foreign key fields in the subtable When deleting a record in the (on

Transport Tablespace Set (3), createtablespace View the source Character Set and endian:SQL> select userenv ('language') from dual;USERENV ('language ') SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> SELECT d. PLATFORM_NAME, ENDIAN_FORMAT2 FROM V