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

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ÓÃÓÚÕûÐÍÊý¾Ý¡£


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle 10g ¹éµµÈÕÖ¾£¨Archive Log £©

 ¹ØÓÚOracle 10g ¹éµµ·½Ê½µÄÌÖÂÛ£º¹Ø±Õ¹éµµ/ÆôÓÃÉÁ»Ø»Ö¸´Çø¹éµµ(Oracle 10gÐÂÌØÐÔ)/ÆôÓÃÀàOracle9iµÄ¹éµµ
×¢£ºÔÚOracle°²×°¹ý³ÌÖУ¬Èç¹ûÊý¾Ý¿âÊÇ×Ô¶¯´´½¨µÄ£¬ÄÇô¸ÃÊý¾Ý¿â×î³õµÄ´æµµÄ£Ê½ÊÇÓɲÙ×÷ϵͳָ¶¨µÄ¡£Í¨³£Çé¿öÏ£¬¹éµµÈÕÖ¾ÔÚOracleÊý¾Ý¿â°²×°½áÊøºóÐèÒªÊÖ¹¤´´½¨¡£
»·¾³£ºOracle 10g 10.2.0.1.0/Windows 2003 ......

LinuxÏÂoracle 10g ÖйرÕÊý¾Ý¿â´íÎó

 Ò»´ÎÆæ¹ÖµÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ¾­Àú¡£
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 ......

Oracle´´½¨±í¿Õ¼ä¡¢´´½¨Óû§ÒÔ¼°ÊÚȨ¡¢²é¿´È¨ÏÞ

  
 ´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
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Êý¾Ý¿âÀïÃæcommit¹Ø¼ü×ÖµÄʹÓÃ

    ÔÚoracleÊý¾Ý¿âÖвåÈëÊý¾Ýʱ£¬ÔËÐвåÈëÓï¾ä£¬ÏÈÊǰÑÊý¾Ý·ÅÈëµ½»º´æÖУ¬ÕâʱÊý¾Ý²¢Ã»ÓÐÕæÕýµÄ½øÈëÊý¾Ý¿â£¬ÕâÊÇoracleÊý¾Ý¿â¸úÆäËüÊý¾Ý¿âÖеIJ»Í¬µã£¬ÕâÊÇÒªÔËÐÐcommitÕâ¸öÊÂÎñÌá½»£¬²ÅÄÜÕæÕýµÄ°ÑÊý¾Ý·Åµ½Êý¾Ý¿âÖС£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ