OracleÖеÄNumberºÍFloatÀàÐÍ
NumberÀàÐÍ
Oracle number datatype Óï·¨£ºNUMBER[(precision [, scale])]
ÓÐЧΪ£º´Ó×ó±ßµÚÒ»¸ö²»Îª0µÄÊýËãÆðµÄλÊý¡£
scale > 0
¾«È·µ½Ð¡ÊýµãÓÒ±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ <= p¡£
scale < 0
¾«È·µ½Ð¡Êýµã×ó±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ <= p + |s|¡£
scale = 0
NUMBER±íʾÕûÊý
FloatÀàÐÍ
¡¾copy¡¿½ñÌìÓÐÈËÎÊÎÒ£¬Ëû°Ñ×Ö¶ÎÀàÐÍÉè¼Æ³Éfloat(2)ºó£¬²åÈëÊý¾Ý93.5£¬ºó£¬ÎªÊ²Ã´±ä³ÉÁË90£¿
ΪÁË˵Ã÷Õâ¸öÎÊÌ⣬ÎÒÃÇÏÈÀ´¿´Ò»¶Î»°£¨http://www.cnoug.org/viewthread.php?tid=56643£©£ºOracle Online Help ˵£ºFLOAT(b) specifies a floating-point number with binary precision b. The precision b can range from 1 to 126. To convert from binary to decimal precision, multiply b by 0.30103¡£
¸ù¾ÝÕâ¶Î»°£¬ÎÒÃÇ¿ÉÒÔ¿´µ½£¬float(2)ÖеÄ2ÊÇÒ»¸öbinary precision£¬¶ø²»ÊÇÎÒÃdz£ÓõÄdecimal precision¡£ËûÃÇÖ®¼äµÄ»»Ëã¹ØϵÊÇ£ºbinary precision£½int(b*0.30103)£¬Òò´ËÎÒÃÇÕâÀïʵ¼ÊÉϵľ«¶ÈÓ¦¸ÃµÈÓÚint(2*0.30103)=0£¬¼´Ð¡Êýµãºó¾«¶ÈΪ0¡£
»Øµ½ÎÒÃÇÔÀ´µÄÎÊÌ⣬93.5»¯³É¸¡µãÐÍ9.35*10^1£¬Õâʱ9.35СÊýµãºó¾«¶ÈΪ0£¬³É9£¬Òò´Ë×îºó±ä³É9*10^1=90¡£
ÀàËƵģ¬ÎÒÃÇ¿ÉÒÔÉè¼Æ³Éfloat(10)£¬ÄÇôint(10*0.30103)=3£¬Òò´Ë£¬Èç¹û²åÈë93.5£¬¾ÍµÃ³ö9.35--¾«¶ÈΪ3-->9.350£¬9.350*10^1=93.5¡£Èç¹û²åÈë13884.2£¬µÃ³ö1.38842--¾«¶ÈΪ3-->1.388£¬1.388*10^4=13880¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORD ......
Ç°ÌìÓÐÈËÌáÁËÐèÇó£¬Ïë¶Ôij¸ö×ֶνøÐа´Î»µÄ»ò²Ù×÷¡£±¾À´½¨Òé²éѯ³öÀ´Ö®ºóÔÚÓ¦ÓóÌÐòÀïÃæ´¦Àí£¬µ«ÊÇÊý¾ÝÁ¿±È½Ï´ó£¬¾õµÃ»¹ÊÇ·µ»ØÒ»¸ö·Ö×é¼ÆËãÖ®ºóµÄÖµ±È½ÏºÏÊÊ¡£
Á½¸öÎÊÌ⣬һ¸öÊÇ°´Îª»òµÄ²Ù×÷£¬Õâ¸ö²Î¿¼Á˱ðÈ˵ÄÎĵµ£¬ÓÃbitandº¯ÊýʵÏÖ¡£ ÔÎÄÈçÏ£º
http://blog.chinahr.com/blog/hewy0526/post/112968
È»ºó¾ÍÊÇ×Ô¶¨ÒåµÄ ......
ÔÚµ¼ÍêÊý¾ÝÖ®ºó·¢ÏÖ oracleµÄ°²×°ÅÌÖ»Óм¸MµÄ¿Õ¼äÁË¡£
ÏÖÔÚÓÐÁ½¸ö·½°¸¿ÉÒÔÑ¡Ôñ
1.°ÑÊý¾ÝÎļþתÒƵ½ÁíÍâÒ»¸öÅÌÈ¥¡£
ÎÒµ¼Êý¾ÝµÄʱºòÊÇÕâÑù×öµÄ 1.н¨Ò»¸ö±í¿Õ¼ä£¬Îª±í¿Õ¼äÌí¼ÓÒ»¸öÊý¾ÝÎļþ£¨assure_dt£©¡£2.н¨Óû§£¬±í¿Õ¼äÖ¸Ïò²½Öè1н¨µÄ±í¿Õ¼ä¡£
È»ºóµ¼Èë¡£ÎÒÓõÄÊÇoracle 10g
ÎÊÌâ1.ΪʲôÎÒÌí¼ÓµÄÊý¾ÝÎļþas ......
E:\>exp help=y
ͨ¹ýÊäÈë EXP ÃüÁîºÍÓû§Ãû/¿ÚÁÄú¿ÉÒÔ
ÔÚÓû§ / ¿ÚÁîÖ®ºóµÄÃüÁî:
ʵÀý: EXP SCOTT/TIGER
»òÕߣ¬ÄúÒ²¿ÉÒÔͨ¹ýÊäÈë¸úÓи÷ÖÖ²ÎÊýµÄ EXP ÃüÁîÀ´¿ØÖÆ“µ¼³ö”µÄÔËÐз½Ê½¡£
ÒªÖ¸¶¨²ÎÊý£¬Äú¿ÉÒÔʹÓùؼü×Ö:
¸ñʽ: EXP KEYWORD=value »ò KEYWORD=(value1,value2,...,valueN)
ʵÀý: EXP SCOTT ......