ÎÒµÄOracle XeÕâ¸öÈí¼þ²»ÄÜÓÃÁË£¬È»ºóÐ¶ÔØÁË£¬ÎÒÖØÐ°²×°£¬¿ÉÊǵçÄÔÌáʾϵͳÉÏÓÐÁË´Ë·þÎñ£¬ÕâÊÇÔõô»ØÊ°¡£¿
Ð¶ÔØ²»ÍêÈ«£¿
²»Ã÷ ÓÑÇéUP
ÒýÓÃ
ÎÒµÄOracle XeÕâ¸öÈí¼þ²»ÄÜÓÃÁË£¬È»ºóÐ¶ÔØÁË£¬ÎÒÖØÐ°²×°£¬¿ÉÊǵçÄÔÌáʾϵͳÉÏÓÐÁË´Ë·þÎñ£¬ÕâÊÇÔõô»ØÊ°¡£¿
Ð¶ÔØ²»ÍêÈ«,ÐèÒªµ½×¢²á±íÖÐȥɾ³ýÈçϵÄÄÚÈÝ.
1.
hkey_l ......
ͻȻÔÚд³ÌÐòµÄʱºò·¢ÏÖÁ˸öСÎÊÌ⣬»·¾³ÎªOracle10g,¹¤¾ßPL\SQL DEVELOPER7.1.5 ,дһ¸ö´æ´¢¹ý³Ì
ÀýÈ磺
ÓÐÒ»¸ö±äÁ¿ V_I IN VARCHAR2(4000);
ÏÂÃæÎÒÇó³ö´«ÈëµÄ×Ö·û´®µÄ³¤¶È
CREATE OR REPLACE PROCEDURE TEST_LENGTH(
V_I varchar2--´«Èë²ÎÊý
) IS
V_I_STR varchar2(4000);--´«Èë²ÎÊý
v_r number(8);--¼Æ ......
Õý³£µÄoracleÊý¾Ý²éѯÊÇSQL code:
select * from ta where rq>='30-mar-10' and rq<='4-apr-10'
µ«ÊÇÔÚC#Ìí¼Óʱ¼ä¿Ø¼þdateTimePicker1£¬
dateTimePicker4.Value.ToShortDateString()
ËûµÄʱ¼ä¸ñʽÊÇ¡®2010-3-30¡¯ÕâÑùµÄ£¬ÈçºÎ°Ñת»¯³Éoracle²éѯµÄ¸ñÊ½ÄØ
Èç¹ûûÓÐÏֳɵĺ¯Êý£¬Ö»ºÃ×Ô¼ºÐ´Ò»¸öº¯ÊýÁË
ÓÃstring.F ......
rt
http://download.csdn.net/source/1930911
ÒýÓÃ
ÏÖÔڵĺ¢×ÓÔ½À´Ô½»áÒÂÀ´ÉìÊÖÁË£¬µ½ Oracle ÍøÕ¾ÉÏÈ¥ÕÒÕÒ²»¾ÍÓÐÁËô£¿
http://www.oracle.com/technology/global/cn/software/tech/java/sqlj_jdbc/index.html
½¨ÒéʹÓÃ×îеÄÇý¶¯£¬JDBC Çý¶¯Ò²ÓмæÈÝÐÔ£¬¾ßÌåµÄ¼æÈÝÐÔ¿ÉÒÔ¿´Õâ¸öÒ³Ãæ£º
http://www.oracle.com ......
ÎÒÓÃc#.netÏë°ÑͼƬֱ½Ó´æ´¢ÔÚoracleÊý¾Ý¿âÖУ¬ÏÖÔÚ¶Áд²Ù×÷²»ÖªµÀ¸ÃÔõôдÁË£¬
»¹ÓÐÏÖÔÚÔÚSqlServer ÖÐÓÐһЩÊý¾ÝÒ²ÊÇͼƬÀàÐÍ£¨image£©µÄÐèÒªµ¼µ½ oracleÊý¾Ý¿âÖУ¬
Çë¸÷λ¸ßÊÖ°ïæ
1.ÔÚoracleÊý¾Ý¿â½¨Á¢Ò»Ìõº¬blob×ֶεıí
2.ÔÚ±íÖвåÈëÒ»Ìõ¿ÕµÄ¼Ç¼,blob×Ö¶ÎÒª¸ø³öÒýÈëµã£¬ÓÃempty_blob()
3.ÓÃÁ÷¶ÔÕâ¸ö×Ö¶ÎÀ´½øÐж ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²»Óþ³£Í¶ÈëѧϰÐµĶ«Î÷ÉÏ¡£»¹ÓоÍÊÇ´ýÓö·½Ãæ ¸Ð¾õÊý¾Ý¿âÒª¸ßÓÚÈí¼þ¿ª·¢¡£
ÓÐÁ˽âÊý¾Ý¿âµÄÅóÓѸøµã¿´·¨ Êý ......