·þÎñÆ÷Oracle´Ó8iÉý¼¶µ½11gµ¼³öµÄʱºòÊÇÓÃexpÃüÁî¡£µ«ÊÇÄÇʱºò8iµÄ¿âÓõÄÊÇAMERICAN_AMERICA.US7ASCIIÏÖÔÚÓÃ11gÑ¡ÔñAMERICAN_AMERICA.US7ASCII×Ö·û¼¯½¨¿âÔÙimpµ¼ÈëÊý¾Ý´æÔÚÂÒÂëÎÊÌâ¡£»¹ÓоÍÊÇÕâ¸ö¿âÖÐÓÐͬÒå´Ê£¬Ë÷Òý£¬db link µÈµÈ¶«Î÷ÔõôÑù²ÅÄܽ«ÏÖÔÚµÄdmpÎļþÖеÄ×Ö·û¼¯¸Ä³ÉSIMPLIFIED CHINESE_CHINA.ZHS16GBKµÄÔõô»»£¿ ......
ÓÐ500ÍòÌõͨ»°¼Ç¼
±àºÅ ºÅÂë ±»½ÐºÅÂë ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä ͨ»°Ê±³¤
1 10010 20020 12:00 12:01 1
2 10010 20045 12:05 12:06 ......
¸÷λÀÏ´ó¸øµã½¨Òé
ËäÈ»¶¼ÊǹØÏµÊý¾Ý¿âÖеÄٮٮÕߣ¬µ«¶þÕßÊÇÍêÈ«²»Í¬µÄ²úÆ·£¬Ã»ÓÐÏÈѧÄÄÒ»¸öµÄÇø·Ö£¬¹Ø¼üÊÇÊý¾Ý¿â»ù±¾¸ÅÄîºÍSQLÓï¾äµÄѧϰÉÏ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ£¿
Ëæ±ãÏÈѧÄÄÖÖ
¡£¡£¡£Ë¸æËßÄãѧoracleÒªÏÈѧSqlServerµÄ
лл´ó¼ÒÁË£¬Ò»¸öȺÀïµÄȺÓÑ˵ÎÒÖ±½Óѧoracle»áºÜÉËÐÄ£¬ËùÒÔÎÊÁË¡ ......
ÈçºÎ¿ìËÙÌá¸ßдoracleµÄSQLÓï¾äµÄÄÜÁ¦£¿ÓÐʲô½Ý¾¶Ã»ÓУ¿Çë¸ßÊÖÖ¸µãÃÔ½ò£¬ÔÚ´ËлÁË¡£
ºÇºÇ ûʲô½Ý¾¶ ƽʱ¶à¶à¿´Ê鲢ʵ¼ù°É
ÎÒÒ²ÏëÖªµÀ¡¡ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ
¶àдд°É¡£¶à¶¯¶¯ÄÔ¾
ÒýÓÃ
ÎÒÒ²ÏëÖªµÀ¡¡ ÈçÓÐÓнݾ¶µÄ»° ºÇºÇ
ºÇºÇ ¶àÅÜÅÜÓï¾ä°É¡£¡£¡£
×Ô¼º¶à¶¯ÊÖддÁË¡£¡£¡£
ÓÐÒ» ......
×Ö¶Î FORGANGUID TOTAL FSTATETYPE
1 0412105DA35645EA9A32AE160EEA25BF 1;1 estIllnessRest;estRetire
2 05AF08C3195B4075847685E96711457D 1 estRegular
3 10EDE82520F24289B70143EB4284AE84 6 estRegular
4 11EBAFE5E74343F39F0F111E571617F0 2 estRegular
5 15C892FDE6BA447C81D1 ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿ÉÓã¬ÎÒÊDz»ÖªµÀ£¬ÊDz»ÊÇÔÚ*.pc²»Ö§³Ö·ÃÎÊ1.inc(ÓжÔÊý¾Ý¿â½øÐУ©
ÔÚ1.pcÖУ¬1.inc£¨Ö»ÊÇ×Ö·û´¦Àí£©Ò²¿ÉÒÔÇ ......