Oracle

This article uses a simple example to illustrate how to write a ruby script to perform Oracle database operations. The main steps are as follows: 1. Download Ruby at the following address: Http://www.ruby-lang.org/zh_CN/downloads/Here we

My environment:[Root @ localhost ~] # Uname-Linux localhost. localdomain 2.6.18-308. el5xen #1 SMP Fri Jan 27 17:59:00 est 2012 i686 i686 i386 GNU/Linux Sys @ orcl> select * from V $ version where rownum = 1; Banner-----------------------------------

(I) Relationship between clusterware and Rac In a narrow sense, RAC refers to a "Multi-instance, single database" Environment built with "some cluster components ". The cluster can be Oracle clusterware, Sun Cluster, etc. Clusterware virtualizes a

Environment: ora10g rhel5.8Description: bbed is called data block browsing and editing. Deep Learning of Oracle block and disaster recovery in special circumstances.1. Compile the connection:CD $ ORACLE_HOME/rdbms/libMake-F ins_rdbms.mk $

The environment configuration for Silent Installation is the same as that for graphical installation. Key points: ① Each response file is in the downloaded software package "/database/response /" Major: Oracle software installation, Please modify

Some people say that there is no index. What can be used to guarantee the constraint? Regardless of whether this is true or false, many restrictions (except not null) are implemented by using indexes to quickly locate constraints. The unique

OracleThis bowl of rice is not good. How many risks are there and how many suggestions are there. 1. Incomplete time point-based Restore, You need to brainwash the control file, tear off the account book (redo log), re-print the account book, this

1 oradebug Introduction   Oradebug is mainly used by Oracle Support staff. Although it was very early, it is rarely recorded on the Oracle official website. It is an SQL * Plus command line tool. You can log on with sysdba permissions without

OffThe essence of database technology is standardized data storage through Relational Tables. Information Retrieval and processing through various table connection technologies and various types of indexing technologies Here think is willing to join

Next to the previous article. ③ Dike DDL commit transactions DDL pseudo code display:BeginCommit;DDL-StatementCommit;ExceptionWhen othersThen rollback;End;Therefore, DDL is always submitted, even if the submission fails. DDL is submitted at the

The rules are as follows: According to this rule, there are only three types of outputs: uppercase, lowercase, and uppercaseThe test is as follows: sys@ORCL> select to_char(sysdate,'Month') from dual;TO_CHAR(SYSDATE,'MONTH')---------------------

1 Prepare the test environment:SQL> Create Table C as select * from Dept; Table created. SQL> select * from C; Deptno dname Loc-------------------------------------10 Accounting New York20 research Dallas30 sales Chicago40 operations Boston SQL>

This index topic has not seen the sun for a long time, I think it is special, unhappy, so I have this article It is rumored that B * tree indexes are often used in the application development stage as "cannon fodder", while in the maintenance

Backup definition.The fundamental purpose of backup is to restore. If needed, it can be recovered, that is, backup. For example, archive log file is a backup of online redo log file. The validity of the backup.Eygle said on its blog: "The system

Complicated and complex execution plans, developer eyes may be lost, resulting in a sexy and silly SQL statement running on the server. There are a few important parts here, as for others, of course, not to be polite ,, (I) Number of returned rows

Whether we use dbca for database creation or manual creation. After the database creation task is completed, three parameters are very important for future production and use. Generally, we need to open them.The first one is log_checkpoints_to_alert.

1,Among them, the most common is update T1 Set B = (select B from T2 where t1.a = t2.a );However, pay attention to the impact of null values,If you are afraid of the impact of null values, write itUpdate T1 set tname = (select sname from T2 where t1.

The previous two articles introduced how to use collection and update collection. This article will introduce how to generate a new collection and add data to it.Procedure insert_object (d in dept_array, D2 out dept_array) is Begin -- First way to

To reduce the number of connections to the Oracle database, multiple data entries need to be input into the Oracle storage process as variables at a time. The method is as follows: Step 1: define the object type.Create type department_type as object

Document directory 1: close ---> nomount status 2: nomount --> Mount status 3: monnt --> open Important references Oracle contains three basic files: 1: Data File)2: Control File) 3: Online redo log file) Concepts of Oracle Database files: