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

oracleÖеIJ»¿É¼û×Ö·û

½ñÌì×öͳ¼ÆµÄʱºò·¢ÏÖÒ»¸öÊý¾Ý±íÃæÉÏ¿´À´ÊÇ‘920 ’µ«È¥¿Õ¸ñÎÞÂÒÈçºÎ¶¼È¥²»µô£¬×îºó·¢ÏÖÊDz»¿É¼û×Ö·û¡£¡£¡£
ÓÚÊÇÔÚÍøÉÏËѵ½Ò»ÆªÎÄÕ£¬ÈçºÎÀ´ÅжÏÕâ¸ö²»¿É¼û×Ö·ûµÄÎÊÌâ~
°´ÏÂÃæµÄ·½·¨Åжϳö²»¿É¼û×Ö·ûµÄascIIÂëÊÇ10£¬ÓÚÊÇÓÃrtrim('Ô­×Ö·û','chr(10)')À´È¥µôÕâ¸ö²»¿É¼û×Ö·û¡£
½ñÌìÓöµ½Ò»Ôò°¸Àý£¬ÎÊÌâÊÇÊý¾Ý¿âÖп´À´ÍêÈ«ÏàͬµÄ×Ö¶ÎÈ´´æÔÚ³¤¶È²îÒì¡£
¡¡¡¡Í¨¹ýlengthbÒÔ¼°dump£¬ÎÒÃÇ¿ÉÒÔÖªµÀÎÊÌâËùÔÚ£º
      SQL> select trim(log.sname),dump(log.sname),lengthb(log.sname) 
¡¡¡¡2 from st.LIMPORT_LOG log 
¡¡¡¡3 where log.dfee > date '2008-06-22' 
¡¡¡¡4 and log.dfee < date '2008-06-23' 
¡¡¡¡5 and log.sspname like '263%' 
¡¡¡¡6 group by log.sname,dump(log.sname); 
¡¡¡¡TRIM(LOG.SNAME) DUMP(LOG.SNAME) LENGTHB(LOG.SNAME) 
¡¡¡¡------------------- ----------- ---------------------------------------------- 
¡¡¡¡263ÍøÂçͨÐÅ Typ=1 Len=15: 50,54,51,205,248,194,231,205,168,208,197,0,0,0,0 15 
¡¡¡¡263ÍøÂçͨÐÅ Typ=1 Len=11: 50,54,51,205,248,194,231,205,168,208,197 11
¡¡¡¡Ê¹ÓÃDUMPº¯ÊýÎÒÃÇ·¢ÏÖ£¬ÔÚÓÐÎÊÌâµÄÊý¾ÝÖУ¬Êý¾Ýĩβ´æÔÚ¼¸¸ö×Ö·û0,0,0,0£¬Ò²¾ÍÊǶà³öÁ˼¸¸ö×Ö·û¡£
¡¡¡¡ÕýÊÇÕâ¶à³öµÄ¼¸¸ö×Ö·ûµ¼ÖÂÁË´æ´¢Òì³£¡£
¡¡¡¡ÄÇôÕâ¸ö0´ú±íʲô×Ö·ûÄØ?ÔÚASCII±àÂë±íÀïÎÒÃÇ¿ÉÒÔ¿´µ½Õâ¶ÔÓ¦ÁËÒ»¸ö²»¿É¼û×Ö·û£¬ÕâÊÇÊý¾ÝÈë¿âʱµÄÒì³£µ¼Öµģº
¡¡¡¡-The End-


Ïà¹ØÎĵµ£º

oracleµÄ±íµÄÖÖÀà

±íÀàÐÍ£º
1¶Ñ×éÖ¯±í£¨heap organized table£©£ºÕâЩ¾ÍÊÇ“ÆÕͨ”µÄ±ê×¼Êý¾Ý¿â±í¡£Êý¾ÝÒԶѵķ½Ê½¹ÜÀí¡£¶Ñ£¨heap£©ÊÇÒ»×é¿Õ¼ä£¬ÒÔÒ»ÖÖÓÐЩËæ»úµÄ·½Ê½Ê¹Óá£
2Ë÷Òý×éÖ¯±í£¨index organized table£©£ºÕâЩ±í°´Ë÷Òý½á¹¹´æ´¢¡£Õâ¾ÍÇ¿ÖÆÒªÇóÐб¾ÉíÓÐijÖÖÎïÀí˳Ðò¡£Ë÷Òý×éÖ¯±íIOTÖУ¬Êý¾ÝÒª¸ù¾ÝÖ÷¼üÓÐÐòµØ´æ´¢¡£
3Ë÷Ò ......

oracle Óαê

oracle Óαê
¹Ø¼ü×Ö: oracle Óαê
1.       Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2.       ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐÇ°½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡ ......

ORACLE ALERT

Oracle EBS AlertÔÚOracle EBSÖÐÓ¦Ó÷dz£¹ã·º,Ö÷Òª¼¯ÖÐÔÚ¶¨ÆÚ֪ͨºÍÌáÐÑ,ʼþÀàµÄ֪ͨºÍÌáÐÑ,ÀýÈç:
1)ij¸öÖ°Ô±¹ýÉúÈÕ,µ«ÊÇÈËÁ¦×ÊÔ´²¿ÃÅÏ£Íû·¢¸ö×£ºØµÄÓʼþ,¾Í¿ÉÒÔͨ¹ýAlert½øÐÐ֪ͨףºØ;
2)ÔÚDBA¼ì²âϵͳÊÇ·ñÕý³£ÔËתµÄ¹ý³ÌÖÐ,Èç¹ûij¸ö±í¿Õ¼ä¿ìÂúÁË,¿ÉÒÔ½¨Á¢Alert½øÐÐ֪ͨ¹ÜÀíÔ±;
3)¿ÉÒÔ½øÐÐÌáÐÑEBSÖеÄËùÓÐÈËÔ±,µ±È»Ò²¿ ......

oracle cast() º¯ÊýÎÊÌâ

¹Ø¼ü×Ö: oracle cast() º¯ÊýÎÊÌâ
SQL> create table t1(a varchar(10));
Table created.
SQL> insert into t1 values ('12.3456');
1 row created.
SQL> select round(a) from t1;
  ROUND(A)
----------
        12
SQL> select round(a,3) from t1;
ROUN ......

¡¾×ª¡¿ OracleÈ«¾ÖË÷ÒýºÍ±¾µØË÷Òý

OracleË÷Òý·ÖÇøÔÓ̸
<> OracleÊý¾Ý¿âÖУ¬ÓÐÁ½ÖÖÀàÐ͵ķÖÇøË÷Òý£¬È«¾ÖË÷ÒýºÍ±¾µØË÷Òý£¬ÆäÖб¾µØË÷ÒýÓÖ¿ÉÒÔ·ÖΪ±¾µØǰ׺Ë÷ÒýºÍ±¾µØ·Çǰ׺Ë÷Òý¡£ÏÂÃæ¾Í·Ö±ð¿´¿´Ã¿ÖÖÀàÐ͵ÄË÷Òý¸÷×ÔµÄÌص㡣
È«¾ÖË÷ÒýÒÔÕû¸ö±íµÄÊý¾ÝΪ¶ÔÏó½¨Á¢Ë÷Òý£¬Ë÷Òý·ÖÇøÖеÄË÷ÒýÌõÄ¿¼È¿ÉÄÜÊÇ»ùÓÚÏàͬµÄ¼üÖµµ«ÊÇÀ´×Ô²»Í¬µÄ·ÖÇø£¬Ò²¿ÉÄÜÊǶà¸ö²»Í¬¼üÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ