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

ORACLE ͳ¼ÆÕý¸º¸öÊýsql

select ss.*,
       sum(ss.aa) over (partition by ss.zsid order by ss.zsid) as fu,
       sum(ss.bb) over (partition by ss.zsid order by ss.zsid) as zheng
from
(
select m.zsid,
       sum(n.f0004_028n) over(partition by m.zsid) n011,
       sum(n.f0004_029n) over(partition by m.zsid) n012,
       sum(n.f0004_030n) over(partition by m.zsid) n013,
       sum(n.f0004_031n) over(partition by m.zsid) n014,
       sum(n.f0004_032n) over(partition by m.zsid) n015,
       sum(n.f0004_033n) over(partition by m.zsid) n021,
       sum(n.f0004_034n) over(partition by m.zsid) n022,
       sum(n.f0004_035n) over(partition by m.zsid) n023,
       n.f0004_017n,
       (case when n.f0004_017n>0 then 1  when n.f0004_017n<=0 then 0 end)  aa,
       (case when n.f0004_017n<=0 then 1  when n.f0004_017n>0 then 0 end)  bb
  from (select a.f0055_001n zsid,
               a.f0055_004v zsbm,
               b.f0056_003v code,
               b.f0056_004v zsjycs, --Ö¸Êý½»Ò׳¡Ëù
               b.f0056_005v zszqlb, --Ö¸Êý֤ȯÀà±ð
               c.f0005_005v codezqlb, --³É·Ý¹É֤ȯÀà±ð
               c.f0005_007v codejycs --³É·Ý¹É½»Ò׳¡Ëù
 


Ïà¹ØÎĵµ£º

oracleÈ¡×Ö·û´®³¤¶ÈµÄº¯Êýlength()ºÍhengthb()


lengthb(string)¼ÆËãstringËùÕ¼µÄ×Ö½Ú³¤¶È :·µ»Ø×Ö·û´®µÄ³¤¶È£¬µ¥Î»ÊÇ×Ö½Ú
length(string)¼ÆËãstringËùÕ¼µÄ×Ö·û³¤¶È :·µ»Ø×Ö·û´®µÄ³¤¶È£¬µ¥Î»ÊÇ×Ö·û
¶ÔÓÚµ¥×Ö½Ú×Ö·û,LENGTHBºÍLENGTHÊÇÒ»ÑùµÄ.
Èç¿ÉÒÔÓÃlength(‘string’)=lengthb(‘string’)ÅжÏ×Ö·û´®ÊÇ·ñº¬ÓÐÖÐÎÄ¡£
select   lengt ......

Oracle 10g ÌØÐÔ: ͨ¹ý±¸·ÝʵÏÖ¿É´«Êä±í¿Õ¼ä

Oracle 10g ÌØÐÔ: ͨ¹ý±¸·ÝʵÏÖ¿É´«Êä±í¿Õ¼ä
Oracle8i ÖÐÒýÈëµÄ¿É´«Êä±í¿Õ¼äΪʵÏÖ¸ü¿ìµÄ¿çÊý¾Ý¿âÊý¾Ý´«ÊäÌṩÁËÆÈÇÐÐèÒªµÄÖ§³Ö¡£Ê¹ÓôËÌØÐÔ£¬Äú¿ÉÒÔÖ»µ¼³ö±í¿Õ¼äµÄÔªÊý¾Ý¡¢´«ÊäÊý¾ÝÎļþ²¢½«×ª´¢Îļþµ¼³öµ½Ä¿±êÊý¾Ý¿âÖ÷»úÒÔ¼°µ¼ÈëÔªÊý¾ÝÒÔ½«±í¿Õ¼ä“²åÈ딵½Ä¿±êÊý¾Ý¿âÖС£¸Ã±í¿Õ¼äÖеÄÊý¾ÝÔÚÄ¿±êÊý¾Ý¿âÖÐËæ¼´¿É ......

OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾

http://hi.baidu.com/james_yulei/blog/item/7cc8c834063d6f3a0b55a920.html
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
2009-12-21 18:04
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
²Ù×÷ϵͳ£ºLinux
Êý¾Ý¿â£ºoracle9.2.0.4
1¡¢Êý¾Ý¿âÉèÖÃΪ¹éµµ·½Ê½
2¡¢Êý¾Ý¿âµÄ±¸·Ý½Å±¾
db_full_backup.sh £ºÊý¾Ý¿âÈ«±¸½Å±¾
db_l0_backup.sh £ºÊý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ