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

¹ØÓÚ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µÄÖµ£¬ËùÒÔÌ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨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×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ