Oracle Êý¾ÝÀàÐͼ°´æ´¢·½Ê½
Ô¬¹â¶« Ô´´
¸ÅÊö
ͨ¹ýʵÀý£¬È«Ãæ¶øÉîÈëµÄ·ÖÎöoralceµÄ»ù±¾Êý¾ÝÀàÐͼ°ËüÃǵĴ洢·½Ê½¡£ÒÔORACLE 10GΪ»ù´¡£¬½éÉÜoralce 10gÒýÈëµÄеÄÊý¾ÝÀàÐÍ¡£ÈÃÄã¶ÔoracleÊý¾ÝÀàÐÍÓÐÒ»¸öȫеÄÈÏʶ¡£½ÒʾһЩ²»ÎªÈËÖªµÄÃØÃܺͱ»ºöÂÔµÄäµã¡£´ÓʵÓúÍÓÅ»¯µÄ½Ç¶È³ö·¢£¬ÌÖÂÛÿÖÖÊý¾ÝÀàÐ͵ÄÌص㡣´ÓÕâÀ↑ʼoracleÖ®Âã¡
µÚÒ»²¿·Ý ×Ö·ûÀàÐÍ
§1.1 char
¶¨³¤×Ö·û´®£¬»áÓÿոñÀ´Ìî³äÀ´´ïµ½Æä×î´ó³¤¶È,×2000¸ö×Ö½Ú¡£
1£® н¨Ò»¸ö²âÊÔ±ítest_char.,Ö»ÓÐÒ»¸öcharÀàÐ͵ÄÁС£³¤¶ÈΪ10
SQL> create table test_char(colA char(10));
Table created
2£® ÏòÕâ¸ö±íÖвåÈëһЩÊý¾Ý¡£
SQL> insert into test_char values('a');
1 row inserted
SQL> insert into test_char values('aa');
1 row inserted
SQL> insert into test_char values('aaa');
1 row inserted
SQL> insert into test_char values('aaaa');
1 row inserted
SQL> insert into test_char values('aaaaaaaaaa');
1 row inserted
×¢Ò⣺×î¶àÖ»ÄܲåÈë10¸ö×Ö½Ú¡£·ñÊǾͱ¨´í¡£
SQL> insert into test_char values('aaaaaaaaaaa');
insert into test_char values('aaaaaaaaaaa')
ORA-12899: value too large for column "PUB_TEST"."TEST_CHAR"."COLA" (actual: 11, maximum: 10)
3£® ʹÓÃdumpº¯Êý¿ÉÒԲ鿴ÿһÐеÄÄÚ²¿´æÊý½á¹¹¡£
SQL> select colA, dump(colA) from test_char;
COLA DUMP(COLA)
---------- --------------------------------------------------------------------------------
a Typ=96 Len=10: 97,32,32,32,32,32,32,32,32,32
aa Typ=96 Len=10: 97,97,32,32,32,32,32,32,32,32
aaa Typ=96 Len=10: 97,97,97,32,32,32,32,32,32,32
aaaa Typ=96 Len=10: 97,97,97,97,32,32,32,32,32,32
aaaaaaaaaa Typ=96 Len=10: 97,97,97,97,97,97,97,97,97,97
×¢Ò⣺Typ=96 ±íʾÊý¾ÝÀàÐ͵ÄID¡£OracleΪÿһÖÖÊý¾ÝÀàÐͶ¼½øÐÐÁ˱àºÅ¡£ËµÃ÷charÀàÐ͵ıàºÅÊÇ96.
Len =10 ±íʾËùÔÚµÄÄÚ²¿´æ´¢µÄ³¤¶È(ÓÃ×Ö½Ú±íʾ)¡£ËäÈ»µÚÒ»ÀýÖ»´æÁËÒ»¸ö×Ö·û
OracleÊý¾Ý¿âÔÚʹÓùý³ÌÖУ¬Ëæ×ÅÊý¾ÝµÄÔö¼ÓÊý¾Ý¿âÎļþÒ²Öð½¥Ôö¼Ó£¬ÔÚ´ïµ½Ò»¶¨´óСºóÓпÉÄÜ»áÔì³ÉÓ²Å̿ռ䲻×ã;ÄÇôÕâʱÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý¿âÎļþÒƶ¯µ½ÁíÒ»¸ö´óµÄÓ²ÅÌ·ÖÇøÖС£ÏÂÃæÎÒ¾ÍÒÔOracle for Windows°æ±¾ÖаÑCÅ̵ÄÊý¾Ý¿âÎļþÒƶ¯µ½DÅÌΪÀý½éÉÜOracleÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨ºÍ²½Öè¡£
¡¡¡¡1.ÔÚsqlplusÖÐÁ¬½Óµ½ÒªÒƶ¯ÎļþµÄOr ......
½ñÌì°²×°Èí¼þÒ»Ö±ÔÚ²âÊÔÁ´½Ó²»ÄÜͨ¹ý£¬³öÏÖORA-12154: TNS: could not resolve service name£¬ºóÀ´²Å·¢ÏÖÊÇtnsnames.oraÖÐÓÐÎó¡£²éÕÒÍøÉϵÄ×ÊÁÏ£¬¼Ç¼ÏÂÀ´¡£
ÒªÅųý¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÎÊÌ⣬Ê×Ïȼì²é¿Í»§¶ËÅäÖÃÊÇ·ñÕýÈ·(¿Í»§¶ËÅäÖñØÐëÓëÊý¾Ý¿â·þÎñÆ÷¶Ë¼àÌýÅäÖÃÒ»ÖÂ)£¬ÔÙ¸ù¾Ý´íÎóÌáʾ½â¾ö¡£ÏÂÃæÁгö¼¸ÖÖ³£¼ûµÄÁ¬½ÓÎÊÌâ ......