Oracle Installation and Introduction

Because of the trouble of installing the Oracle database today, because of the long-term lack of oracle, we started to consolidate the Oracle knowledge that we learned before.

1. Oracle Database: Client/database server using oracle10g

ORACLE10G can not be installed under Win7, there is no direct support Win7, need to download support Vista oracle10g Modify some of the configuration files before installation, there is time to introduce.

2. Installation:

Configuration: Database Configuration Assistant Metabase instance

Net configuration Assistant Monitoring of the metabase server

Isqlplusctl Start Isqlplus Service (if you need to use Isql*plus)

Service: Oracleservice service for instance name DB instance

Oracleoradb10g_home1tnslistener Monitoring service for database server

3. Oracle's Common management tools:

1) OEM: Enterprise Manager-->dba Http://IP:1158/em

2) Sql*plus: The most commonly used tool. Oracle's client Tools use the command line directly

3) Isql*plus: Operate the database server through the browser http://ip:5560/isqlplus

4. Several users in Oracle:

Sys/oracle--and role sysdba to unlock Scott: Alter user Scott account unlock; Alter user Scott identified by new password;

Scott/tiger-->normal ordinary users. There are some sample database tables

5. Common commands for Sql*plus:

1) Open Sql*plus: Use Sqlplus in command

2) Open and connect to the server: sqlplus [username/password][@ service name] [as role name]

such as: Sqlplus Scott/tiger

Sqlplus Sys/oracle as Sysdba

3) connection command:

Conn[ect] Toggle Connection

Disc[onnect] Disconnect

Passw[ord] Change Password

Exit,quit Exit Sql*plus

4) Edit command: l[ist],/

5) File Manipulation command:

Save file full path name saves the command in the buffer to the specified file

Get file full path name loads the commands in the specified file into the buffer

@ file path name executes SQL in the specified file

Ed file path name edit buffer or specify file

6) View the Help for the Sql*plus command:

Help Index

Help command name

7) Basic command:

Show user view current connected user

Set pagesize value (14) sets the number of rows to display per page

Set linesize value (80) sets the number of characters displayed in a row

SELECT * from tab; View the database objects owned by the current scenario

SELECT * from table name; View all data for a specified table

DESC Table name View table structure

6. Common data types

1) CHAR (length): Fixed length string varchar2 (+) ABC

2) VARCHAR2 (length): variable length string 4,000 bytes

3) number[(total digits, decimal places)]: numbers, integers, and decimals. The default is 38-bit precision number (5,2) 999.99

4) Date: time, seconds value default display format ' Day-X month-yearly '

5) TIMESTAMP: timestamp. Date and time, time zone. Decimal seconds accurate to 9 bits

6) CLOB characters data

BLOB Sophomore binary data

BFILE file pointer

7. SQL: Structured Query language. SQL99, SQL92. Casing is not sensitive. Suggested keywords are capitalized, others are lowercase.

1) Classification:

★A) query statement: SELECT

☆B) DML: Data manipulation language. Defines the statement that modifies the content. INSERT, Delet, UPDATE, TRUNCATE

☆C) DDL: Data definition language. A statement that defines a database object. CREATE, ALTER, DROP, RENAME

d) DCL: Data Control Language. A statement that defines access rights to a user. GRANT, REVOKE

☆E) TCL: Transaction control Language. Defines a transaction control statement. COMMIT, ROLLBACK, savepoint

Oracle Installation and Introduction