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

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++±äÁ¿


Ïà¹ØÎĵµ£º

OracleÓëSQL ServerÊý¾Ý»¥Ò×ÐÔ£¨1£©

×÷Õß Haidong Ji ·­Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñÑ­¹ØϵÊý¾Ý¿âÄ£ÐÍÔ­Àí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......

oracleÐÔÄÜÓÅ»¯Ö®Ë÷Òý

 ×î½ü·¢ÏÖÓÐÒ»¸öÒ³ÃæµÄ´ò¿ªËٶȺÜÂý£¬¼¸ºõÿ´Î¶¼ÐèҪˢÐÂÊ®¼¸´Î²ÅÄÜ´ò¿ª£¬·ÖÎöÔ­Òò¿ÉÄÜÊÇÓÉÓÚʱ¼äµÄ»ýÀÛ£¬¸Ã±íÖеÄÊý¾ÝÁ¿¹ý´óÒýÆðµÄ£¨¸Ã±íÊÇÒ»ÕÅ´æ·Å¹ý³ÌÐÔÊý¾ÝµÄ±í£©¡£¾­²éʵ£¬¹ûÕæÊǸñíÊý¾ÝÁ¿¹ý´ó£¬ÓÐ7°ÙÍòÖ®¶à¡£Ëì¾ö¶¨½«²¿·ÖÀúÊ·Êý¾Ý±¸·Ý²¢Çå³ýµô£¬ÒÔÌá¸ßÐÔÄÜ¡£
ʹÓãºcreart table table_bak as select * from t ......

perl½«oracleÊý¾Ý¿âµÄÊý¾Ýµ¼³ö³ÉtxtµÄ¼òµ¥·½Ê½

 µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕßÆäËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀÏ°åÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚÏ°àµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
   ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁË°¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......

ѧϰOracleÖÐBlobºÍClobÒ»µãµãÐĵÃ

BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾ­ÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ