Database Administrator

Configure ASM process on Red Hat Linux 6.5 ASM (Automatic Storage Management) is a software Storage solution officially recommended by Oracle. Since the 10g version was officially launched, the position of ASM in the software architecture is

Install and configure an openstack Virtual Machine. When you need to modify the ip address, you can modify the ip address in the database. Since many tables are created when the openstack environment is configured, the local ip address is configured.

SQL Server date function, SQL Server date Current System Date and Time Select getdate () 14:52:27. 123Extract data from date Day (), month (), year () Select getdate ();-14:52:27. 123Select YEAR (getdate ();-2015Select MONTH (getdate

Oracle learning path (5) ----- General oracle data type operations, oracle ----- oracle1. Some common Operators Operator Meaning = Equal <> ,! = ,~ =, ^ = Not equal Less >

Oracle learning path (4): oracle learning pathLOB type ORACLE provides the LOB (Large OBject) type for storing Large data objects. ORACLE currently supports the BFILE, BLOB, CLOB, and NCLOB types. NCLOBStores large NCHAR character data types.

MySQL-10 configuration items that must be adjusted for newly installed MySQL (episode) and 10 configuration items for MySQL Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46324419 I am still worried about the

Oracle stored procedure execution can input SQL statements and return result sets, oraclesql 1. Create a test table: Create table AAA(Aa NVARCHAR2 (100 ),Bb NVARCHAR2 (100 ),Cc NVARCHAR2 (100 ),Dd NVARCHAR2 (100)) And import the test data insert

Oracle 11g audit file and oracle11g audit file Audit: The audit option enabled by default for 11g. The default value of the AUDIT_TRAIL parameter is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in

One of the practical skills that can greatly improve the performance of SQL TUNING optimization. When we perform SQL optimization, we often encounter the need to sort a large number of datasets and then retrieve the first part of the results from

ORA-00257: archiver error. Connect internal only. until freed, ora-00257freed1. plsq logon Error ORA-00257: archiver error. Connect internalonly. until freed  2. the alert Log in the background reports the following error: [Oracle @ powerlong4 ~] $

Winform: Login form of the student information management system, winform form skin Well, I have been learning this piece of knowledge for a long time. I feel that the learning progress is still slow. I have been learning Winform recently. I have to

MySQL backup -- mysqldump, mysql -- mysqldump Back up MySQL directly by using the mysqldump command to back up it to the SQL format. The simplest command is: mysqldump databasename > bak.sql The generated bak. SQL content format is as follows: --

Error code: 1052 Column 'stu _ id' in field list is ambiguous, stu_idambiguous 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: select stu_id, (SELECT stu_name FROM t_student_info t WHERE t_student_info.stu_id = t.

Database practice full notes comprehensive exercises (1) query of teaching information and comprehensive exercise information This instance runs on Oracle10g through: I. Question requirements The instructor's teaching information is stored in the

Oracle shared service connects to static registration service, oracle static Oracle shared service connection static registration service By default, the oracle shared service is registered to the dynamic registration service.Sys @ PROD3> select *

SQL is required. Note chapter 15th inserts data. SQL is required.15.1 data insertion Insert can be used in several ways:(1) Insert the complete row(2) Insert a part of the row(3) Insert some query results15.1.1 Insert the complete row INSERT INTO

ACCESS Database reserved words are used with caution, and access database is used with caution Today, I have been looking for a solution to the following errors. The final solution surprised me. It took me one afternoon to get started ..... A

Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2 Download required software: Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9 Download link: http://pan.baidu.com/s/1gdH53IN Step 1: Install Oracle_11

Use MongoDb Extension for Yii 2 to connect to the mongodb distributed service, mongodbyii 1. connect to a common mongodb instance. Refer to the MongoDb Extension documentation as follows: Http://www.yiiframework.com/doc-2.0/ext-mongodb-index.html

Install Oracle12cR1 on Oracle Linux in VirtualBox, oraclevmvirtualbox Summarized today, using simple several words to describe how to install Oracle Database on Oracle Linux as following. *** Login as root user1. Update host name in/etc/hosts 2.