Oracle

SUBSTR () and SUBSTRB () differ in the interception of Chinese characters, a Chinese character may account for 2 or 3 characters, substr () the length of the Intercept refers to the length of the string, the length of the SUBSTRB () is the length of

Table operation Syntax DifferencesWhen building a table, only the self-increment syntax is different.The primary key (PRIMARY key), the foreign key (FOREIGN key), non-null (NOT NULL), unique (unique), and default (defaults) are the same, and the

Recently, after installing the Oracle 10g RAC on the client based on SuSE SP3, I received an error message when Clusterware execution/u01/app/crs/root.sh was installed, Failed to upgrade Oracle Cluster Registry configuration because the current

Reprint Please specify source : http://blog.csdn.net/guoyjoe/article/details/386848191. Get the library cache Latch(1) The text of the SQL statement was not found in the handle of the parent cursor: SELECT * from Gyj_t1 where id=1;2. Release Library

Oh, spent one hours, around the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency. Oh.

Before you start to explain how Oracle sequence is used, add a little bit about Oracle client Sqlplus, that is, if you execute multiple lines of statement, you must add "/" to the end and execute! The topic of this article is to increase the primary

Browse through Oracle's official web pages and unofficial PPT to get a quick overview of the high-availability scenarios Oracle offers.1. RACRAC, Real application ClustersMultiple Oracle servers form a shared cache, and these Oracle servers share a

Defined:A stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database in order to accomplish a specific function. The user executes it by specifying the name of the stored procedure and giving the

C # + Oralce 10GA useful parameter in the project handles the UPDATE statement. The Parameter name and table field have the same name. Execution error: ORA-01722: Invalid numberAfter modifying all parameters and corresponding fields are different.

Oracle Study--oracle Wait event (3)Db file Parallel readThis is a very misleading wait event, and in fact this wait event is not related to parallel operations such as parallel queries, parallel DML. This event occurs when the database is recovering,

Oracle Study--oracle Wait event (5)Db File Single writeThis wait event usually occurs only in one case when Oracle updates the header information of the data file (for example, checkpoint occurs). When this wait event is obvious, it is important to

A: PrefaceToday, I write the cursor for the second time, I wipe, I think I need a great improvement in the database. There are three problems today, the first is the problem of data splitting in Oracle database, which I use REGEXP_SUBSTR to solve,

For Oracle databases, when does the Ogg extraction process get data from the database?Reference text:When GoldenGate fetches Data from the Database on Extraction for Oracle (Doc ID 1059583.1)Suitable for:Oracle goldengate-version 4.0.0 and

View a table with a high degree of fragmentationSELECT segment_name table_name, COUNT (*) extentsFrom Dba_segmentsWHERE owner not in (' SYS ', ' SYSTEM ')GROUP by Segment_nameHaving COUNT (*) = (SELECT MAX (COUNT (*))From Dba_segmentsGROUP by

Oracle transaction processing and instance demonstration jdbc operation batch DeletionTransactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database

OracleHA high availability (II. In-depth analysis of TAF and HA Framework) Oracle HA high availability (one, client, server service details): http://write.blog.csdn.net/postedit We have seen that the Oracle session of TAF can be automatically

Solution to PL/SQL Dev connection to Oracle pop-up dialog box, devoracle No way, you can only study it on your own. After about a day, do it well and write a summary. There are several solutions to this problem: 1. Insufficient permissions. A

OracleGoldenGate's thought sky-understanding the essence of OGG This article is an original article. For more information, see the source. Http://blog.csdn.net/msdnchina/article/details/38347285Oracle GoldenGate's thought sky-understanding the

Quickly detects the lock wait method in the Oracle database and finds out the oracle database In a large database system, to ensure data consistency, the system locks data when operating the data in the database. These locks include read-only locks,

Use the tool plsqldev to import Excel to the Oracle database, plsqldevoracle 1. Use the tool plsqldev 2. Open the excel file to be imported, click the office button, select Save As-other format, select Save type CSV (separated by commas) (*. csv),