Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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;


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle 10gÈçºÎ¹Ø±ÕºÍ´ò¿ª×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢

http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
 Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜĩȫÌì¿ªÆ ......

DB2 תOracle

 DB2 תOracle
ijÌìÊÇÐÇÆÚ¼¸µÄº¯Êý
DB2:
select a.yyxe,a.zblb,a.ysdm,a.daynum,b.zjxm  from zy_yspb a ,zy_zjlb b where a.ysdm=b.id and  a.ksdm=10000 order by abs( a.daynum -DAYOFWEEK(current   date)+1) desc,a.daynum,a.zblb
sql.executeQuery:ORA-00936: ȱʧ±í´ïʽ
Oracle :
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ