Shulou(Shulou.com)06/02 Report--

Due to some trouble installing the oracle database today, I began to consolidate the knowledge of oracle that I learned before because it is not suitable for oracle for a long time.

1. Oracle database: client / database server uses Oracle10g

Oracle10g can not be installed under win7, there is no direct support for win7, you need to download oracle10g that supports vista to modify some configuration files before installing, there is time to introduce.

two。 Installation:

Configuration: Database Configuration Assistant configuration database instance

Net Configuration Assistant configuration database server snooping

Isqlplusctl start starts the service of isqlplus (if you need to use isql*Plus)

Service: OracleService instance name database instance service

Monitoring Service of OracleOraDB10g_home1TNSListener Database Server

3. Common management tools of Oracle:

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 http://ip:5560/isqlplus through the browser

4. Several users in Oracle:

Sys/oracle-- > role sysdba unlocks scott: alter user scott account unlock; alter user scott identified by new password

Scott/tiger-- > Normal ordinary user. There are some sample database tables

5. Common commands of sql*Plus:

1) Open sql*Plus: use sqlplus in the command

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

Such as: sqlplus scott/tiger

Sqlplus sys/oracle as sysdba

3) connection command:

Conn [ect] switch connection

Disc [onnect] disconnect

Passw [ord] change password

Exit,quit exits sql*Plus

4) Editing command: l [ist], /

5) File manipulation commands:

The save file full path name saves the commands in the buffer to the specified file

The full path name of the get file loads the commands from the specified file into the buffer

@ File pathname executes the SQL in the specified file

Ed file pathname edit buffer or specify file

6) View the help of the sql*Plus command:

Help index

Help command name

7) basic commands:

Show user to view current connected users

The set pagesize value (14) sets the number of rows displayed per page

The set linesize value (80) sets the number of characters displayed on a line

Select * from tab; to view the database objects owned by the current solution

Select * from table name; view all data of the specified table

Desc table name view the structure of the table

6. Common data types

1) CHAR (length): fixed length string 2000 varchar2 (30) abc

2) VARCHAR2 (length): variable length string 4000 bytes

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

4) DATE: date and time. Seconds are displayed in the format of 'day-x-month-year' by default

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

6) CLOB large character data

BLOB large binary data

BFILE file pointer

7. SQL: structured query language. SQL99, SQL92 . Case insensitive. It is recommended to use uppercase keywords and lowercase keywords.

1) Classification:

★ a) query statement: SELECT

☆ b) DML: data manipulation language. Define 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 to the user. GRANT 、 REVOKE

☆ e) TCL: transaction control language. Define transaction control statements. COMMIT 、 ROLLBACK 、 SAVEPOINT

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.