Oracle

Recently, Oracle RAC on HPUX was implemented because serviceguard first read the documents three days in advance to build a car by closed doors. Getting started at the site also removes some questions about reading documents, which may be the same

Http://easyui.btboys.com/oracle-sort-on-null-value-processing.html   The default null value sorted by order by in Oracle is the largest, which is placed before all data. However, in most cases, we want the null value to sink to the end. In this

I. Define a primary key as an Automatically increasing identifier type In MySQL, if the table's primary key is set to auto_increment type, the database automatically assigns a value to the primary key. For example: Create Table MERs (ID int auto_

Share two SQL statements 1. regexp_replace supported by Oracle SQL SQL> select regexp_replace ('fuck', '(.) (.)', '/123') from dual; Regexp_replace ('fuck ','(.)(------------------------------Ufkcy UO (Haha) There are two letters in a pair.

This type of requirement is usually met in Java development. If a piece of data already exists in the table, update it. If it does not exist, insert new data. If you do not use the merge syntax provided by Oracle, you may first need to query the

In Oracle 10 Gb, the flash back family is divided into the following members:Flashback DatabaseFlashback dropFlashback tableFlashback query (flashback query, flashback version query, and flashback transaction query)The following describes the

This article briefly introduces how to register a database instance on one machine to another machine, for example, registering a database instance on machine A to machine B. 1. Check the status of listener of machine B before machine A registers

The file corresponding to the Undo tablespace that was simulated in the blog last time was lost before the shutdown immediate was restarted. This is just a simulation. In reality, this time period (shutdown immediate --- startup) there is almost no

Send an email using utl_smtp of Oracle. The same statement is tested on the front-end. When SQL plus is entered, an error is returned: ORA-29279: SMTP permanent error 5.5.4 After checking for half a day, I finally found it on Metalink. For such an

Query SQL: Select R. request_id, TL. user_concurrent_program_name | Decode (R. Description, null, '', '-' | r. Description) request_name, RTL. responsibility_name, R. resubmit_interval, Resubmit_interval_unit_code as time_unit, R. argument_text as

To obtain all profile values, because EBS is currently divided into four levels, it requires four SQL Union: select P. user_profile_option_name Profile , '1-site' Scope , 'SITE' value_scope , V. level_value , V. profile_option_value v_profile From

If the processes settings are too large, Oracle cannot be enabled. ORA-27303: Additional information: Invalid shared CTX ORA-27146: Post/Wait initialization failed ORA-27300: OS system dependent operation: semget failed with status: 28 ORA-27301: OS

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or

From: http://cnhtm.itpub.net/post/39970/496967   In Oracle 9i/10g, if the database instance does not have the Scott mode, you can manually create it as follows: Log on to the database Ora_test @ Oracle [/home/Oracle]> sqlplus/As sysdbaSQL *

In view of the problem that DBCP is directly used for JDBC connections, I made a simple example. All resources are from the Internet. It does not need any Web Container, but is a simple console application. Resource:Http://apache.etoak.com//commons/

1. delete a trigger   Drop trigger tib_operationondata (name of the trigger );   2. Create a view   Create view olap_sqandnyerpdeployson(Statdate, expiration, outwarehouseid, inwarehouseid, briefid, professionalid, specifyid, cashbudgetid, price,

Recently, I checked a Linux server and found that the hard disk space has been used for 95%. I am very confused. Why? Is the database file too large? Filesystem size used avail use % mounted on/Dev/mapper/VolGroup00-LogVol00131 GB 118g 6.4g 95%//Dev/

FAQs about Oracle Development Directory Insert and display number data of Oracle Insert and read-out display of Oracle time data Oracle Auto-increment Field [1] insert and display Oracle number data (1) Insert data of the number type Convert the

Common Errors During Oracle usage and development (1) scripts generated by powerdesigner cannot be run directly; Otherwise error: ORA-00942: Table or attempt not to exist Http://www.cnblogs.com/chinafine/articles/1847011.html (2) ORA-00904 invalid

Requirements: When a record is inserted into a table, the ID of a column is automatically inserted and the inserted ID is auto-increment. We can first create a sequence, such as goods_goods_id, and then use the following SQL statement each time to