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

·ÃÎÊoracleÊý¾Ý¿â

1¡£web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2.  c#´úÂëÖÐ
using System.Data.OracleClient;     
public DataTable  GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,DateTime startTime, DateTime endTime)
        {
            DataTable dt = new DataTable();
            OracleConnection conn = new System.Data.OracleClient.OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["LimsConnection"]);
            try
            {
                if (conn.State != ConnectionState.Open)
               conn.Open ();
                string strSql = string.Format(@"select  distinct( s_sampled_date)
                                      from (select row_number() over(order by s_sampled_date desc) rn, t.*
                                              from yzlims.xt_table t
                              &


Ïà¹ØÎĵµ£º

oracle 11g ORA 12514´íÎó£¬ÎҵĽâ¾ö°ì·¨

Ç°ÑÔ:ÍøÉÏÓкܶà½â¾ö°ì·¨£¬É¾listener.oraÒ²ºÃ£¬»¹ÊÇʲôҲºÃ£¬¶¼½â¾ö²»ÁËÎÒÕâ¸öÎÊÌ⣬ÒÀÈ»±¨12514´íÎó£¬ÒÔÏÂÊÇÎÒÖð¸ö³¢ÊÔºó³É¹¦µÄ¼àÌý×Ö·û´®¡£¡£
listener.oraÎļþ£º
# listener.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration too ......

OracleʵÀý¸ÅÄî½âÎö

OracleÊý¾Ý¿â·þÎñÆ÷ÓÉÁ½²¿·Ö×é³É£¬Ò»²¿·ÖÊÇORACLEÊý¾Ý¿â£¬Ò»²¿·ÖÊÇORACLEʵÀý¡£ORACLEÊý¾Ý¿â¾ÍÊÇ´æ´¢ÔÚ´ÅÅÌÉϵÄORACLEÊý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎļþ¡£ÊµÀýÊÇÓÃÀ´¶ÔÊý¾Ý¿â½øÐвÙ×÷¡¢¹ÜÀíµÄ¡£ÊµÀýÓÉһϵÁнø³ÌºÍÄÚ´æ×é³É¡£
Æô¶¯Êý¾Ý¿âµÄʱºòÏÈÔÚÄÚ´æ·ÖÅäÒ»¿éºÜ´óµÄ´æ´¢¿Õ¼ä£¬È»ºóÆô¶¯ORACLEÊý¾Ý¿âÔËÐÐʱÐèÒªµÄһϵÁнø³Ì£¬¼´ ......

OracleÖÐCursor½éÉܺÍʹÓÃ

Ò»  ¸ÅÄî
ÓαêÊÇSQLµÄÒ»¸öÄڴ湤×÷Çø£¬ÓÉϵͳ»òÓû§ÒÔ±äÁ¿µÄÐÎʽ¶¨Òå¡£ÓαêµÄ×÷ÓþÍÊÇÓÃÓÚÁÙʱ´æ´¢´ÓÊý¾Ý¿âÖÐÌáÈ¡µÄÊý¾Ý¿é¡£ÔÚijЩÇé¿öÏ£¬ÐèÒª°ÑÊý¾Ý´Ó´æ·ÅÔÚ´ÅÅ̵ıíÖе÷µ½¼ÆËã»úÄÚ´æÖнøÐд¦Àí£¬×îºó½«´¦Àí½á¹ûÏÔʾ³öÀ´»ò×îÖÕд»ØÊý¾Ý¿â¡£ÕâÑùÊý¾Ý´¦ÀíµÄËٶȲŻáÌá¸ß£¬·ñÔòƵ·±µÄ´ÅÅÌÊý¾Ý½»»»»á½µµÍЧÂÊ¡£
¶þ&n ......

ORACLEÊý¾Ý×Öµä

²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
 SQL>select username,default_tablespace from user_users;
        ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
        SQL>select * from user_role_privs;
        ²é¿´µ±Ç°Óû§µÄÏµÍ³È ......

oracle Óαê

1.       Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2.       ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐÇ°½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡£
3.      ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ