´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£
ÆäÖÐÊý¾Ý¿âÊÇÅäÖúÃÁ˵ģ¬ÒòΪÓÃSQL developer¿ÉÒÔ·ÃÎʵ½Êý¾Ý¿â
»¹Çë´óÏÀÃÇ°ïæ½â¾öÏÂÎÊÌâ
......
ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡
Error while performing database login with the Oracle driver:
Io exception: The Network Adapter could not establish the connection
---------------------
ÔÚEcl ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬£º
ÔÝÓÃ10¾ÍÐÐÁËÆäʵ¶¼Ò»Ñù¡£ÎÒÏÖÔÚÓõÄlombozÖ»Ö§³Öµ½9£¬ÎÒµÄoracle°æ±¾ÊÇ10£¬Á¬½ÓÕÕ³£ÔËÐС£
лР......
'TRUNC(SYSDATE + 1)'
ÊÇʲôÒâ˼¡£¡£¡£¡£ÁíÍâDBMSJOB_SUBMIT() Óм¸¸ö²ÎÊý£¬¸÷´ú±íʲôÒâ˼£¿
TRUNCº¯ÊýΪָ¶¨ÔªËضø½ØÈ¥µÄÈÕÆÚÖµ¡£
Æä¾ßÌåµÄÓï·¨¸ñʽÈçÏ£º
TRUNC£¨date[,fmt]£©
ÆäÖУº
&n ......
select A_NM || '----' || B_NM
from (select distinct a.sttn_nm a_nm, b.sttn_nm b_nm
from tb_sttn a, tb_sttn b
where a.sttn_id < b.sttn_id)
ÕâÌõSQLÓï¾ä²éѯºóÔÚ½çÃæÉÏÏÔʾµÄÊÇ A_NM--/--/B_NM£¬²»ÖªµÀÔõô½â¾ ......
ÒªÕÒרÃÅ×öoracle¿ª·¢µÄ£¬ÒªÕÆÎÕʲôÑùµÄ֪ʶ¡£
ÇëÏêϸ˵һÏ¡£·Ç³£¸Ðл¡£
¶¥Ò»Ï£¬ÎÒÒ²Ïë×öoracle¿ª·¢
ÎÒ¾õµÃ£¬´óÌåÉÏÐèҪʲô֪ʶ£¬¿´¼¸ÔòÕÐƸ¹ã¸æ¾Í²î²»¶àÁ˽â¸ö´ó¸Å
sql,pl/sqlÕâЩ»ù±¾¹¦
¿ª·¢µÄһЩËã·¨
¾Ñé
×îºÃ»¹»ájava
´óÖÂÕâЩ
·Ö¼¸Öֵģ¬
Èç¹ûÊÇ×öoracleÓ¦Óÿª·¢£¬ÕÆÎÕpl/sqlÊÇ»ù±¾ ......