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

oracle nvl decode

SELECT
DECODE(ÁÐ,0,'Q'1,'P',2,'O')¡¡AS ret
from dual
--·ÖÎö: µ± ÁÐ=0ʱ,½«"Q"¸³Öµ
--µ± ÁÐ =1ʱ,½«"P"¸³Öµ
--µ± ÁÐ=2ʱ,½«"O"¸³Öµ
--NVL()º¯Êý:
--NVL(ARG,VALUE)´ï±êÈç¹ûÇ°ÃæµÄARGֵΪNULLÄÇô·µ»ØµÄֵΪºóÃæµÄVALUE¶þÕß½áºÏʹÓÃ:
DECODE(NVL(±äÁ¿ ''),'','-','OK')
//·ÖÎö:
--Èô ±äÁ¿ ÊÇ·ñΪ¿Õ.ÈôΪ¿Õ¸³¸ø¿ÕÖµ[NVLº¯Êý]
--Æä´Î,ÅжÏÈ¡³öµÄ×Ö¶ÎÊÇ·ñΪ¿Õ,Èç¹ûÊÇÔò¸³¸ø'-'
--ĬÈÏ´¦ÀíÊÇOK¡£ 


Ïà¹ØÎĵµ£º

ORACLEÊý¾Ý¿â±íµÄ²Ù×÷

      ×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
     Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ­½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter   table   Tablename   add(column1&nb ......

OracleÊý¾Ý¿â¡°Ghost¡±

1¡¢Í¨¹ýToad½«Êý¾Ý¿É½á¹¹Éú³ÉSQL£¨×¢ÒâÓû§£©¡£
     [DataBase] [Export] [GenerateSchmaScript]
2¡¢´´½¨DBLink.
     DROP PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM";
     CREATE PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM"
   &nb ......

ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser

ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser
1£¬Í¨¹ýsystem¹ÜÀíÔ±Á¬½Óµ½ÒªÌí¼ÓUSERµÄDB
»òÕßͨ¹ýÒÔÏÂÃüÁ Connect   system/manager@user_datebase   AS   SYSDBA  ;ÒÔSYSµÇ½ȥ´´½¨Óû§
2,´´½¨Óû§²¢·ÖÅäȨÏÞ
drop   user   asset   cascade;  ɾ³ ......

OracleÓαêʹÓÃ×ܽá

Óα꣨CURSOR£©Ò²½Ð¹â±ê£¬ÔÚ¹ØÏµÊý¾Ý¿âÖо­³£Ê¹Óã¬ÔÚPL/SQL³ÌÐòÖпÉÒÔÓÃCURSORÓëSELECTÒ»Æð¶Ô±í»òÕßÊÓͼ
ÖеÄÊý¾Ý½øÐвéѯ²¢ÖðÐжÁÈ¡¡£
         OracleÓαê·ÖΪÏÔʾÓαêºÍÒþʽÓαꡣ
         ÏÔʾÓα꣨Explicit Cursor£©:ÔÚPL/SQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ