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

Oracle DECODE

Óï·¨£º
DECODE(expr, search, result [, search, result ]... [, default ] )
Ó¦Óãº
DECODEº¯Êý½«Ã¿Ò»¸öexprºÍsearchµÄÖµ×ö±È½Ï¡£Èç¹ûexprµÄÖµÓësearchµÄÖµÏàµÈ£¬OracleÊý¾Ý¿â¾Í»á·µ»ØÏàÓ¦µÄresult¡£Èç¹ûÕÒ²»µ½Æ¥ÅäµÄÖµ£¬Oracle·µ»Ødefault¡£Èç¹ûûÓÐdefault£¬Oracle·µ»ØnullÖµ¡£²ÎÊý¿ÉÒÔÊÇÈÎÒâÊýÖµÀàÐÍ£¨NUMBER£¬BINARY_FLOAT, or BINARY_DOUBLE£©ºÍ×Ö·ûÐÍ¡£   1¡¢Èç¹ûexprºÍsearchÊÇ×Ö·ûÐÍ£¬Oracleͨ¹ý·ÇÌî³äµÄ±È½ÏÓïÒåÀ´±È½ÏËüÃÇ¡£expr£¬searchºÍresult¿ÉÒÔÊÇCHAR, VARCHAR2, NCHAR, or NVARCHAR2ÖÐÈÎÒâÀàÐ͵ÄÊý¾ÝÀàÐÍ¡£×Ö·û´®·µ»ØµÄÊÇVARCHAR2ÐÍÊý¾ÝÀàÐÍ£¬ËüºÍµÚÒ»¸öresult²ÎÊý´¦ÓÚͬһ¸ö×Ö·û¼¯¡£   2¡¢Èç¹ûµÚÒ»¸ösearch-result¶ÔÊÇÊýÖµÐ͵ģ¬Oracle»á±È¶ÔËùÓеÄsearch-result±í´ïʽÒÔ¼°exprÀ´¾ö¶¨¾ßÓÐ×î¸ßÓÅÏȼ¶µÄ²ÎÊýÊýÖµ£¬²¢Òþʽת»»ÆäÓà²ÎÊýµÄÊý¾ÝÀàÐÍÒÔ¼°·µ»ØÖµµÄÊý¾ÝÀàÐÍ¡£search¡¢resultºÍdefaultµÄÖµ¿ÉÒÔÓɱí´ïʽÔËËãµÃÀ´¡£OracleÊý¾Ý¿âʹÓõÄÊǶÌ·ÆÀ¼Û¡£Ò²¾ÍÊÇ˵£¬Êý¾Ý¿âÖ»ÔÚ½«Ã¿¸ösearchÖµºÍexprÖµ¶Ô±È֮ǰ²ÅÆÀ¼ÛsearchµÄÖµ£¬¶ø²»ÊÇÔÚÓëexpr¶Ô±È֮ǰÆÀ¼ÛËùÓеÄsearchÖµ¡£OracleÔڱȶÔ֮ǰ×Ô¶¯½«exprºÍÿ¸ösearchµÄֵת»»³ÉµÚÒ»¸ösearchÖµµÄÊý¾ÝÀàÐÍ£¬²¢×Ô¶¯½«·µ»Øֵת»»³ÉÓëµÚÒ»¸öresultÏàͬµÄÊý¾ÝÀàÐÍ¡£Èç¹ûµÚÒ»¸öresultÓÐCHARÊý¾ÝÀàÐÍ»òÕßΪNULL£¬Oracle»á½«·µ»Øֵת»»³ÉVARCHAR2ÀàÐÍ¡£ÔÚDECODEº¯ÊýÀOracle½«Á½¸önullÖµÈÏΪÊÇÏàµÈµÄ¡£Èç¹ûexprºÍµÚÒ»¸ösearchͬʱΪ¿Õ£¬ÄÇOracle»á·µ»ØËùÓÐËùÓеÄresult¡£ DECODEËùÄÜÈÝÄɵÄ×î´ó²ÎÊýÊýÄ¿ÊÇ255¸ö£¬ÕâÆäÖаüÀ¨expr£¬search£¬resultÒÔ¼°default¡£Àý×Ó£ºÀý×Ó½âÂëwarehouse_idµÄÖµ£¬Èç¹ûwarehouse_idΪ1£¬·µ»ØSouthlake£¬Îª2·µ»ØSan FranciscoµÈµÈ¡£Èç¹ûwarehouse_id²»ÊÇ1,2,3,4ÖеÄÈÎÒâÒ»¸ö£¬º¯Êý·µ»ØNon domestic¡£SELECT product_id,
       DECODE (warehouse_id, 1, 'Southlake',
                             2, 'San Francisco',
                             3, 'New Jersey',
    &n


Ïà¹ØÎĵµ£º

oracleÎóÓòÙ×÷ϵͳÃüÁîɾ³ýÊý¾ÝÎļþµÄ»Ö¸´·½·¨

ʹÊÔ­Òò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename É¾³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......

¹ØÓÚOracleÔÚAIXƽ̨ʵʩµÄ ÅàѵÄÚÈÝ°²ÅÅ

¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38    ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈÝ°²ÅÅ   Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵ ......

Oracle ¿ØÖÆÎļþ


Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......

ORACLE DSI ½éÉÜ

DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔ­ÒòÁ÷Âä½­ºþ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ