oracleÓû§½âËø
OracleÓû§½âËø
¡¡¡¡Ã¿µ±ÎÒÃÇа²×°ÁËoracleºó,µÚÒ»´ÎÔËÐж¼»á³öÏÖÒ»¸öÓû§±»ËøµÄ´íÎóÌáʾ,´ËʱÐèÒªÎÒÃÇÊÖ¶¯½øÐÐÓû§½âËø,ÏÂÃæÒÔ½âËøscottÓû§ÎªÀý: Ê×ÏÈÔÚÃüÁîÐд°¿ÚÖÐÊäÈë sqlplus sys/sys as sysdba ÕâÀïµÄsysÊÇϵͳÕ˺Å,oracle×Ô´øµÄ,ºóÃæµÄsysÊÇÃÜÂë,Õâ¸öÃÜÂëÔÚÄ㰲װʱÉèÖúõÄ. as sysdba Òâ˼¾ÍÊÇÒÔÕâ¸öÓû§×öΪÊý¾Ý¿â¹ÜÀíÔ±µÇ¼ ÔÙ½ÓÏÂÀ´µÄÌáʾµ±ÖÐÊäÈë alter user scott account unlock; ÕâÑù¾Í¿ÉÒÔ½«Óû§ scott½âËø!
Oracle¶ÔÓû§²Ù×÷Óï·¨
¶ÔÓû§½âËø:alter user username account unlock;
½âËøºó¿ÉÒÔ¶ÔÆäÃÜÂë½øÐÐÐÞ¸Ä:
alter user username identified by newPassword;
´´½¨Óû§:
CREATE USER username IDENTIFIED BY password;
¸øÓû§ÊÚȨ:
GRANT CREATE SESSION TO username;(²Å¿ÉµÇ¼)
GRANT CONNENT,RESOURCE TO username;(½øÐд´½¨±íÖ®ÀàµÄ²Ù×÷)
»ØÊÕÓû§ÊÚȨ:
REVOKE ȨÏÞ ON Óû§±íÃû³Æ from Óû§;
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
¹Ø¼ü´Ê£ºwith read only
×÷ÓãºÓÃÓÚÖ¸¶¨Ëù´´½¨µÄÊÔͼ²»¿ÉÒÔͨ¹ý±¾ÊÓͼ¸üбí
Ö´ÐÐÒ»ÏÂSQL£¬´´½¨±íT£¬ºÍÁ½¸öÊÔͼV1£¬V2£º
CREATE TABLE T(ID INTEGER);
CREATE VIEW V1 AS SELECT * from T;
CREATE VIEW V2 AS SELECT * from T WITH READ ONLY;
Ö´ÐÐSQL:
INSERT INTO V1 VALUES(1);
--------------------
1 row cre ......
ORACLEµÄlpadº¯Êý¡¢rpadº¯ÊýÓ÷¨
Óï·¨£ºselect lpad('12345678',1,'0') from dual;
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬×ó±ß²¹‘0’
Óï·¨£ºselect rpad('12345678',1,'0') from dual;
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬Óұ߲¹&ls ......
¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order by salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition by deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......
Oracle ×ÜÕÊÄ£¿éµÄÒ»¸ö»á¼ÆÒµÎñÖÜÆÚÈçÏÂ:
1.´ò¿ª×ÜÕÊ»á¼ÆÆÚ
2.¼ÈëÊÖ¹¤Æ¾Ö¤,°üÀ¨:· ÊÖ¹¤±ê׼ƾ֤
  ......