ora 10g Web¿ØÖÆ̨Éí·ÝÑéÖ¤²»Í¨¹ý¡£Ö®Ç°ÎÒ×°ÁË10g £¬Web¿ØÖÆֻ̨ҪÊý¾Ý¿âÉí·ÝÑéÖ¤£¬ÎÒÓÃSYS¾ÍÄܵǽ£¬¿ÉÊÇÖØ×öÁËÒ»´Îϵͳºó£¬ÔÙ×°10g£¬Web¿ØÖÆ̨¾ÓÈ»³ýÁËÊý¾Ý¿âÉí·ÝÑéÖ¤Í⻹Ҫ²Ù×÷ϵͳÉí·ÝÑéÖ¤¡£ÎÒÔõôÊÔ¶¼ËµÃÜÂë²»¶Ô¡£¡£¡£¡£ÕâÔõô°ì°¡£¿:rolleyes: :rolleyes:
by jandz0413 - ¹¥·À½»Á÷Çø - 2008-05-07 21:30:35 ÔĶÁ£¨4237£© »Ø¸´£¨1£©
select f04,to_number(f06) from tmp_1207_11 minus select f05,f07 from tmp_1207_12 ÆäÖÐf04£¬f05,f06 ¶¼ÊÇVARCHAR2ÀàÐÍ£¬f07 ÊÇNUMBER£¬ Ö´Ðк󱨡°ora-01722 ÎÞЧÊý×Ö¡± Õâ¸ö´í¡£
[code]select '/' || nvl(11.name, '') || '/' || nvl(12.name, '') || '/' || nvl(13.name, '') || '/' || nvl(14.name, '') from direct 11, direct 12, direct 13, direct 14 where 11.id = 12.parentid(+) and 12.id = 13.parentid(+) and 13.id = 14.parentid(+) and 11.id = 1 order by 11.name, 12.name, 13.name, 14.name[/code]´ó¼Ò°ïæ¿´¿´Õâ¸ösql
Create table TMP_FF_D_B_0701A8C0( ´úºÅ char(6) NOT NULL , ÔÂ·Ý decimal(5) , ÆÚÊý decimal(5) , ×Ü·ÖÊý decimal(5) , Êб± char(8 ) , ¸¡É½ºó char(8 ) , Æ붫· char(8 ) , Ųׯ char(8 ) , ¶«²¿ char(8 ) , ̨¶« char(8 ) , ËÄ·½ char(8 ) , ´í²ºÁë char(8 ) , ²×¿Ú decimal(5) , ÂåÑô· char(8 ) , ¦ɽºó decimal(5) , ÂóµºÍ¶µÝÊÒ decimal(11) , Èð²ý· decimal(11) , Ë®Çå¹µ char(5)...
´¥·¢Æ÷/º¯Êý²»ÄܶÁ´¦Àí°ì·¨Çó¾È£¡£Ï£Ò£Á££°£´£°£¹£±£Å£Ò£Ò£Ï£Ò create or replace trigger "TJTD".·ÑÓÃ_¾ÓÃñ·ÑÓÃ_¸üÐÂ_´¥ before update of Ó¦ÊÕ, ÕÛ¿Û, ºË¼õ, ½»·Ñ×ܶî on ·ÑÓÃ_¾ÓÃñ·ÑÓÃ_±í for each row declare qfze NUMBER; YJZE NUMBER; begin --1 µ÷ÕûÇ··Ñ :new.Ç··Ñ×ܶî:=round(:new.Ó¦ÊÕ-nvl(:new.ÕÛ¿Û,0)-nvl(:new.ºË¼õ,0)-nvl(:new.½»·Ñ×ܶî,0),1); --update ¾ÓÃñ·ÑÓúϼÆ_ͼ set Ç··Ñ×ܶî=nvl(:new.Ç··Ñ×ܶî,0) w...
½ñÌìϵͳµÄÒ»Õű¨±íͻȻ±¨´í¡£¾¼ì²éÊÇÒ»ÌõSQLÒý·¢µÄ£º[code]select count(*) from ÊÓͼijij[/code]¾ÓÈ»countÒ»¸öÊÓͼ¼Ç¼Êý±¨´í£¬ÇëÎÊÄÄλ֪µÀÊÇʲôÔÒò¡£Ê¹ÓõÄÊý¾Ý¿âÊÇoracle 10.2.0.4
RMANÔÚͨ¹ýNFS±¸·Ý¡¢»Ö¸´µÄʱºò£¬»á³öÏÖora-27054´íÎó¡£
linkºóÊÇÅäÖõĿªÊ¼¡£ ÇëÎÊÔõôÖØпªÊ¼Õâ¸öÅäÖã¿ ËùνµÄÒì³£µÄ ÎÒûÓп´Çå³þ ºÃÏñÊÇʲô lookup lock ʲôµÄ ÈÃÎÒÖØеǽ¡£ ÖØеǽºó£¬ÔËÐÐÁËroot.sh¾Í²»ÖªµÀÔõô¼ÌÐøÊý¾Ý¿âµÄÅäÖÃÁË ÔÚÏߵȴý¡£ лл
linkºóÊÇÅäÖõĿªÊ¼¡£ ÇëÎÊÔõôÖØпªÊ¼Õâ¸öÅäÖã¿ ËùνµÄÒì³£µÄ ÎÒûÓп´Çå³þ ºÃÏñÊÇʲô lookup lock ʲôµÄ ÈÃÎÒÖØеǽ¡£ ÖØеǽºó£¬ÔËÐÐÁËroot.sh¾Í²»ÖªµÀÔõô¼ÌÐøÊý¾Ý¿âµÄÅäÖÃÁË ÔÚÏߵȴý¡£ лл
linkºóÊÇÅäÖõĿªÊ¼¡£ ÇëÎÊÔõôÖØпªÊ¼Õâ¸öÅäÖã¿ ÔÚÏߵȴý¡£ лл£¡
ÓÃÒ»¸ö¿Í»§¶ËÁ¬½ÓoracleÊý¾Ý¿â£¬±©´í£ºora-12705 Ö¸¶¨ÁËÎÞЧµÄ»òδ֪µÄnls ²ÎÊýÖµ£¬ÇëÎÊÈçºÎ½â¾ö£¿µÈ´ý¸ßÊÖÖ¸½Ì£¡