oracale笔记（oracale笔记）.docVIP

oracale笔记（oracale笔记） Oracle database Sunny Monday, 2012.11.12 Comparison of several databases: [commercial edition] Oracle database: Oracle Corp; large database: can accommodate tens of millions of lines, hundreds of lines of rank, high reliability, good concurrency, good security The product version is: oracle8i/oracle9i/oracle10i/oracle11g, where I and G are represented respectively: i:Internet, Internet (Protocol), g:Grid, grid (Protocol) [commercial edition] MySql database: Sun company, has now been purchased by Oracle company, medium-sized database: can accommodate tens of millions of lines [Free Edition] SQL Sever database: MicroSoft (Microsoft Corp), medium-sized database: can accommodate tens of millions of lines Download URL: Database paradigm: 1NF/2NF/3NF/BCNF The first paradigm (1NF): the fields in the database are not split SQL language: DQL/DDL/DML/DCL DQL:, Data, Query, Language: select * from student [query] DDL:, Data, Define, Language: create, table, student DML:, Data, Management, insert, into, Language: [add] / update, set [modify] / delete from [delete] DCL:, Data, Control, Language: Grant [authorization] select to Scott / revoke [revoke permissions] select, from, Scott Summed up as: increase, delete, change, check Change the table name: alter table, the original table name, rename, to, new table name Modify fields: alter, table, table name, rename, column, original field, to, new field Add fields: alter, table, table name, add, new field, field type DBA is the abbreviation of Database Administrator Common database and default password (if new password is specified when installed, as specified): Sys - change_on_install System / Manager Scott / Tiger Execute (CMD) command operations: Sys user login: sqlplus sys/ password as SYSDBA In the switch user, simply login sys (password can also save):conn/as SYSDBA Display user: show user See what tables are: select * from tab; Lock Scott users: alter, user, Scott, account, lock; Unlock for Scott users: