¹ØÓÚOracleµÄ¿ÉÑ¡Ìõ¼þ²éѯ
ÎÒ¿´µ½±ðÈËÓÃÕâÑùµÄsqlÓï¾äÀ´×ö¿ÉÑ¡Ìõ¼þ²éѯ Java code: String qrySql = "select id,name,sex from STUDENT"+ "where name = :s_name"+ "[and sex = :s_sex]" ·½À¨ºÅÀïµÄÒâ˼¾ÍÊÇ Èç¹ûÌṩÁË:s_sex²ÎÊýÔò²éѯÌõ¼þ°üº¬ and sex = :s_sex Èç¹ûûÓÐÌṩ:s_sex ÔòºöÂÔ and sex = :s_sex ÕâÒ»¾ä. ÇëÎÊOracleÖ§³ÖÕâÖÖÓ﷨ô?
ÒýÓà ²»ÍƼöÕâÑù×ö¡£ and sex like decode(:s_sex, null, '%'£¬ :s_sex) Ò²¾ÍÊÇ˵ÕâÖÖд·¨ÊÇÖ§³ÖµÄ?¿ÉÊÇÔÚsqlPlusÀïÃ²ËÆ»áÌáʾSQlÓï¾äδ½áÊø,ÕâÊÇÎªÊ²Ã´ÄØ?ÒýÓà ÒýÓà 1 Â¥ inthirties µÄ»Ø¸´: ²»ÍƼöÕâÑù×ö¡£ and sex like decode(:s_sex, null, '%'£¬ :s_sex) Ò²¾ÍÊÇ˵ÕâÖÖд·¨ÊÇÖ§³ÖµÄ?¿ÉÊÇÔÚsqlPlusÀïÃ²ËÆ»áÌáʾSQlÓï¾äδ½áÊø,ÕâÊÇÎªÊ²Ã´ÄØ? ûÓÐÎÊÌâµÄ£¬ÎÒÊÔ¹ý£¬Õâ¸öÀïÃæ'%',ÕâÀïµÄ¶ººÅÊÇÖÐÎĵģ¬¿ÉÄÜÊÇÕâÀïµ¼Öµġ£ Ò»ÏÂÊÇÎÒ×öµÄʵÑé SQL> variable s_sex varchar2(10); SQL> select * from (select '1' sex, 'David' name from dual union select '0' sex, 'Janes' name from dual) where sex like decode(:s_sex, null, '%',:s_sex); S NAME - ----- 0 Janes 1 David ÕâÀïûÓж¨Òås_sexµÄÖµ£¬ËùÒÔÌ
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬ -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx ¿´¿´Õâ¸ö ÒýÓà vStream := TMemorySt ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£ ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡. oracle 10g ÓÃps/sql devÔõôҲÁ¬²»ÉÏ. ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË. listener.ora: SID_LIST_LISTENER = (SID_LIST = ......