oracle¶Ë¿ÚÎÊÌâ
ÎÊÌâÊÇÕâÑùµÄ
ÎÒoracle°²×°ÓÐÒ»¶Îʱ¼äÁË£¬dosÉϵÄsqlplusÓÃÁ˺ÜÕý³££¬µ«ÊÇä¯ÀÀÆ÷·ÃÎÊÄÇÀïÓò»ÁË£¬¸Õ¸Õ²âÊÔ
http://localhost:5560²âÊÔ5560¶Ë¿Ú£¬½á¹ûÊÇû±»Õ¼ÓÃ
ËùÒÔSQLplusÎÒ»ú×ÓÉÏÓò»ÁË
ÇëÎÊÊÇÔõÑùÈÃSQLplusÕ¼ÓÃÕâ¸ö¶Ë¿ÚµÄ£¬È»ºóÄØ£¬ÎÒÏëÊÔÒ»ÊÔ¿ÉÊÓ»¯½çÃæ
·þÎñÆô¶¯Ã»£¿
c:>emctl start dbconsole
»òÕßÈ¥·þÎñÀï°ÑÄǸöconsole·þÎñÆô¶¯..
Â¥Ö÷ÊÇÏëÓÃisqlplus°É?
ÆôÏ·þÎñ
$> isqlplusctl start
Á½ÖÖ·½·¨¶¼²»¿ÉÒÔ ÎÒµÄϵͳÊÇvista£¬ÔÚ×°tomcatµÄʱºòÎÒ·¢ÏÖ°²×°·þÎñ¶¼Òª¹ÜÀíÔ±Éí·ÝÔËÐÐcmd
֮ǰ°²×°oracleûÏëÄÇô¶à¹ØÓÚ·þÎñµÄÊ£¬Ò²²»ÖªµÀÄĸö²½Öè³öÎÊÌ⣬·´ÕýÕâ¸ö5560µÄ¶Ë¿ÚµÄ¡°·þÎñ¡±Ã»°²×°¾Í¶ÔÁË
ºÃÏñÓУ¬ÎÒÊÔÒ»ÏÂ
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......