OracleÖÐͳ¼ÆÆõºÏijÁÐÌõ¼þµÄÁÐ×ܺÍ
×î½üÔÚÏîÄ¿±¨±íÖÐÐèÒªÒ»¸ö²éѯÓï¾ä£¬ÓÃÀ´Í³¼Æ·ûºÏijһÁÐÌõ¼þµÄÆäËü¼¸ÁеĸöÊý
±ÈÈçÓÐÏÂÃæÒ»¸ö±í½á¹¹£º
ÐèÒªÔÚÁÐDºóÃæÔö¼ÓÒ»ÁУ¬Í³¼ÆÔÚÁÐA²»Îª¿Õ£¬²¢ÇÒÁÐB¡¢C¡¢D²»Îª¿ÕµÄ¸öÊý
¾¹ý×Ô¼ºÊÔÑ飬²éÕÒ°ïÖú£¬×ÜËãʵÏÖÁËÉÏÃæµÄ²éѯ¡£
Ê×ÏȽ²¼¸¸öº¯ÊýµÄÓ÷¨£º
NULL£ºÖ¸µÄÊÇ¿ÕÖµ£¬»òÕß·Ç·¨Öµ¡£
NVL (expr1, expr2)
²ÎÊý˵Ã÷£ºÈç¹ûexpr1ΪNULL£¬·µ»Øexpr2£»²»ÎªNULL£¬·µ»Øexpr1¡£×¢ÒâÁ½ÕßµÄÀàÐÍÒªÒ»ÖÂ
NVL2 (expr1, expr2, expr3)
²ÎÊý˵Ã÷£ºÈç¹ûexpr1²»ÎªNULL£¬·µ»Øexpr2£»ÎªNULL£¬·µ»Øexpr3¡£expr2ºÍexpr3ÀàÐͲ»Í¬µÄ»°£¬expr3»áת»»Îªexpr2µÄÀàÐÍ
NULLIF (expr1, expr2)
²ÎÊý˵Ã÷£ºÈç¹ûÏàµÈ·µ»ØNULL£¬²»µÈ·µ»Øexpr1
ÏÂÃæÊDZ¾ÈËͨ¹ýÁ½ÖÖ·½·¨ÊµÏֵĽá¹û
·½·¨Ò»£º
´úÂë
1 Select a,
2 b,
3 c,
4 d,
5 Case
6 When a Is Not Null Then
7 Nvl2(b, 1,0) + Nvl2(c, 1,0) + Nvl2(d, 1,0)
8 Else
9 0
10 End E
11 from AA
·½·¨¶þ£º
´úÂë
1 Select a,
2 b,
3 c,
4
Ïà¹ØÎĵµ£º
SQL*Loader ÓÃÓÚ½«´óÁ¿Êý¾Ý×°ÈëÊý¾Ý¿â¡£
¢Å¡¢¶¨¿íÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
aaa,bbb
ccc,ddd
eee,fff
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 position(1:3) char,
m2 position(5:7) char)
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loade ......
Ubuntu9.04ÏÂOracleÊÖ¶¯Æô¶¯Óë×ÔÆô¶¯½Å±¾
Ò»¡¢Æô¶¯Êý¾Ý¿âʵÀý
Java´úÂë
gengzhi
@gengzhi
-desktop:~$ su oracle
oracle@gengzhi
-desktop:~$ sqlplus
" scott/tiger as sysdba"
gengzhi@gengzhi-desktop:~$ s ......
dualÊÇÒ»¸öÐéÄâ±í£¬ÓÃÀ´¹¹³ÉselectµÄÓï·¨¹æÔò£¬oracle±£Ö¤dualÀïÃæÓÀÔ¶Ö»ÓÐÒ»Ìõ¼Ç¼¡£ÎÒÃÇ¿ÉÒÔÓÃËüÀ´×öºÜ¶àÊÂÇ飬ÈçÏ£º
1¡¢²é¿´µ±Ç°Óû§£¬¿ÉÒÔÔÚ SQL PlusÖÐÖ´ÐÐÏÂÃæÓï¾ä select user from dual;
2¡¢ÓÃÀ´µ÷ÓÃϵͳº¯Êý
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;--»ñµÃµ±Ç°ÏµÍ³Ê±¼ ......
Oracle 3 ¸öÖ÷ÒªµÄÄÚ´æ½á¹¹£º
ϵͳȫ¾ÖÇø£¨System Global Area£¬SGA£©£ºÕâÊÇÒ»¸öºÜ´óµÄ¹²ÏíÄÚ´æ¶Î£¬¼¸ºõËùÓÐOracle
½ø³Ì¶¼Òª·ÃÎÊÕâ¸öÇøÖеÄijһµã¡£
½ø³ÌÈ«¾ÖÇø£¨Process Global Area£¬PGA£©£ºÕâÊÇÒ»¸ö½ø³Ì»òÏß³ÌרÓõÄÄڴ棬ÆäËû½ø³Ì/
Ï̲߳»ÄÜ·ÃÎÊ¡£
Óû§È«¾ÖÇø£¨User Global Area£¬UGA£©£ºÕâ¸öÄÚ´æÇøÓë ......
ɾ³ýAIXϵÄORACLE
===========================================================
×÷Õß: wmlm(http://wmlm.itpub.net)
·¢±íÓÚ:2008.12.02 18:17
·ÖÀà: oracle
³ö´¦£ºhttp://wmlm.itpub.net/post/12871/474762
---------------------------------------------------------------
rm -Rf /etc/oratab
rm -Rf /et ......