Oracle

See deterministic many times, have been very puzzled, today did an experiment. We cheat Oracle to say it is a deterministic function, which is called only once in SQL. If you do not use deterministic, you can see that the values are different. After

1. Single-line Comment--multiline comment/*...*/2. Naming conventions for glyphs1) When defining variables, it is recommended to use v_ as a prefix v_sal2) When defining constants, it is recommended to use C_ as a prefix c_rate3) When defining

Major library disk issues, causing the main library to go down because the archive has not been applied, resulting in the repository not being transferred to the primary libraryFirst look at the current information about the repository:Sql> select *

DDL locks are divided into three types1. Exclusive DDL Lock2. Sharing DDL Locks3. Can interrupt the resolution lockMost DDL have exclusive DDL locks, such as a table being modified, you can use Select to query data, but most operations are not

public bool Insertoracle (DataTable DataTable, String sql)//Oracle SQL query is table header {string connstr = Wirel essCenterDAL.Common.GetConnDMS1; using (OracleConnection conn = new OracleConnection (connstr)) {try {

Oracle High Water levelHttp://www.cnblogs.com/chuyuhuashi/p/3548260.htmlhttp://blog.csdn.net/wyzxg/article/details/5631721Data file is not reduced after data or data partition is deleted. This is the result of the Oracle database high-water mark.

Environment:CentOS Release 6.4 (Final)First, download the file1. To view the Oracle version first, the corresponding SQL is as follows:SELECT * from V$version;2, according to Oracle version download the corresponding version, first download the

First, system table Space Data Files Migration :Sql> conn/@tmpdb as Sysdba connected.sql> desc dba_data_files;is the name empty? Type-----------------------------------------------------------------------------file_name VARCHAR2 (513) file_id

Original: Installation and configuration of Oracle 11g client.The database and the client are on different machines.Before installing, navigate to the following directory on the server where the Oracle database is installed.Change localhost in

/* Description: If the corresponding user and table space already exists, you need to delete the corresponding user and tablespace first and then re-establish */--delete user xdayweixin cascade;--Delete table space Drop tablespace

One, group function nestingAs defined in Oracle, group functions can be nested only two layers. In fact, multi-layer nesting has no practical purpose, so Oracle does not provide multi-layered nesting of group functions. However, a single-line

Yesterday at the time of the test, it was found that a program written by a developer in the development library is good, but in the test library there will be a problem. Developers have been unable to find the cause of the problem. So it took some

View the Oracle query principle from the Select statement (understand the Oracle query mechanism), selectoracle Step 1: the client sends the statement to the server for execution When we execute the select statement on the client, the client sends

Impdp experience ORA-39001, ORA-39000, ORA-39142Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data version, the

Oracle 12cRAC mobile MGMTDB database data file Method In the previous Blog, we introduced the concept of MGMTDB in Oracle12c RAC. For details, refer:   Oracle 12 cRAC MGMTDB description Http://www.bkjia.com/database/201412/359252.html   By default,

PLSQL _ basic Series 3 _ merge operations UNION/union all/MINUS/INTERSET, plsqlinterset 2014-11-30 BaoXinjian I. Summary If we need to display the results of two select statements as a whole, we need to use the Union or Union All keywords. Union

A deep understanding of oracle transaction isolationIn Oracle relational database, let's look at the following question:A transaction: select from T where id> 10 and id Transaction B: update T set id = 45000 where id = 4501The two transactions are

[Oracle] Chapter 4 Exception Handling Chapter 4 Exception Handling PL/SQL blocks are the basic units for PL/SQL programs. Combine logic-related statements and statements PL/SQL consists of three parts: Declaration, executable, and exception handling.

Oracle Stored Procedure record exception For Oracle stored procedures, an exception can be thrown to the code or recorded in a table. If your system application has many nodes, such as our 40 nodes, if an error is thrown into the code, the error

HowtoDiagnoseOracleDataPump-how to add diagnostic information to a Data Pump There are still many bugs in the 11g Data Pump (expdp/impdp), and we often encounter inexplicable card death, which makes people feel overwhelmed. I recently read an