Oracle ²éѯÓû§ÃûÓëÃÜÂëÏàͬµÄËã·¨
Óû§ÃûÓë¿ÚÁîÏàͬʹµÃ¿ÚÁîÒ×ÓÚ¼ÇÒäºÍ²Â²â£¬µ«¿ÚÁîÒ²ÈÝÒ×±»ÆÆÒ룬Òò´Ë×÷ΪÊý¾Ý¿â¹ÜÀíÔ±Ó¦¸Ã¼°Ê±¼ì²éÓû§µÄÉèÖ㬱ÜÃâÓû§ÃûÓë¿ÚÁîÏàͬ£¬Ïû³ý²»°²ÒòËØ¡£
´´½¨²éѯ×Ó³ÌÐò£º
SQL> create or replace procedure sys.find_the_same as
hex_password varchar2(30);
trans_password varchar2(30);
v_username varchar2(30);
cursor c1 is select username, password from dba_users;
begin
for i in c1 loop
--±£´æÓû§×î³õµÄ¿ÚÁîºÍÓû§Ãû£¬¿ÚÁîÒÔÊ®Áù½øÖƱíʾ¡£
hex_password:=i.password;
v_username:=i.username;
--½«¿ÚÁî¸Ä³ÉÓû§Ãû£¬ÏµÍ³½«Æä¼ÓÃܺóÒÔÊ®Áù½øÖƱíʾ¡£
execute immediate 'alter user' || v_username || 'identified by' || v_username;
--²éѯÐ޸ĺóµÄÒÔÊ®Áù½øÖƱíʾµÄÓû§¿ÚÁî¡£
select password into trans_password from dba_users where username=v_username;
--±È½ÏÐÞ¸ÄǰºÍÐ޸ĺóµÄ¿ÚÁî¡£
if trans_password=hex_password then
dbms_output.put_line(v_username);
else
--½«¿ÚÁî¸Ä»ØÔÀ´µÄÖµ
execute immediate 'alter user' || v_username || 'identified by values''' || hex_password || '''';
end if;
end loop;
end;
Ïà¹ØÎĵµ£º
http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜĩȫÌì¿ªÆ ......
http://www.ej38.com/showinfo/Oracle-108709.html
Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......
ÎÒÃǵijɹ¦×ÜÊÇÕ¾ÔÚ¾ÞÈ˵ļç°òÉÏÎÒ£¬ÏÈתÁ˱ðÈ˾Ñ飬×îºóÔÙ×ܽá×Ô¼ºµÄʵÑé½á¹û£¬Ñ§Ï°²ÅÄÜÓнø²½£¡
OracleµÄÊ±ÇøÎÊÌâ
Oracle 9i ¿ªÊ¼¶àÁË 3 ¸ö¹ØÓÚʱ¼äµÄÊý¾ÝÀàÐÍ£ºTIMESTAMP [(precision)] TIMESTAMP [(precision)] WITH TIME ZONE TIMESTAMP [(precision)] WITH LOCAL TIME ZONE£¬ÆäÖÐ TIMESTAMP [(precision)] ......
·ÖÇø±íά»¤µÄ³£ÓÃÃüÁ
ALTER TABLE
-- DROP -- PARTITION
-- ADD |
-- RENAME |
-- MODIFITY |
-- TRUNCATE |
-- SPILT |
-- MOVE |
-- EXCHANGE |
·ÖÇøË÷ÒýµÄ³£ÓÃά»¤ÃüÁ
ALTER INDEX
-- DROP -- PARTITION
-- REBUILD |
-- RENAME |
-- MODIFITY |
-- SPILT |
-- PARALLEL
-- UNUSABLE
1¡¢ALTER ......