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

oracleÖÐdumpº¯Êý

ÎÊÌ⣺
1. oracleÖÐnumber£¬char/varchar£¬dateµÈÊý¾ÝÀàÐÍÊÇÔõô´æ´¢µÄ£¿×Ö½ÚÁ÷ÊÇʲôÑùµÄ£¿
2. ¸÷ÖÖÊý¾ÝÀàÐÍÕ¼ÓõÄ×Ö½Ú³¤¶ÈÊǶà´ó£¿
SELECT dump(1), DUMP(123456), DUMP(-123456), DUMP(1234567890123456) -- ÕûÊý
--SELECT DUMP(123456.789), DUMP(-123456.789), dump(1.234567890123456789E15), dump(123456789012345678901234567890123456789) -- ¸¡µãÊý
SELECT DUMP('a'), DUMP('abcdefghijklmn'), DUMP(CAST('abc' AS CHAR(20))), DUMP(CAST('abcÄã' AS VARCHAR(20)))
--SELECT sysdate, DUMP(SYSDATE)
from dual;
½áÂÛ£º
1. numberÀàÐ͵Ä×Ö½ÚÁ÷ÊDz»¶¨³¤µÄ£¬²¢ÇÒÕý¸ºÊý»áÓò»Í¬µÄ±ê־루ÕýÊý£ºÊý×Ö1 >= 193£¬¸ºÊý£ºÊý×Ö1 <= 62£¬²î¶îÇ¡ºÃÊÇÖ¸Êý´óС£©
2. charÊǶ¨³¤µÄ£¬³¤¶È²»×ã×î´ó³¤¶È»áÌî³äβ¿Õ¸ñ£¬varcharÊDz»¶¨³¤µÄ£¨¼´¸ø¶à³¤´æ¶à³¤£©
3. dateÀàÐͶ¨³¤£¬Õ¼8¸ö×Ö½Ú
-- ¸½Â¼Îª³£¼ûÊý¾ÝÀàÐ͵Ĵ洢·½Ê½ËµÃ÷£¬¿É²Î¼ûoracle¹Ù·½Îĵµ£¬»ò¸÷ÖÖ¼¼Êõblog
http://blog.oracle.com.cn/index.php/12012/action_viewspace_itemid_4684.html£¨¸½Â¼µÄÀ´Ô´£©
http://zhouwf0726.itpub.net/post/9689/196733
±ÊÕßÔÚ×öʵÑé¹ý³Ì£¨oracle9i2°æ±¾£©ÖУ¬·¢ÏÖʵ¼ÊDateÀàÐÍÓ븽¼ÖеIJ»Ò»Ñù£¬¹À¼Æ¸½Â¼ÖÐÊǶÔoracle8ÒÔǰ°æ±¾µÄ˵Ã÷¡£
Date(³¤¶È 7 ÀàÐÍ 12)
col dump_date form a35col real_date form a35
select dump(last_ddl_time) dump_date, to_char(last_ddl_time,'yyyy-mm-dd hh24:mi:ss') real_date
from user_objects
where rownum=1;
DUMP_DATE                           REAL_DATE
----------------------------------- ---------------------
Typ=12 Len=7: 120,102,4,13,16,48,53 2002-04-13 15:47:52ÊÀ¼Í 120 - 100 = 20 ÊÀ¼ÍºÍÄê·Ý¼Ó100ºó´æ´¢
Äê·Ý 102 - 100 = 2
ÔÂ·Ý 4 Ô·ݺÍÈÕÆÚ°´Ô­Öµ´æ´¢
ÈÕÆÚ 13
Сʱ 16 - 1 = 15 ʱ¼ä¾ù¼Ó1ºó´æ´¢
·ÖÖÓ 48 - 1 = 47
Ãë 53 - 1 = 52
--------------------------------------------------------------------------------
Number(ÀàÐÍ 2)
<[³¤¶È]>£¬·ûºÅλ/Ö¸Êý Êý×Ö1£¬Êý×Ö2£¬Êý×Ö3£¬......£¬Êý×Ö20
ÕýÊý£ºÖ¸Êý=Êý×Ö1 - 193 (×î¸ßλΪ1ÊÇ´ú±íÕýÊý)
¸ºÊý£ºÖ¸Êý=62 - µÚÒ»×Ö½Ú
Êý×Ö1ÊÇ×î¸ßÓÐЧλ
ÕýÊý£º¼Ó1´æ´¢
¸ºÊý£º±»


Ïà¹ØÎĵµ£º

oracle to_dateÏÝÚå

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

oracle½«×Ö·û´®×ª»»Îª12СʱÓë24Ð¡Ê±ÖÆ£º


oracle½«×Ö·û´®×ª»»Îª12СʱÓë24Ð¡Ê±ÖÆ£º
--12Ð¡Ê±ÖÆ£º
select hsv.mydate from huhai_seq_value  hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24Ð¡Ê±ÖÆ£º
select hsv.mydate from huhai_seq_value  hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-m ......

»ØÍû£¬ÎÒµÄOracle֮·


¡¡¡¡´óѧµÄʱºò£¬ÎÒÊǹÜÀíѧԺµÄ£¬ºóÀ´Ï¸·ÖרҵµÄʱºòÑ¡ÔñÁËÐÅÏ¢¹ÜÀí¡£ÓÚÊǹÜÀí¡¢»á¼Æ¡¢²ÆÎñ¡¢»úе¡¢µç×Ó£¬ÉõÖÁ˵Ç鱨¼ìË÷¶¼Ñ§¹ý£¬µ±È»Ò²°üÀ¨¼ÆËã»ú¡£
¡¡¡¡Èç¹û²»ËãfoxbaseºÍfoxproµÄ»°£¬Êý¾Ý¿â·½Ãæ½ö½öѧ¹ýÒ»ÃÅÊý¾Ý¿âÔ­Àí£¬ÓõĽ̲ÄÊÇStanfordµÄÓ°Ó¡°æ¡£
¡¡¡¡µ±Ê±ÓÐÒ»¸öΤÀÏʦ£¬×ÜÊÇ´µËýÀϹ«ÊÇMITµÄ²©Ê¿£¬ºÜNB¡£×ÜÊÇ¶Ô ......

oracle 9i ÏÂÔØ

ÒªÕÒOracle 9i for LinuxͦÂé·³µÄ£¬¸É´à×Ô¼ºÁô¸ö¼Ç¼±È½Ï·½±ã¡£
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://downlo ......

ORACLEÊý¾Ý¿âÖйØÓÚÓαêºÍ¼Ç¼±íµÄËٶȲâÊÔ

1
¡¢ÎÊÌâÌá³ö
     
ÔÚÎÒÃÇÈÕ³£µÄÊý¾Ý¿â²Ù×÷ÓÈÆäÊÇ´æ´¢¹ý³ÌÉè¼ÆÖУ¬¾­³£ÓмǼ±íÖ®ÀàµÄ¼¯ºÏ¡¢ÏÔʾÓαêµÈ²Ù×÷£¬µ«ÕâÁ½ÖÖÊý¾Ý´¦Àí·½Ê½ÔÚËٶȼ°ÐÔÄÜÉÏÓÐÊ²Ã´Çø±ðÄØ£¿
2
¡¢²âÊÔ·½·¨
   
ÔÚ
ORACLE
Êý¾Ý¿âÖд´½¨Ò»¸öÊý¾Ý±í£¬È»ºó¶Ô´´½¨µÄÊý¾Ý±í·Ö±ð²åÈë
100
Ìõ¡¢
1000
Ìõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ