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

oracle PL/SQL Öг£Á¿ºÍ±äÁ¿µÄÉùÃ÷

 
Ò»¡¢³£ÓÃÊý¾ÝÀàÐÍ£º
Number£ºÊý×ÖÀàÐÍ
Int£ºÕûÊýÐÍ
Pls_integer£ºÕûÊýÐÍ£¬²úÉúÒç³öµÄ´íÎó
Binary_integer£ºÕûÊýÐÍ
Char£º¶¨³¤×Ö·û£¬×255¸ö×Ö·û
Varchar2£º±ä³¤×Ö·û£¬×2000¸ö×Ö·û
Long£º±ä³¤×Ö·û£¬×2GB
Date£ºÈÕÆÚÐÍ
Boolean£º²¼¶ûÐÍ
¶þ¡¢¶¨Òå³£Á¿
¸ñʽ£º³£Á¿Ãû   constant    Êý¾ÝÀàÐͱêʶ·û    [not null] := Öµ
Àý : iCount constant Int not null:=200
˵Ã÷: ¶¨Òå³£Á¿iCount,ֵΪ200;
Èý¡¢¶¨Òå»ù±¾Êý¾ÝÀàÐͱäÁ¿
      ¸ñʽ£º±äÁ¿Ãû ÀàÐͱêʶ·û [not null] := Öµ
      Àý £ºsex Boolean not null :=0;
      ˵Ã÷£º¶¨Òå±äÁ¿sex ֵΪ0;
ËÄ¡¢¸´ºÏÊý¾ÝÀàÐͱäÁ¿
      1¡¢Ê¹ÓÃ%TYPE¶¨Òå±äÁ¿
˵Ã÷£ºÕâ¸öÐÍʽÊÇΪÁËÈñäÁ¿µÄÊý¾ÝÀàÐÍÓë±íÖеÄÊý¾ÝÀàÐÍÒ»Öµģ¬¶¨ÒåºÃÒԺ󣬱íÖеÄÊý¾ÝÀàÐ͸ı䣬Õâ¸ö±äÁ¿µÄÊý¾ÝÀàÐÍҲͬʱ¸Ä±ä£»
¸ñʽ£º±äÁ¿Ãû Óû§Ãû.±íÃû.×Ö¶ÎÃû%TYPE£»
Àý : sex SCOTT.Tdetails.SEX%TYPE£»
˵Ã÷£ºsex±äÁ¿¾ÍÓëscottÓû§ÏµÄTdetails±íÖеÄsex×ֶεÄÀàÐÍÒ»Ö£»
      2¡¢¼Ç¼ÀàÐͱäÁ¿
           ˵Ã÷£º½«¶à¸öÊý¾ÝÀàÐÍÀ¦°óÔÚÒ»ÆðµÄÊý¾ÝÀàÐÍ
           ¸ñʽ£ºTYPE ±äÁ¿Ãû IS RECORD(
                      ±äÁ¿Ãû1 »ù±¾Êý¾ÝÀàÐÍ£¬
                      ±äÁ¿Ãû2 »ù±¾Êý¾ÝÀàÐÍ£¬……);
           Àý £ºTYPE tRecords IS RECORD(
                      Name varchar2,
                      Sex Boolean);
            


Ïà¹ØÎĵµ£º

Oracle¿Í»§¶ËNLS_LANGÉèÖÃ


1. NLS_LANG
²ÎÊý×é³É
NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients
Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄϰ¹ß
CHARACTERSET:
-¿Ø ......

Oracleʱ¼äÈÕÆÚ²Ù×÷

Oracleʱ¼äÈÕÆÚ²Ù×÷
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
add_months(sysdate,-5) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
add_months(sysdate,-5*12) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
ÉÏÔÂÄ©µÄÈÕÆÚ£ºsel ......

oracle to_dateÏÝÚå

ORACLE to_date ÏÝÚå
oracle Öв»´øÊ±·ÖÃëµÄ×Ö·û´® to_date ת»»Ê±¼äºóÓë´øÊ±·ÖÃëµÄdateÐÍ×Ö¶Î×ö´øµÈÖµµÄ±È½Ï (>=,<=,=)ʱ£¬ÓÉÓÚ×Ö·û´®²»´øÊ±·ÖÃ룬ËùÒÔת»»ºóʱ·ÖÃëĬÈÏΪ00:00:00,oracleÖбȽÏdateÊÇÒÔÒ»¸öʱ¼äµãÀ´±È½ÏµÄ£¬¾«È·µ½ÃëÉõÖÁºÁÃë΢ÃëÄÉÃë,ËùÒÔdate×ֶεÄʱ·ÖÃ벻Ϊ00:00:00µÄ¾ÍÓë²»´øÊ±·ÖÃë×Ö·û´®×ª»»º ......

Oracle Flashback ¼¼Êõ×ܽá

Oracle Flashback ¼¼Êõ×ܽá
Flashback ¼¼ÊõÊÇÒÔUndo segmentÖеÄÄÚÈÝΪ»ù´¡µÄ£¬ Òò´ËÊÜÏÞÓÚUNDO_RETENTON²ÎÊý¡£ÒªÊ¹ÓÃflashback µÄÌØÐÔ£¬±ØÐëÆôÓÃ×Ô¶¯³·Ïú¹ÜÀí±í¿Õ¼ä¡£
ÔÚOracle 10gÖУ¬ Flash back¼Ò×å·ÖΪÒÔϳÉÔ±£º Flashback Database£¬ Flashback Drop£¬Flashback Query(·ÖFlashback Query,Flashback Version Query ......

OracleÊý¾Ý¿â¼àÌýÅäÖÃ


ת£ºhttp://oracle.chinaitlab.com/install/755900.html
        ¼òµ¥À´Ëµ£¬OracleÊý¾Ý¿âµÄ¼àÌýÅäÖðüÀ¨·þÎñÆ÷¶ËµÄÅäÖúͿͻ§¶ËµÄÅäÖ᣷þÎñÆ÷¶ËÊÇͨ¹ý¼àÌýÆ÷¼´LISTENERÀ´Íê³ÉµÄ£¬¶ø¿Í»§¶ËÅäÖÃÓжàÖÖ£¬³£ÓõÄÊDzÉÓñ¾µØ·þÎñÃûÀ´ÅäÖ᣹ØÓÚ¼àÌýÆ÷ºÍ±¾µØ·þÎñÃû£¬Ïêϸ½âÊÍÈçÏ£º
Ò»¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ