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

oracle¶Ë¿ÚÎÊÌâ

ÎÊÌâÊÇÕâÑùµÄ
ÎÒoracle°²×°ÓÐÒ»¶Îʱ¼äÁË£¬dosÉϵÄsqlplusÓÃÁ˺ÜÕý³££¬µ«ÊÇä¯ÀÀÆ÷·ÃÎÊÄÇÀïÓò»ÁË£¬¸Õ¸Õ²âÊÔ
http://localhost:5560²âÊÔ5560¶Ë¿Ú£¬½á¹ûÊÇû±»Õ¼ÓÃ

ËùÒÔSQLplusÎÒ»ú×ÓÉÏÓò»ÁË

ÇëÎÊÊÇÔõÑùÈÃSQLplusÕ¼ÓÃÕâ¸ö¶Ë¿ÚµÄ£¬È»ºóÄØ£¬ÎÒÏëÊÔÒ»ÊÔ¿ÉÊÓ»¯½çÃæ

·þÎñÆô¶¯Ã»£¿

c:>emctl start dbconsole

»òÕßÈ¥·þÎñÀï°ÑÄǸöconsole·þÎñÆô¶¯..

Â¥Ö÷ÊÇÏëÓÃisqlplus°É?

ÆôÏ·þÎñ
$> isqlplusctl start


Á½ÖÖ·½·¨¶¼²»¿ÉÒÔ  ÎÒµÄϵͳÊÇvista£¬ÔÚ×°tomcatµÄʱºòÎÒ·¢ÏÖ°²×°·þÎñ¶¼Òª¹ÜÀíÔ±Éí·ÝÔËÐÐcmd


֮ǰ°²×°oracleûÏëÄÇô¶à¹ØÓÚ·þÎñµÄÊ£¬Ò²²»ÖªµÀÄĸö²½Öè³öÎÊÌ⣬·´ÕýÕâ¸ö5560µÄ¶Ë¿ÚµÄ¡°·þÎñ¡±Ã»°²×°¾Í¶ÔÁË

ºÃÏñÓУ¬ÎÒÊÔÒ»ÏÂ


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ