Oracle

/*Obtain the Oracle service name1. Query the registry and obtain the Oracle Installation root directoryFor example, HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ ORACLE_HOME REG_SZ E: \ oracle \ ora92Find the location of the Oracle service name file:

This morning, I completed the task I proposed for myself yesterday. I finally finished reading PDF files online. At the same time, I solved new problems and added the hand-shaped cursor to control translation. The modification of batch video

Some ASP. NET + Oracle 11G systems write and learn essays, including Oracle's "rownum" and "sequence serial number 」. (6) Oracle rownum, equivalent to the select top of other databases Oracle does not support the select top syntax. to retrieve the

Summary: There are now two tables: person and department. The person table is a sub-table, and the department table is a parent table, which is associated with the foreign key deptid. Now you need to insert data in batches: Each time a

Ideas: You can use a sequential number table to record the current maximum sequential number for future use. Each time a serial number is obtained, the serial number table is updated to a large one. Involved tables: Sequential number table

MTOM interoperability between Oracle app server and Sun wsit A few months ago I wrote a couple of articles (WCF-ORA, ORA-WCF) about message transmission optimization Mechanic (MTOM) interoperability between Oracle Application Server and Microsoft

Download odac Oracle Database 10GRelease 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)       Download the complete files

Oracle Export and Import 1. Use of export/importThe Oracle export/import tool is used to transmit data between databases.The export exports data from the database to the dump file.Import from the dump file to the data import databaseWhich of the

1. Application Development) SQL * Plus E: \ oracle \ ora81 \ bin \ sqlplusw. exe 2. database administration) Database Configuration assistant database configuration ASSISTANT: Create, configure, and delete Databases DBA studio integrates

Numeric functions: ABS (m) Absolute Value of mMoD (m, n) m remainder after N DivisionPower (m, n) M's n powerRound (M [, N]) the value of M rounded to N digits after the decimal point (N defaults to 0)Trunc (M [, N]) m truncates the value of N

The configuration of ASM in Oracle RAC can be implemented in two ways: raw and asmlib. Raw is recommended for actual maintenance.   There are two ways to use raw: Multipath and udev. On the RedHat platform, refer: RedHat 5.4 + ASM + raw + Oracle 10g

  Oracle Aggregate functions has been used a lot. The official website is described as follows:   Aggregate functions Http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions003.htm#SQLRF20035   Aggregatefunctions return a single result row

Software environment: 1. Windows 2000 + Oracle 8.1.7 2. Oracle installation path: C: \ oracle Implementation Method: 1. Start-> Settings-> Control Panel-> management tools-> services Stop all Oracle services. 2. Start-> Program-> Oracle-orahome81->

Technorati label: Oracle Font: Small Medium large | printed on: Author: tangshan_ph Source: cnoug blog homepage Oracle performance can be enhanced by adjusting database applications, databases, and operating systems. Appropriate Oracle adjustment

I. Oracle DatabaseManagement and Maintenance of pattern objects 　　 This section focuses on Oracle DatabaseManagement and Maintenance of schema objects. These schema objects include tablespaces, tables, views, indexes, sequences, synonyms,

When I first started to study C # development projects, I had to worry about writing a secure and efficient database connection for a long time. I found that many friends who have just started learning and some who have been friends for a year or

Organize SchedulerThis part is due to the fact that the execution time of automatic statistics collection on the system is abnormal recently, and the execution time is defined in the morning (this is not a reasonable and reliable time ). this item

In Oracle databases, a series of initialization parameters are used for database constraints and resource restrictions. These parameters are usually stored in a parameter file and read and load when the database instance starts. Initialization

Today, I accidentally discovered an Oracle parameter query command show parameter, which can be used for Fuzzy queries. For example, if I want to query parameters that contain db _, I can use: Code highlighting produced by Actipro CodeHighlighter

Most of the questions raised in the Forum recently are related to column and column conversion. Therefore, I have summarized the knowledge of column and column conversion,I hope it will be helpful to you and make some mistakes at the same time.