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
Ïà¹ØÎĵµ£º
ʹÊÔÒò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename ɾ³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......
Ò»¡¢$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/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38 ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈÝ°²ÅÅ Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵ ......
Ò». 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 ......
DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔÒòÁ÷Â佺þ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......