Oracle

The content of this article mainly comes from: http://lbyzx123.javaeye.com/blog/829235   1. Create the script file Oracle10g under/etc/init. d/with the following content:   #! /Bin/bash # Whoami # Root # Chkconfig: 345 51 49

Oracle is installed on the local machine, and the machine starts up every time it starts up. The machine starts up for half a day. Set it to manual start. Services. MSC is required each time and start one by one, which is troublesome. It is much

1. Log On with the system and SYS accounts 2. Create a userCreate User Username identified by PWD default tablespace users;Create username, password PWD, and allocate table space. 3. Authorize a userGrant connect, resource to username; (other

SQL optimization is complex and restricted by the environment. However, the minimum principle for writing SQL statements during development is as follows: 1. oracle uses the bottom-up sequence to parse the WHERE clause. According to this

Insert data using a subquery Create Table emp2 (myid number (4), myname varchar2 (50), mydept number (5 )); Insert into emp2 (myid, myname, mydept) Select empno, ename, deptno from EMP where deptno = 10; Update Data Using subqueries

// create a temporary tablespace create temporary tablespace test_temp tempfile 'e: /Oracle/product/10.2.0/oradata/testserver/test_temp01.dbf ' size 32 m autoextend on next 32 m maxsize 2048 m extent management local; // create a data table

TablespaceCan be classified in four ways 1. data files are classified: Big file tablespace)This is10gNew FeatureSmall file tablespace (smallfile tablespace)This is the default value during creation. Advantages of large file tablespaces include:

1. Automatically increasing data type ProcessingMySQL has a data type that increases automatically. When you insert a record, you do not need to operate on this field. The data value is automatically obtained. Oracle does not have an auto-increasing

Just the day before yesterday, our system did not know why, and we could not store the database for the data. After restarting, we simply couldn't enter the database. Now it's okay, since the pages are not   It must be because of Tomcat problems

It is a pleasure to write a blog every day, but it is also a good habit to read other people's blogs carefully. At the same time, it is a good habit to write a blog worth reading. If one day, we have at least left our footprints... Question: Answer:

Installation preparation:Download filesL Oracle Database 10g Release 2 (10.2.0.1) SoftwareDecompress the fileCommand to decompress the file:Unzip 10201_database_linux32.zipThe decompressed folder may be "Database" or "DB/disk1"Hosts

[Oracle] managing Oracle9i services in Windows Author: builder.comWednesday, June 30 2004 pm Install Oracle 9 in WindowsIMany services will be installed, and some of them are configured to start at Windows startup.

  Address: http://database.51cto.com/art/201010/231598.htm   Oracle image storage is a feature that we often need to implement. The following describes how to use the stored procedure to store images in Oracle. If you have encountered any problems

Oracle searches for the stored procedure name based on the Stored Procedure content   Address: http://hi.baidu.com/chenchendf/item/28c9a1f404f1e449932af2c9 In Oracle, the source code of an object can be in the user_source data dictionary. 1. You

View the table structure:Desc table name; Cancel duplicate columns in distinct. Set timing on; show operation time Insert into users (userid, username, userpass) Select * from users;Insert into student (XH, XM, sex, birthday, Sal, classid) Select *

All codes are tested in SQL * Plus of Oracle 9i. Follow these steps to create independent files. 1. Create your own user file (Table owner ). Prompt -------------------------------------;Prompt this part is to setup Object Creator .;Prompt ----------

This article describes the concepts and operations of partition tables from the following aspects: 1. table space and Partition Table concept 2. table Partition Function 3. advantages and disadvantages of Table Partitioning 4. table partition types

Using python to simulate Oracle sqlplus The team plans to develop the database service platform and needs to use some server script development. To understand python, they have set a small requirement for simulating sqlplus and then implement it. My

As for the problem that Oracle 9i cannot be installed, I went to the Internet to check it. After reading it, I may summarize the following reasons:   1. JDK environment variable configuration problems ------- this is rarely the case 2. Upgrade xp

SQL * loader is large dataRepository selection method, because it provides the fastest way (direct, parallel ). Now, let's leave aside its theory and use instances to makeYou can quickly learn how to use SQL * loader.First, let's get to know SQL *