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