Oracle

  Solution for Oracle to forget the user name and password Operating System: windows xp Oracle 10.1.0.2.0 I have not installed Oracle for a long time, and the password changed by sys and system is also forgotten. Therefore, the following solution is

  When NET is configured on the local machine, the following error message is displayed:   In this case, the configuration is not successful at all. Even if all the parameters are configured, the operation fails during saving. In Oracle10g, the

We are all familiar with the recycle bin in windows. You can restore the deleted files to the recycle bin. the Oracle recycle bin works exactly the same, but there are some differences in implementation details. in addition, the recycle bin can only

Indexes are often created to improve data access efficiency. However, each index reconstruction operation slows down when the data volume is large, affecting the processing efficiency. Therefore, for a large amount of data, it is often used to

How to obtain the first few pieces of data in the Oracle database? It is similar to the select top n method in SQL statements. This article will show you the answer, for example! 1. implement select top n in Oracle: Since ORACLE does not support the

We all know that alter table move or shrink space can contract segments to eliminate part of row migration and space fragments, so that data is closer. However, moving and shrink space are different.Move will Move the high water level, but will not

Oracle 10g 10.2.0.1 RAC ORA-12520This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works. [Oracle @ R1 ~] $ Sqlplus system/test @ RAC SQL * Plus:

During Oracle 11g installation, the following two problems are frequently encountered: Oracle 11gORA-00845: MEMORY_TARGET not supported on this system descriptionHttp://www.bkjia.com/database/201202/119409.html [INS-35172] Target database memory

First, use the useradd weblogic command to create the weblogic account Run the script shown in the weblogic directory and execute weblogic installation. The welcome page for Weblogic is displayed. Click Next to continue. Create the BEA product

1. You can use SQL * Plus statements to change environment parameters. SQL> set linesize 900;/* change the display width. After it is set to 900, a row of data will not be displayed in two rows */ SQL> set pagesize 20;/* set the number of page

A long time ago, when I was still at X Tang Telecom, I was asked by the leaders to optimize an SQL statement. At that time, I did not know what SQL optimization was at all. However, after Baidu and google found that all the materials had such a

After starting sqlplus each time, you need to make some basic settings before editing the code. Today, let's take a look at the book and find a simple way to solve it. Find the login. SQL (glogin. SQL) file in the oracle installation directory. My

Two recent Oracle Database faults are related to the firewall. The firewall here is a hardware network firewall, not a software firewall. Let's talk about it briefly. An Oracle 9i running on a Windows system, the client cannot connect to the

Common Oracle database objects-indexes and synonymsI. IndexA) advantages of using IndexesI. A table-independent schema object that can be stored in a disk or tablespace different from the tableIi. If the index is deleted or damaged, it does not

1. Modify the maximum number of connections in Oracle. a. log on to PL/SQL or Worksheet B as sysdba and query the current number of connections; c. Change the number of system connections alter system set processes = 1000 scope = spfile; d. create

With alias as (select * from *) select * from alias; equivalent to creating a temporary table syntax is with tempname as (select ....) select... example: with t as (select * from emp where depno = 10) select * from t where empno = xxx another simple

INSTR (source string, target string, start position, matching serial number) in Oracle/PLSQL, The instr function returns the position of the string to be truncated in the source string. It is retrieved only once, that is, from the start of the

DECODE function: Compares the input value with the parameter list in the function and returns a corresponding value based on the input value. The parameter list of a function is a sequence of several numbers and their corresponding result values. Of

L database Triggers are stored PL/SQL programs associated with tables. When a specific data operation statement (Insert, update, delete) is issued on a specified table, Oracle automatically executes the sequence of statements defined in the trigger.

I recently came into contact with Oracle Form Builder and encountered some problems in the application. The following is a summary of these problems:I. the installation of FormBuilder 10g FormBuilder 10g is incompatible with win7, so it cannot be