ÎÒ°²×°ÁËÒ»¸öoracle10G£¬²¢×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£
Ö®ºó¹ýÁ˺þã¬ÎÒ²ÅÓÖÒ»´ÎÒªÓõ½Ëü¡£µ«ÊÇÒѾ²»ÖªµÀ¸ÃÔõô½¨¿âÁË¡£»¹²»Ð¡ÐİÑÒÔǰµÄҲɾÁË¡£
¶ÔÁË£¬ÎÒ»¹°ÑÒ»¸öºÃÏñÊÇextproc_connection_dataɾÁËÖ®ºó£¬ÔÀ´µÄÊý¾Ý¿â¾Í½ø²»È¥ÁË¡£ËµÊÇʲô¼àÌýµÄʲô´íÎó¡£
ÅóÓÑ ¿É²»¿ÉÒÔ¸øÎÒ·¢¸öÏêϸµÄ²½Ö裬¹ØÓÚ½¨Õâ¸ö¿â£¬Óû§°¡£¬¼àÌ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸ÕÅ±í£¬¾ÍÕâô¼òµ¥µÄÊ£¬ÎÒÈ´²»»á×ö£¬¶¼²»ÖªµÀ´ÓºÎÏÂÊÖ£¬ÒÔǰ¶¼ÊÇÈ˼ҽ¨ºÃÁË£¬¸øÎÒ¸öÁ¬½ÓÎÒÈ¥Óã¬ÏÖÔÚÎÒÀ´×ö£ ......
ÏÖÓпͻ§Ïà¹ØµÄ±í£¬cus_acc(cusId--¿Í»§ID,acno--¿Í»§¿¨ºÅ,product--¹ºÂò²úÆ·,stat_date--ͳ¼ÆÈÕÆÚ£¬...)
ÒòÿÌì¶¼ÓдóÁ¿µÄ¿Í»§¹ºÂò´óÁ¿µÄ²úÆ·£¬ËùÒÔcus_acc±íµÄÊý¾ÝÁ¿ºÜ´ó£¬¶øÇÒ±íÖÐÖ»±£ÁôÁË40ÌìµÄÊý¾Ý£¬
ÿÌìÍíÉÏ×Ô¶¯µ÷Óô洢¹ý³Ì½«µ±ÌìµÄ½»Ò×Êý¾Ýµ¼Èëcus_acc±í£¬²¢½«40ÌìÒÔǰµÄÊý¾Ýɾ³ý£¬ÏÖÏ뽫cus_acc±í¸Ä³É·ÖÇø± ......
ÔÚÒ»ÕűíaÖУ¬ÓÐ×Ö¶Îxm,sfzhm,rid,xb,mzµÈ6¸ö×ֶΣ¬Èç¹ûxmºÍsfzhmÏàͬ£¬ÄÇô¾Í˵ÕâÁ½Ìõ¼Ç¼Ïàͬ£¬Çë½ÌÔõô½«ÕâÖÖÇé¿öϵÄÊý¾Ý²éѯ³öÀ´¡£
SQL code:
select t.* from a t where exists(select 1 from
(select xm,sfzhm from a group by xm, sfzhm having count(1) >= 2) m
where m.xm = t.xm and m.sfzhm = t.sfz ......
Eclipse ÎÒÏÖÔÚÔÚѧϰÓõıà³Ì¿ª·¢¹¤¾ß
oracle Õâ¸öºÃÏñÒ²ÊÇ¿ª·¢¹¤¾ß£¨±ð±ÉÊÓÎÒ£¬ÎÒûȥ¹È¸è£¬ÎÒÏëµÃµ½Õâ¶ùÈ˵Ľâ´ð£©
µ«ÊǺÃÏñ¶¼ËµÏÖÔÚ¿ª·¢¶¼ÓÃOracle¹¤¾ßÁË£¬ÄÇEclipse»¹ÓÐÓÃÂð£¿
Êý¾Ý¿âѧϰӦ¸ÃÔõÑù£¬ÎÒÁ·Íê×îºóÒ»¸öJ2se¿ªÊ¼Ñ§Êý¾Ý¿â~~
Çë¸æËßÎÒ£¬ лл
oracleÊÇÊý¾Ý¿âÀ´×Å£¬EclipseÊÇ¿ª·¢¹¤¾ß¡£¡£¡£
Õ ......
ÈçÌ⣬ÎÒµÄjava web³ÌÐòÒªÇóµã»÷Ò»¸ö°´Å¥£¬´ÓÓ²ÅÌÉÏÑ¡ÔñÒ»¸öͼƬ£¬È»ºó½«Í¼Æ¬²åÈëµ½oracleÖУ¬Ï£Íû´ó¼Ò¸æËßÎÒÔõôʵÏÖѽ
ÔÚoracleÊý¾Ý¿âÖд´½¨Ò»¸öBlobÀàÐ͵Ä×ֶΣ¬ÏÈÓÃempty_blob()½øÐвåÈ룬Ȼºó¸üС£
лл´ó¼ÒµÄ˼·£¬ÒªÊÇÄÜÔÚÏêϸЩ¾ÍºÃÁË£¬ºÇºÇ£¬²»¹ýÎһᰴ×Å´ó¼ÒµÄ˼·ÏÈ×öµÄ
ÎҵijÌÐòÖÐÒ²ÊÇÓÃhibernate£¬² ......