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

¹ØÓÚoracleÖÐʹÓÃnvlº¯Êýʱ£¬¶Ô¿Õ×Ö·û´®µÄÀí½â

 ×òÌìϰà֮ǰÔÚ³ÌÐòÖÐÓöµ½ÁËÒ»¸öʹÓÃnvlµÄsqlÓï¾ä£¬ÏàÐÅÕâ¸öº¯Êý´ó¼Ò¶¼Ó¦¸ÃʹÓùý£¬²¢ÇÒÓ¦¸ÃÊǺܼòµ¥µÄ¡£
ÒòΪ֮ǰ×öµÄÊý¾Ý¿âÒÆÖ²Ê±Óöµ½¹ýÕâ¸öÎÊÌ⣬ËùÒÔ½ñÌìÄÃÀ´ÔÚÕâÀï¼ÇÔØÒ»Ï¡£
ÆäÖÐÓÐÒ»¶ÎwhereÌõ¼þÊÇÕâÑùµÄ£º
and ((nvl('', ' ') <> ' ' and a.benifitvchno like '%%') or
       (nvl('', ' ') = ' ' and a.benifitvchno like '%'))
ÒÔÉÏÊÇÔÚplsqlÖдò³öµÄ£¬»ù±¾ÉϵÄÒâ˼¾ÍÊÇÈç¹ûa.benifitvchnoÊÇ¿ÕÖµµÄ»°£¬ÏÂÃæµÄÌõ¼þ»á³ÉÁ¢£¬
Èç¹ûÓÐÖµµÄ»°ÉÏÃæµÄÓï¾ä»á³ÉÁ¢¡£Êµ¼ÊÉÏÔÚnvlºóÃæµÄ‘’ÖÐÓ¦¸ÃÊÇÄǸöa.benifitvchnoµÄÖµ£¬ÒòΪÔÚÕâÀïÊǿգ¬ËùÒÔÏÔʾΪ‘’¡£
ÕâÀïÒª×ÅÖØËµÃ÷µÄÊÇoracle¶ÔÓÚ‘’µÄ´¦ÀíĬÈÏÊÇnullµÄ£¬¶ø‘ ’²ÅÊÇ¿Õ×Ö·û´®£¬£¨Ç°ÃæÊÇ‘’£¬ºóÃæÊÇ‘ ’£¬ÕâÀïÇø±ðÊǺóÕßÖмäÓпոñ£©£¬ËùÒÔ¾ÍÊÇÕâÀïÊÇÓÐÇø±ðµÄ£¬Òò´ËÈç¹û½«ÉÏÃæÓï¾äдΪ¶¼ÊÇûÓпոñµÄ‘’£¬½á¹û¿Ï¶¨ÊDz»¶ÔµÄ¡£
²¹³ä£º½ñÌìÔÚcsdnÉÏÎÊÁËÏ£¬
       ¿ÉÒÔʹÓÃÒÔÏÂÓï¾äʵÑ飺
      (1)
select

1

from
dual
where
nvl(
''
,
''
)
=

''
        (2)select
1 from
dual where
nvl('', '') is null
      ÒÔÉÏÁ½¾äÖеÚÒ»¾ä²»»áÓÐÖµ£¬µÚ¶þ¾ä²Å»áÓÐÖµ¡£
      ÕýÏñ
wh62592855
ÅóÓÑ˵µÄ£ºnull=null£¬·µ»ØÓ¦¸ÃÊÇFALSE¡£Ö»Òª¼ÇסNULL²»µÈÓÚÈκÎÖµ¾ÍÊÇÁË£¬Ò²²»µÈÓÚNULL¡£
ÌØ´Ë·Ç³£¸Ðл
wildwave£¬
wh62592855
Á½Î»ÅóÓѵĽâ´ð¡£
                        


Ïà¹ØÎĵµ£º

oracleµÄnvlº¯ÊýµÄÓ÷¨

oracleµÄnvlº¯ÊýµÄÓ÷¨ ͨ¹ý²éѯ»ñµÃij¸ö×ֶεĺϼÆÖµ£¬Èç¹ûÕâ¸öֵλnull½«¸ø³öÒ»¸öÔ¤ÉèµÄĬÈÏÖµ
select nvl(sum(t.dwxhl),1) from tb_jhde t where zydm=-1ÕâÀï¹ØÐĵÄnvlµÄÓ÷¨£¬nvl£¨arg,value£©´ú±íÈç¹ûÇ°ÃæµÄargµÄֵΪnullÄÇô·µ»ØµÄֵΪºóÃæµÄvalue
Èç: NVL(a,b)¾ÍÊÇÅжÏaÊÇ·ñÊÇNULL,Èç¹û²»ÊÇ·µ»ØaµÄÖµ£¬Èç¹ ......

ÅäÖÃweblogicÁ¬½ÓoracleµÄÊý¾ÝÔ´

 Name:JDBC-DEV1
JNDI Name:jdbc.datasource.DS1  
AdminServer
Row Prefetch Size:  48
Stream Chunk Size:256
URL:jdbc:oracle:thin:@192.168.0.118:1521:AAT
Driver Class Name:oracle.jdbc.OracleDriver
Á¬½Óoracle¼°postgresqlµÄÁ¬½Ó×Ö·û´®
package com.lwf.eus.util;
import java.sql.Conn ......

ORACLE to_char(),to_date()Ó÷¨

to_date() function
1.ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷ 
D Ò»ÖÜÖеÄÐÇÆÚ¼¸ 
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û 
DD ÔÂÖеĵڼ¸Ìì 
DDD ÄêÖеĵڼ¸Ìì 
DY ÌìµÄ¼òдÃû 
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ 
IYYY ISO±ê×¼µÄËÄλÄê·Ý 
YYYY ËÄλÄê·Ý 
YYY,YY,Y Äê·ÝµÄ×îºóÈýÎ ......

ORACLE °ó¶¨±äÁ¿Ó÷¨×ܽá

֮ǰ¶ÔORACLEÖеıäÁ¿Ò»Ö±Ã»¸öÌ«Çå³þµÄÈÏʶ£¬±ÈÈç˵ʹÓ㺡¢&¡¢&&¡¢DEIFINE¡¢VARIABLE……µÈµÈ¡£½ñÌìÕýºÃÏÐÏÂÀ´£¬ÉÏÍøËÑÁËËÑÏà¹ØµÄÎÄÕ£¬»ã×ÜÁËһϣ¬ÌùÔÚÕâÀ·½±ãѧϰ¡£
==================================================================================
 ÔÚoracle ÖУ¬¶ÔÓÚÒ»¸öÌá½ ......

Oracle SQL¾«ÃîSQLÓï¾ä½²½â


--ÐÐÁÐת»» ÐÐתÁÐ
DROP TABLE t_change_lc;
CREATE TABLE t_change_lc (card_code VARCHAR2(3), q NUMBER, bal NUMBER);
INSERT INTO t_change_lc
SELECT '001' card_code, ROWNUM q, trunc(dbms_random.VALUE * 100) bal from dual CONNECT BY ROWNUM <= 4
UNION
SELECT '002' card_code, ROWNUM q, trunc(d ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ