How to view the usage of some commands in SQL * plus Sometimes I forget the usage of some commands when using SQL * plus. In fact, we don't have to look up anything. We just need to check it in SQL * plus, Use help |? Parameter For example, in SQL *
MongoDB C # basic driver usage The official MongoDB C # driver can be obtained through this link. Link to the. msiand. Zip methods to obtain the driver dll file. This article introduces the basic database connection of the C # driver and adds,
MySQL installation, configuration, usage and JDBC Link Download: URL: http://dev.mysql.com/downloads/mysql/5.5.html#downloads Select No thanks, juststart my download. Mysql-5.5.36-win32.msi 33.7 M Mysql-5.5.36-winx64.msi 35.3 M Navicat
ORA-01219 database not opened Today after the connection data, a look at the prompt that the ORA-01219 database is not open, closed the service re-opened is still like this, in the Baidu found the problem. I deleted a data file and looked at the
Case study of incomplete records of RAC split-brain logs due to not configured diagwait1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log analysis 2.1 2-node
PL/SQL basics-Exception Handling Exception HandlingI. Exception typeThere are two types of Oracle exceptions: system exceptions and custom exceptions.System exceptions are classified into pre-defined exceptions and non-pre-defined exceptions.1.
Undo tablespace Overview Brief summary of UNDO:1. the segments in the general tablespace are manually created. The undo tablespace is similar to the general tablespace, but the undo tablespace and the undo tablespace are automatically generated.
ORA-14402: updating partition keyword columns will cause partition changes By default, Oracle Partition Table for partition fields is not allowed to update the operation, if there is a forward update on the partition field, the error -- ORA-14402:
"You cannot connect to the WMI provider. You do not have the permission or the server cannot access it. ", Wmi cannot be accessed I recently learned about PowerDesigner and encountered a small problem when I created the PDM model. I thought I was
SQL _ write a simple Stored Procedure for deleting employee information, SQL stored procedure Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise,
Create a Stored Procedure Stored in SQL Server and call C, Stored ProcedureSome compiled and optimized SQL statements placed on the database server can be directly called by the program. Using Stored Procedures has the following advantages:1.
Configure listening _ 1521 port occupation, and listening _ 1521 port occupation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the
SQLCookbook sorting of study notes and impression notesSelect name from emp order by salary;BY default, order by is arranged in ascending ORDER. To do so in descending ORDER, use ordel BY salary DESC.Order by does not have to be based on the column
Xinxing analyzes Server Management in Redis and Xinxing redis Redis was defined as a service process that can run continuously for a long time at the beginning of the design. Therefore, most system configuration parameters can take effect
Xinxing analyzes key-related commands in Redis, and Xinxing analyzes rediskey In Redis, we can also directly operate on keys. The following are common commands: (1) keypattern: It indicates getting all the keys matching pattern. Note that we should
Undo tablespace overview, undo Table OverviewOracle028undo tablespace OverviewBrief summary of UNDO:1. the segments in the general tablespace are manually created. The undo tablespace is similar to the general tablespace, but the undo tablespace and
[Translated from mos] How To restore database and mosrestore when backup of control files is lost How can I restore the database when the backup of the control file is lost? Source:How to restore database when controlfile backup missing (Doc ID 14387
[Translated from mos] Why does rman not use the unused block compression function during Backup? rmanunused Why does rman not use the unused block compression function during the backup process?Source:Why is RMAN not using Unused Block Compression
IMU technology and redo private strand Technology in Oracle, imustrand Oracle030 IMU technology and redo private strand Technology in oracle030Oracle 3. Explain the Oracle IMU Mechanism Select * from v $ sysstat where name like '%
In-depth analysis of a complete transaction, in-depth analysis of the complete transactionOracle029 deeply analyzes a complete transaction2. Diagram of the operational process of a transactionUndo segment composition: Segment header and rollback