СµÜµÄÎÊÌâÈçÏ£º
СµÜ¹«Ë¾µÄÒ»¸öÒDZíÉÏλ»úÊÇvb6¿ª·¢µÄ£¬Êý¾Ý¿âÊÇms µÄaccess£¬¿Í»§£¨Ò»¹¤³§£©Óõ½ÎÒÃǵÄÒÇÆ÷£¬ËûÒªÇó½«Êý¾ÝÉÏ´«µ½ËûÃÇµÄ ERP ϵͳÖУ¬ËûÃǵÄERP ϵͳÊÇB/Sģʽ,Êý¾Ý¿âÊÇORAcleµÄ£¬ÊÇÄÚ²¿¾ÖÓòÍø¡£
СµÜÓöµ½ÎÊÌ⣺
1£©ÎÒ¿Í»§¶Ë(C/S)±ØÐë°²×°ORACLE ¿Í»§¶ËÈí¼þô£¿»¹ÓÐÆäËûµÄ½â¾ö·½°¸Ã´£¿
2£©Á¬½ÓÀϳöÏÖ´ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ×ÅʾÀý´úÂëд¶¼²»¶ÔÄØ£¿ÎÒ»¹ÏëÎʵÄÊÇÄܲ»ÄÜÔÚsqlplusÏÂÃæÓÃinsert²åÈëÕâÀàÐ͵ÄÊý¾ÝÄØ£¿Èç¹û¿ÉÒÔÔõÃ´Ð´ÄØ£¿Ð ......
oracle ¿ÉÓÐʲô·½·¨ ͳ¼ÆÃ¿ÔÂÀÛ»ý¹ºÂòÈËÊý
±ÈÈç˵ÓиöÃŵê 2008Ä깺ÂòÉÌÆ·µÄÈËÊý
±í:t_buy_log ×Ö¶Î f_username Óû§Ãû³Æ;¹ºÂòʱ¼äf_buytime
1 Èç¹ûÊÇͳ¼ÆÃ¿Ô¹ºÂòÈËÊý
select to_char(f_buytime,'yyymm'),count(distinct f_username)
from t_buy_log
group by to_char(f_buytime, ......
¼ÙÉèÎÒÓÐÈý¸ö±í¿Õ¼ä,Ò»¸öÊDZí¿Õ¼äA,Óû§ÃûºÍÃÜÂë¶¼ÊÇONE,ÁíÍâÒ»¸öÊDZí¿Õ¼äB,Óû§ÃûºÍÃÜÂë¶¼ÊÇTWO,AºÍBµÄ±í¿Õ¼äÖеıí½á¹¹¶¼ÊÇÒ»ÑùµÄ.
ÏÖÔÚÎÒÏëÔÚµÚÈý¸ö±í¿Õ¼äCÉϽ¨Á¢ÊÓͼ,¾ÍÊǰÑAºÍBµÄÿÕűíµÄÊý¾ÝºÏ²¢ÆðÀ´
ÔÚSQLÀï¾ÍÊÇSELECT * from A.±í1 union SELECT * from B.±í1 µÄÒâ˼
²»ÖªµÀÎÒÓÐûÓбíÊ ......
ÓÃDOA4.1.2Á¬½ÓOracle·µ»ØµÄÊý¾ÝÂÒÂ룬²¢ÇÒÖ»ÊÇÔÚ³¬³öÒ»¶¨³¤¶Èºó¡£Êý¾Ý¿â10g UTF8×Ö·û¼¯¡£ÎÒʹÓõÄÊÇÔ´Âë×Ô¼º±àÒëµÄ°æ±¾£¬¹Ù·½Õ¾µãÉϵÄfor CBuilderÊÔÓðæÃ»ÓÐÎÊÌâ¡£
ûÊÔ¹ý
dbExpress°É£¬Ê²Ã´ÄêÍ·ÁË£¬»¹ÓÃDAO ? ²»ÊÇDOA. :)
DOA¾ÓÈ»ÊǸö×é¼þµÄÃû³Æ£¬»è¡££º£©
»¹ÒÔΪÊÇDAOÊý¾Ý·ÃÎʶÔÏóÄØ¡££º£¨
¹Ù·½Õ¾µãÉϵÄfo ......
ÎÒ×öµÄÊÇÒ»¸öѺ»ý·ÖµÄСģ¿é£¬ÎªÊ²Ã´ÎÒµÄÄ£¿éÖÐÓû§ÔÚѺ»ý·ÖʱÈç¹ûÓû§µã»÷µÄ¿ìµÄ»°£¬Óû§µÄ»ý·Ö¾Í»á³öÏÖ¸ºÊý¡£
Ѻ»ý·ÖÎÒÊÇÓÃdwrʵÏֵģ¬ÔÚÿѺһ´ÎÖ÷Ìâ¶¼»á²éѯһ´Î»ý·ÖÓàµÄ£¬Èç¹ûµã»÷ÂýµÄ»°¾Í²»»á³öÏÖ¸ºÊýΪʲôѽ£¡
Χ¹Û
ÍÛ Ïȶ¥ÁË
²»¶®¡£¶¥Ò»Ï¡£
......