ÏÖÔÚÒªÇóÊý¾Ý¿âΪ
Oracle 10g(10.2.0.X)
oracle ODBC Driver 10.2.0.3
Ôõô²é¿´·þÎñÆ÷ÉÏoracle10g ¡°oracle odbc driver¡±µÄ°æ±¾
л£¡
ÓÃOUI²é¿´Ñ½¡£
ÒýÓÃ
ÓÃOUI²é¿´Ñ½¡£
ÄÜÏêϸµãÂð£¿
ok£¡
½øÈëÐ¶ÔØ½çÃæ¾ÍÄÜ¿´µ½¡£
лл£¡
......
ÔÚwindows server 2008 X64ϵͳÖа²×°ÁËoracle 11g X64£¬°²×°ºó£¬ÓÃsql developer¿ÉÒÔÁ¬½ÓÉÏÊý¾Ý¿â·þÎñÆ÷£¬Ò²¿ÉÒÔͨ¹ýsql plus½øÐвÙ×÷£¬µ«ÊÇ¿´µ½°²×°ºó£¬Ã»ÓÐisql plus¡£È»ºóÔÙ°²×°pl/sql developer 7.1.5£¬È»ºóÁ¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬ÔòÁ¬½Óʧ°Ü£¬Ìáʾ¾ßÌåÄÚÈݲ»¼ÇµÃÁË£¬ºÃÏóÊÇÖ¸¼àÌýÎÊÌâʲôµÄ£¬ÇëÎÊÓÐûÓÐÄÄλÓÃpl/sql deve ......
×î½üÔÚ¿ª·¢Öз¢ÉúÕâÑùÒ»¼þ¹Öʶù£ºÏÂÃæSQL
SELECT a.product_id,a.unit_id,a.status,a.AMOUNT,
a.AMOUNT AMOUNTMONTH
from tab_a a
(SELECT NVL(SUM(AMOUNT), 0) AS AMOUNT, PRODUCT_ID, UNIT_ID, STATUS
from tab_ ......
oracleÊý¾Ý¿âÖУ¬ÓÃϵͳ¹ÜÀíÔ±µÇ½£¬Ôõô·ÃÎÊÆäËüÓû§´´½¨µÄ±í
select * from other_user.other_table;
ÄÇÔõô²é¿´ÆäËûÓû§´´½¨µÄËùÓбíµÄÃû³ÆÄØ
select table_name from user_tables where user='CARTOON';//Ö¸¶¨Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§ ......
´úÂëÈçÏ£º
¿Í»§¶Ë£º
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
& ......
ÎÒÔÚVS2005Öа²×°ÁËAJAX£¬´´½¨Ò»¸öAJAXÍøÕ¾£¬Ìí¼ÓUpdatePanel1£¬ÔÚUpdatePanel1ÖзÅÒ»¸öButton1£¬¿ÉÒÔÔËÐУ¬
µ«ÎÊÌâÊÇ£ºButton1ûÓÐÌí¼ÓÈκδúÂ룬µ¥»÷Button1Ê±ÍøÒ³³öÏÖ´íÎóÌáʾÈçÏ£ºÇëÎÊÈçºÎ½â¾ö£¿¶àл£¡
ͼƬ¿´²»¼û¡£
ÖØÐÂÌùͼ
ÒýÓÃ
ÊÇÕâ¸ö´íÎóÌáʾ
ÊÇÕâ¸ö´íÎóÌáʾ£º
ÎÒÔÚVS2005Öа ......