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ÓÃÓÚÕûÐÍÊý¾Ý¡£
Ïà¹ØÎĵµ£º
ORACLEµÄËø»úÖÆ
×òÌìÈ¥Ò»¸ö¹«Ë¾ÃæÊÔ£¬Îʵ½OracleµÄ·âËø»úÖÆ£¬ºÇºÇ£¬ÀíÂÛÉϵÄÎÊÌâºÃ¾Ã¶¼Ã»ÓÐѧϰÁË£¬Êé±¾µÄ¶«Î÷Ò²²î²»¶à¶¼»¹¸øÁË´óѧµÄÀÏʦ¡£»ØÀ´·ÁËÒ»ÏÂÊé±¾£¬ÕÒµ½Á˹ØÓÚÕⲿ·Ö֪ʶµÄ˵Ã÷£¬Ìù³öÀ´¹©´óѧ²Î¿¼¡££¨ÏÖÔڵĹ«Ë¾£¬ ......
¸Õ²ÅÔÚEYGLEµÄ²©¿ÍÖп´µ½Ò»ÆªÌû×Ó£¬½²µÄÊÇDELETEµÄ²Ù×÷Á÷³Ì£¬ºÜ¼ò¶Ì£¬Í¬Ê±Ò²¾«±Ù¡£
===================================================================================
OracleÖУ¬Ò»¸öDelete²Ù×÷µÄÁ÷³Ì
ɾ³ý(DELETE)
1.Oracle¶ÁBlockµ½Buffer Cache(Èç¹û¸ÃBlockÔÚBufferÖв»´æÔÚ)
2.ÔÚredo log bufferÖмǼdelet ......
ORA-00313: ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (Ïß³Ì 1) µÄ³ÉÔ±
½ñÌìÓÃϵͳÇåÀí¹¤¾ß°ÑϵͳÀ¬»øÇåÀíÁËÒ»·¬,½á¹ûÔÚ´ò¿ªoracle Êý¾Ý¿âʱ³öÏÖÁË´íÎó:SQL> connect / as sysdba;
ÒÑÁ¬½Ó¡£
SQL> shutdown immediate;
ORA-01109: Êý¾Ý¿âδ´ò¿ª
ÒÑ¾Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ¹Ø±Õ¡£
SQL> startup;
ORACLE Àý³ÌÒѾÆô¶¯¡£ ......
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡Ô ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
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 ......