oracleÖÐintÀàÐͺÍnumberÀàÐÍÇø±ð
INTÀàÐÍÊÇNUMBERÀàÐ͵Ä×ÓÀàÐÍ¡£
ÏÂÃæ¼òҪ˵Ã÷£º
£¨1£©NUMBER£¨P,S£©
¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨ÒåÊý×ÖÀàÐ͵ÄÊý¾Ý£¬ÆäÖÐP±íʾÊý×ÖµÄ×ÜλÊý£¨×î´ó×Ö½Ú¸öÊý£©£¬¶øSÔò±íʾСÊýµãºóÃæµÄλÊý¡£¼ÙÉ趨ÒåSALÁÐΪNUMBER£¨6,2£©ÔòÕûÊý×î´óλÊýΪ4루6-2=4£©£¬¶øÐ¡Êý×î´óλÊýΪ2λ¡£
£¨2£©INTÀàÐÍ
µ±¶¨ÒåÕûÊýÀàÐÍʱ£¬¿ÉÒÔÖ±½ÓʹÓÃNUMBERµÄ×ÓÀàÐÍINT£¬¹ËÃû˼Ò壺INTÓÃÓÚÕûÐÍÊý¾Ý¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
¹ØÓÚOracle 10g ¹éµµ·½Ê½µÄÌÖÂÛ£º¹Ø±Õ¹éµµ/ÆôÓÃÉÁ»Ø»Ö¸´Çø¹éµµ(Oracle 10gÐÂÌØÐÔ)/ÆôÓÃÀàOracle9iµÄ¹éµµ
×¢£ºÔÚOracle°²×°¹ý³ÌÖУ¬Èç¹ûÊý¾Ý¿âÊÇ×Ô¶¯´´½¨µÄ£¬ÄÇô¸ÃÊý¾Ý¿â×î³õµÄ´æµµÄ£Ê½ÊÇÓɲÙ×÷ϵͳָ¶¨µÄ¡£Í¨³£Çé¿öÏ£¬¹éµµÈÕÖ¾ÔÚOracleÊý¾Ý¿â°²×°½áÊøºóÐèÒªÊÖ¹¤´´½¨¡£
»·¾³£ºOracle 10g 10.2.0.1.0/Windows 2003 ......
Ò»´ÎÆæ¹ÖµÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ¾Àú¡£
SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> conn / as sysdba
Co ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING ......
ÔÚoracleÊý¾Ý¿âÖвåÈëÊý¾Ýʱ£¬ÔËÐвåÈëÓï¾ä£¬ÏÈÊǰÑÊý¾Ý·ÅÈëµ½»º´æÖУ¬ÕâʱÊý¾Ý²¢Ã»ÓÐÕæÕýµÄ½øÈëÊý¾Ý¿â£¬ÕâÊÇoracleÊý¾Ý¿â¸úÆäËüÊý¾Ý¿âÖеIJ»Í¬µã£¬ÕâÊÇÒªÔËÐÐcommitÕâ¸öÊÂÎñÌá½»£¬²ÅÄÜÕæÕýµÄ°ÑÊý¾Ý·Åµ½Êý¾Ý¿âÖС£ ......