´«ÖDz¥¿ÍÎÒµÄOracle¸´Ï°¡®Â·¡¯

 ======================×î½üÔÚ¸´Ï°OracleÕâÊÇ×Ô¼º×ܽáµÄ
=============
======= OracleÖ®ÃÅ  =======
¡¾µÚÒ»²½£ºÊìϤoracle»ù±¾ÃüÁî¡¿
¡¾»ù±¾sqlplusÃüÁî¡¿
Æô¶¯oracle  ==  Æô¶¯oracleservice¡¢Listener·þÎñ
ʧ°ÜÔò²é¿´ÎļþhostÖµ
µÇ½oracle  ==  sqlplus  user/password  [sqlplus  system/feiyue]
³öÏÖSQL> ÔòµÇ½³É¹¦
Çл»Óû§    ==  connect  user/password  [connect scott/tiger]
µ¼Èë½Å±¾    ==  @ ·¾¶   [@ f:\a.txt]
²é¿´µ±Ç°Óû§==  show user
²é¿´±íµÄ½á¹¹==  desc[ribe] table
ÔÚ»º³åÇø±àд==  ed[it]
Ö´ÐÐÉÏÒ»ÌõsqlÓï¾ä  ==  / ·ûºÅ
ÉèÖÃÐÐ¿í    ==  set linesize 120
ÉèÖÃÒ³¸ß    ==  set pagesize 90
´ò¿ªÈÕÖ¾    ==  spool f:\aa.txt
¹Ø±ÕÈÕÖ¾    ==  spool off
ÃüÁî»»ÐÐд  ==  show -            user
±£´æ½Å±¾    ==  save c:\ss.txt
¡¾»ù±¾µÄsqlÓï¾ä==Óû§¹ÜÀí¡¿
´´½¨Óû§    ==  create user scott identified by tiger; 
ɾ³ýÓû§    ==  drop user scott;
ÐÞ¸ÄÓû§    ==  alter user scott identified by test2;
²é¿´Óû§    ==  select user from dual;/select username from dba_users;(ËùÓÐÒѽ¨Óû§)
ÊÚȨ        ==  grant connect,resource to scott;
³·ÏúÊÚȨ    ==  revoke select on dept from www
Ç¿ÆÈÐÞ¸ÄÃÜÂë==  alter user test password expire;
Ëø¶¨Óû§    ==  alter user test account lock;
Óû§½âËø    ==  alter user test account unlock;
¡¾»ù±¾µÄsqlÓï¾ä==±íµÄ¹ÜÀí¡¿
´´½¨test±í  ==  create table test(id number(5),title varchar2(100));
ɾ³ýtest±í  ==  drop table test;
²é¿´test±í  ==  describe test  (·ÇsqlÓï¾ä)
ÐÞ¸Ätest±í  ==  alter table test add(content varchar(10