Oracle

This article to tell you about the solution of ORA-28002: Password 7 days after the expiration method, you can look at the students who need to refer to oh, good time not to say more let's see it. Symptom description:Log on to oracle 11gERROR: ORA-28

Summary: Syntax and example:1. Stored ProcedureSyntax for creating a stored procedure:CREATE [or replace] PROCEDURE procedure_name[(Parameter_list)]{IS |}[Local_declarations]BEGINExecutable_statements[EXCEPTIONException_handlers]END [procedure_name];

Server Load balancer distributes the load evenly to each node in the cluster to improve overall performance. Oracle RAC provides two methods to achieve load balancing. The following is a detailed introduction. For more information, see Oracle RAC

I. Data Control Statement (DML) 1. INSERT (INSERT the record statement into the data table) Insert into Table Name (field name 1, field name 2 ,......) VALUES (value 1, value 2 ,......);Insert into Table Name (field name 1, field name 2 ,......)

Oracle does not have the auto-increment field function, but it can be implemented through trigger and sequence. Create a test table first: Create table userlogin( Id number (6) not null, Name varchar2 (30) not null primary key ) Tablespace users /  

Today I learned about the latest popular Ruby on Rails. I feel that it is a code generator linked to Oracle.DatabaseI checked the data for half a day. Finally, I found a solution. ^ ______ ^1. Install the driverHttp://rubyforge.org/projects/ruby-oci8

Oracle unlocks SCOTT/TIGER users 1. Verify the current system status for SCOTT users:Select * from dba_users where upper (username) = 'Scott ';ACCOUNT_STATUS: EXPIRED & LOCKED2. Unlock SCOTT users:Conn sys/bitservice @ ttonline as sysdba;Alter user

A table can be partitioned by range, hash, or list. After the table is partitioned, the indexes on the table are different from those on the normal table. oracle classifies the indexes on the partition table into two types:Local and global

Before Oracle9i, Chinese characters were sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i.1. Set the NLS_SORT parameter valueSCHINESE_RADICAL_M is sorted by Ministry (First Order), strokes (Second

The Lag and Lead functions can retrieve the data of the first N rows and the value of the last N rows of the same field in a query. This operation can be achieved through table join for the same table, but LAG and LEAD are more efficient.Copy

1. COMMIT_FORM and COMMIT Both form and database are submitted. Submit the data changes in form to the background database, and submit the data in the database.2. DO_KEY ('commit _ form ') It will first execute the code in the KEY-COMMIT trigger.

What should we do when defining the field name and alias with the same name as the oracle keyword?In fact, it is very easy to add "", such as "group" to this keyword"See the following example:Copy codeThe Code is as follows:SQL> DROP TABLE k;Table

1. Install the patch package required by Oracle11g, which is available on the installation disc. Enter the Server Directory of the disc: (it is best to use the official oracle documentation to determine which packages need to be installed)2. Modify

I. Environment Description Source database:IP Address: 192.168.137.100Sid: catalogUsername: rmanPassword: rmanTarget database:IP Address: 192.168.137.101Sid: orclUsername: rmanPassword: rman2. Create a tnsname for the source database on the target

How to deal with the high cpu usage of oracle, this article will introduce the high CPU usage of the oracle process, You Need To Know More friends can refer1: first, use the TOP command to upload the SPID that occupies the CPU.PID USERNAME THR PRI

Recently, many projects require batch operations. The client passes a set of IDS separated by commas (,) to the database, and the stored procedure needs to separate them and process them one by one.The previous processing methods are as follows:1.

1. View Overview A view is actually a query SQL statement used to display relevant data in one or more tables or other views. The view uses the results of a query as a table. Therefore, the view can be viewed as a stored query or a virtual table.

I have seen some people switch between them before. I was just amazed at the time, and it was over. I didn't remember it until when I used it. I started to look for it everywhere, no trace can be found.Today, I accidentally saw the use of connect by

First, add the ORACLE 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears:Figure 1Click "Start installation" to install ORACLE 10 Gb. Generally, check whether the system configuration meets the

TO_NUMBER (char [, 'format _ model']) character to numeric typeTO_DATE (char [, 'format _ model']) character conversion to date typeFormat description: the format of the string to be converted from the front must be the same as that of the string to