Database Administrator

[Course sharing] practical development of the Project Management System Based on plusgantt (Spring3 + JDBC + RMI architecture and custom workflow), plusganttspring3 Practical development of plusgantt-based project management system (Spring3 + JDBC +

ORA-01555 error with aum (Automatic Undo Management)-cause and solution ., Aumora-01555ORA-01555 error encountered when using aum (Automatic Undo Management)-cause and solution.Reference Original:ORA-01555 Using Automatic Undo Management-Causes and

View, Map RecognitionPurpose: 1. simplify user operations and simplify data. Many data services in the table are relatively redundant. Developers make complex statements into a view, so that other people can directly call the table without the need

How to import SQL Server excel and SQL Server excel -- Importing data from an Excel file to a SQL database is simple. Use the following statement: /* ===================================================== =============================*/-- if the

Let you know software development in advance (36): How to expand data table fields ?, Software Development Field Part 1 Database SQL language How to expand data table fields?   Abstr] Communication Software often deals with databases. Expansion of

Combine Two mysql columns and one mysql Column For example, if there are two columns: surname and name, the query result is one column. The concat keyword is required. The SQL statement is as follows: select concat(firstName,lastName) from tj_user

Introduction to AspectJ In the AOP framework and aspectj In the aop framework In the past few days, I had a headache when I looked at JAVA basics. I decided to change my taste from time to time and start to investigate some popular technologies. So

The host of oracle listener. ora cannot be set to localhost, but should be the machine name. Otherwise, the connection cannot be performed by IP address, listener. ora # Listener. ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1

MySQL wildcard filtering, mysql wildcard You can use the LIKE operator to filter wildcard characters after the WHERE clause: The products table is as follows: A uses the % wildcard: B uses two % wildcards: C. Use underline _ to

Inaccurate statistics lead to execution plan errors and no results can be run. After optimization, it takes only one minute to count the execution plan. One day, I checked the database for a long session and found that one SQL statement ran very

Mysql forgets the root password and mysql forgets the root password.1. stop MYSQL. Open the DOS window in CMD and enter net stop mysql.2. In the CMD command line window, enter the MYSQL installation directory, for example, E: \ Program Files \ MySQL

BIEE11g BI_server Jvm parameter adjustment, biee11gbi_server1. Find the user_projects \ domains \ bifoundation_domain \ bin directory. 2. Copy startWeblogic. sh is the new file startAdminWeblogic. sh, copy setDomainEnv. sh to setAdminDomainEnv. sh,

Introduction to Greenplum distributed database development to proficient (architecture, deployment, management, development and optimization) [course sharing], greenplum TuningGreenplum introduction to distributed database development is proficient (

Configure PL/SQL Developer to connect to the server database, pldeveloperConfigure PL/SQL Developer to connect to the server database Install client software on the Remote Application Server, which can be downloaded from the official oracle website.

Database Connection of ADO. NET database --- ShinePans, ADO. NET technology mainly includes Connection, Command, DataReader, DataAdapter, DateSet, able and other six objects 1). The main function of the Connection object is to connect to the

MySQL sorting: select order by, mysqlorder SELECT and order by are combined for sorting: The products table is as follows: A is sorted by product name column: B is sorted by multiple columns. The default sorting order is ascending:

Oracle instant client, tnsping, tnsnames. ora and ORACLE_HOME, oracletnsping Some time ago, I had to remotely connect to the oracle database, but I didn't want to install the oracle client on my computer. So I downloaded the lightweight client

Set up Oracle10G (5) for RAC in AIX to install oracle and set up listening. racoracle10g Establish a series of RAC instances under AIX Set up Oracle10G (5) for RAC in AIX to install oracle and set up listening Environment Node Node 1

MySQL search: WHERE, mysql search where You can use the where condition to search by specifying a Search Condition in MySQL. In a SELECT statement, data is filtered based on the conditions specified in the WHERE substatement. The WHERE substatement

ORACLE not available, oracleavailableERROR Description: ERROR: ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist process ID: 0 session ID: 0 serial number: 0  Solution: 1. Execute [Oracle @ ay1401_135826z admin] $ sqlplus '