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

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'

·½·¨2£º
ͨ¹ýÑ­»·100´Î£¬Ã¿´ÎÖ´ÐÐÒ»¸öNameÌõ¼þ£¬Ö´ÐÐ100¸öSQLÓï¾ä
Select * from tmp_table where Name='ÕÅÈý' 
Select * from tmp_table where Name='ÀîËÄ'
......
Select * from tmp_table where Name='µÚÒ»°Ù¸öÐÕÃû'


ÕâÁ½ÖÖ·½·¨ÄǸöËٶȸü¿ìһЩ£¿
select * from tmp_table where name in(Ò»°Ù¸öÃû×Ö)

˵ʵÔÚ£¬Á½ÖÖ¶¼²»ºÃ¡£
Èç¹ûÖ»ÓÃsql´¦Àí£¬1Â¥·½·¨ºÃ£»Èç¹ûÓÃpl/sql´¦Àí£¬¿ÉÒÔÓÃÄãµÄ·½·¨2£¬µ«ÒªÊ¹Óð󶨱äÁ¿
Select * from tmp_table where Name=:v_name;

ÒýÓÃ
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'

·½·¨2£º
ͨ¹ýÑ­»·100´Î£¬Ã¿´ÎÖ´ÐÐÒ»¸öNameÌõ¼þ£¬Ö´ÐÐ100¸öSQLÓï¾ä
Select * fr¡­¡­


ÕâЩ·½·¨¶¼²»ÊǺܺÃ

µÚÒ»ÖÖºÃ

µÚÒ»ÖÖÖ»¶Ô±íɨÃèÒ»´Î

µÚ¶þÖÖÖ»¶Ô±íɨÃè100´Î



to:Phoenix_99
select * from tmp_table where name in(Ò»°Ù¸öÃû×Ö)

ÎҼǵúÃÏñIN ÔÚSQLÓï¾äÀï²»ÊÇ×îÂýµÄ¡£²»ÖªµÀÊDz»ÊÇ


ÎÒ¾ÍÊÇÓÃDELPHI±àд¿Í»§¶Ë³ÌÐò£¬ÐèÒªÌáÈ¡Õâ¸ö100¸öÐÕÃûµÄÊý¾Ý£¬´ó¼ÒÓöµ½ÕâÑùµÄÎÊÌâ¶¼²Éȡʲô·½·¨ÄØ£¿

Ò²ÓпÉÄÜ200,300£¬»ò¸ü¶à£¬Æä


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ