ORACLE²åÈëÈÕÆÚÊý¾Ý
oracleÊý¾Ý¿â²åÈëÈÕÆÚÐÍÊý¾Ý
ÍùOracleÊý¾Ý¿âÖвåÈëÈÕÆÚÐÍÊý¾Ý£¨to_dateµÄÓ÷¨£©
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-20 18:31:34' , 'YYYY-MM-DD HH24:MI:SS' ) ) ;
²éѯÏÔʾ£º2007-12-20 18:31:34.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-14 14:10' , 'YYYY-MM-DD HH24:MI' ) );
²éѯÏÔʾ£º2007-12-14 14:10:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-14 14' , 'YYYY-MM-DD HH24' ) );
²éѯÏÔʾ£º2007-12-14 14:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-11-15' , 'YYYY-MM-DD' ) );
²éѯÏÔʾ£º2007-11-15 00:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007-09' , 'YYYY-MM' ) );
²éѯÏÔʾ£º2007-09-01 00:00:00.0
-------------------
INSERT INTO FLOOR VALUES ( to_date ( '2007' , 'YYYY' ) );
²éѯÏÔʾ£º2007-05-01 00:00:00.0
-------------------
µ±Ê¡ÂÔHH¡¢MIºÍSS¶ÔÓ¦µÄÊäÈë²ÎÊýʱ£¬OracleʹÓÃ0×÷ΪDEFAULTÖµ¡£
Èç¹ûÊäÈëµÄÈÕÆÚÊý¾ÝºöÂÔʱ¼ä²¿·Ö£¬Oracle»á½«Ê±¡¢·Ö¡¢Ã벿·Ö¶¼ÖÃΪ0£¬Ò²¾ÍÊÇ˵»áÈ¡Õûµ½ÈÕ¡£
ͬÑù£¬ºöÂÔÁËDD²ÎÊý£¬Oracle»á²ÉÓÃ1×÷ΪÈÕµÄĬÈÏÖµ£¬Ò²¾ÍÊÇ˵»áÈ¡Õûµ½Ô¡£
µ«ÊÇ£¬²»Òª±»ÕâÖÖ“¹ßÐÔ”ËùÃÔ»ó£¬Èç¹ûºöÂÔMM²ÎÊý£¬Oracle²¢²»»áÈ¡Õûµ½Ä꣬¶øÊÇÈ¡Õûµ½µ±Ç°ÔÂ
Ïà¹ØÎĵµ£º
SqlÖÐÁ½¸ö“-”±íʾעÊ͵ĿªÊ¼¡£
Æ´½ÓÔËËã·û£º”||”,×¢Ò⣺ֻÓÐÔÚËùÓеÄÔËËã·ûΪnullʱ£¬Æ´½ÓµÄ½á¹ûÊÇnull¡£
±È½ÏÔËËã·ûÓÃÓڱȽÏÁ½¸öÖµ»ò±í´ïʽ£¬¸ø³öÒ»¸ö²¼¶ûÐ͵Ľá¹û true,false,null.
±È½ÏÔËËã·û£º
=
!= <> ^=
[not]in °üº¬
Any some ½«Ò»¸öÖµÓëÁбíÖеÄÿ¸öÖµ»òÕß ......
select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³ÌÖÐÈ¥µ÷ÓÃÕâЩº¯Êý.
¶þ:È ......
½ñÌìXXX˵Ҫ°ÑOracle ÀïµÄ¼¸ÕűíÖØÐÂÕûÀíÏ£¬ºÇºÇ ½á¹û°¢·¢ÏÖ10À´ÕÅ±í»¹ÕæÊÇ˵¶à²»¶à˵ÉÙÒ»µã¶¼²»ÉÙ ¡£ÒòΪ±íÀïÃæµÄcommetÒѾÌîÉÏÁË ¡£ÍµÀÁµÄÏë·¨¶Ùʱ³öÏָ¸Â
select t.COLUMN_NAME ×Ö¶ÎÃû, t.DATA_TYPE||'('||t.DATA_LENGTH||')' ×Ö¶ÎÀàÐÍ,t.NULLABLE ÊÇ·ñΪ¿Õ,t.DATA_DEFAULT ĬÈÏÖµ,p.comments ×Ö¶Î˵Ã÷
fro ......
pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......