oracle±äÁ¿ÀàÐÍ
oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n) ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´® nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n) ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767 Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µãÊý,ÆäÖÐp±íʾ¾«¶È,ÓÃÓÚÖ¸¶¨Êý×ÖµÄ×ÜλÊý£¬s±íʾ±ê¶È£¬ÓÃÓÚÖ¸¶¨Ð¡ÊýµãºóµÄÊý×ÖλÊýÈçnumber(6,2)×î´óÊÇ4λ
DATE ¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨ÒåÈÕÆÚºÍʱ¼äÊý¾Ý£¬ÆäÊý¾Ý³¤¶ÈΪ¹Ì¶¨³¤¶È£¨7×Ö½Ú£©¡£¸ødate±äÁ¿¸³ÖµÊ±¡£Êý¾Ý±ØÐëÒªÓëÈÕÆÚ¸ñʽºÍÈÕÆÚÓïÑÔÆ¥Åä
TIMESTAMP ¸ÃÊý¾ÝÀàÐÍÊÇ9iÐÂÔö¼ÓµÄÊý¾ÝÀàÐÍ£¬ËüÓÃÓÚ¶¨ÒåÈÕÆÚºÍʱ¼äÊý¾Ý Óëdate²»Í¬ÔÚÓÚ²»½ö»áÏÔʾÈÕÆÚ£¬¶øÇÒ»¹»áÏÔʾʱ¼äºÍÉÏÏÂÎç±ê¼Ç
LONGºÍLONG RAW LONGÊý¾ÝÀàÐÍÓùÓö¨Òå±ä³¤×Ö·û´®£¬ÀàËÆÓÚvarchar2Êý¾ÝÀàÐÍ£¬µ«Æä×Ö·û´®µÄ×î´ó³¤¶ÈΪ32760£»LONG RAWÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¶þ½øÖÆÊý¾Ý
BOOLEAN ¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå²¼¶û±äÁ¿£¬Æä±äÁ¿µÄֵΪtrue£¬false»ònull£¬¸ÃÊý¾ÝÀàÐÍÊÇpl/sqlÊý¾ÝÀàÐÍ£¬±íÁв»ÄܲÉÓøÃÊý¾ÝÀàÐÍ
BINARY_INTEGER ÓÃÓÚ¶¨ÒåÕûÊý ÊýÖµ·¶Î§ÔÚ-214748367ºÍ2147483647Ö®¼ä ¸ÃÊý¾ÝÀàÐÍÊÇpl/sqlÊý¾ÝÀàÐÍ£¬±íÁв»ÄܲÉÓøÃÊý¾ÝÀàÐÍ
BINARY_FLOATºÍBINARY_DOUBLE
BINARY_FLOAT£¬BINARY_DOUBLE ÊÇOracle 10gÐÂÔö¼ÓµÄÊý¾ÝÀàÐÍ·Ö±ðÓÃÓÚ¶¨Òåµ¥¾«¶È¸¡µãÊýºÍË«¾«¶ÈµÄ¸¡µãÊý BINARY_FLOATºóÓ¦¸Ã´øÓÐf BINARY_DOUBLE ºóÓ¦¸Ã´øÓÐd
2¸´ºÏ±äÁ¿
1pl/sql ¼Ç¼
2pl/dql±í
3ǶÌ×±í ¸ß¼¶ÓïÑÔµÄÔªËظöÊýÓÐÏÞÖÆ Ç¶Ì×±íµÄÔªËظöÊýûÓÐÏÞÖÆ ¸ß¼¶ÓïÑÔÊý×éºÍǶÌ×±íµÄϱ궼²»ÄÜΪ¸ºÖµ
4VARRAY
×¢Ò⣺ǶÌ×±íÁÐÊý¾ÝÐèÒª´æ´¢ÔÚרÃŵĴ洢±íÖУ¬¶øVARRAYÊý¾ÝÔòÓëÆäËûÁÐÊý¾ÝÔÚÒ»Æð´æ·ÅÔÚ±í×Ö¶ÎÖС£
²ÎÕÕ±äÁ¿
1REF CURSOR
2REF ojb_type
LOB ±äÁ¿
LOB±äÁ¿ÊÇÖ¸ÓÃÓÚ´æ´¢´óÅúÁ¿Êý¾ÝµÄ±äÁ¿¡£Oracle½«LOB·ÖΪÁ½ÖÖ£ºÄÚ²¿LOBºÍÍⲿLOB£¬ÄÚ²¿LOB°üÀ¨CLOB,BLOBºÍNCLOBÈýÖÖÀàÐÍ£¬ËûÃǵÄÊý¾Ý±»´æ´¢ÔÚÊý¾Ý¿âÖÐ ²¢ÇÒÖ§³ÖÊÂÎñ²Ù×÷£¬ÍⲿLOBÖ»ÓÐBFILEÒ»ÖÖÀàÐÍ£¬¸ÃÀàÐ͵ÄÊý¾Ý±»´æ´¢ÔÚosÎļþÖУ¬²¢ÇÒ²»Ö§³ÖÊÂÎñ²Ù×÷£¬CLOB/NCLOBÓÃÓÚ´æ´¢´óÅúÁ¿×Ö·ûÊý¾Ý BLOBÓÃÓÚ´æ´¢´óÅúÁ¿¶þ½øÖÆÊý¾Ý£¬¶øBFILEÔò´æ´¢Ö¸ÏòosÎļþµÄÖ¸Õë
·ÇPL/SQL±äÁ¿
1ʹÓÃSQL*Plus±äÁ¿
2ʹÓÃProcedure Builder±äÁ¿
3ʹÓÃPro*C/C++±äÁ¿
Ïà¹ØÎĵµ£º
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØϵÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
×î½ü·¢ÏÖÓÐÒ»¸öÒ³ÃæµÄ´ò¿ªËٶȺÜÂý£¬¼¸ºõÿ´Î¶¼ÐèҪˢÐÂÊ®¼¸´Î²ÅÄÜ´ò¿ª£¬·ÖÎöÔÒò¿ÉÄÜÊÇÓÉÓÚʱ¼äµÄ»ýÀÛ£¬¸Ã±íÖеÄÊý¾ÝÁ¿¹ý´óÒýÆðµÄ£¨¸Ã±íÊÇÒ»ÕÅ´æ·Å¹ý³ÌÐÔÊý¾ÝµÄ±í£©¡£¾²éʵ£¬¹ûÕæÊǸñíÊý¾ÝÁ¿¹ý´ó£¬ÓÐ7°ÙÍòÖ®¶à¡£Ëì¾ö¶¨½«²¿·ÖÀúÊ·Êý¾Ý±¸·Ý²¢Çå³ýµô£¬ÒÔÌá¸ßÐÔÄÜ¡£
ʹÓãºcreart table table_bak as select * from t ......
µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕßÆäËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀÏ°åÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚÏ°àµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁË°¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......