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

oracleÓë.netʱºò±¨´í

ÎÒÈ·¶¨£¬ÎÒoracleÀïÃæµÄÅäÖö¼ÊÇÕýÈ·µÄ£¨ÒòΪÎÒÓÃpb£¬plsql¶¼¿ÉÒÔÁ¬½ÓoracleÊý¾Ý¿â£©
µ«ÊÇÎÒÏë.netÀïÃæÁ¬½ÓoracleÊý¾Ý¿âµÄʱºò¾ÍÊDZ¨´í
ÎÒµÄÁ¬½ÓÎļþÊÇÕâÑùдÁ˵ģºProvider=OraOLEDB.Oracle;User ID=hwuser;Password=hw2001;Data Source=ora8;
ÎÒÊÇÕâÑùЩµÄ·ÃÎÊÊý¾Ý¿â·½·¨

static string oraConStr = ConfigurationSettings.AppSettings["oreConnection"];

  /**
  * Êý¾Ý¿âÖвéѯÓï¾äÖ´ÐÐ
  */ 
  public DataSet QueryInfo(string sql)
  {
  DataSet ds = new DataSet ();
  OleDbConnection olecon = new OleDbConnection(oraConStr);
  OleDbDataAdapter oledba = new OleDbDataAdapter(sql, olecon);
  oledba.Fill(ds);
  return ds;
  }
   
µ«ÊÇÔÚÎÒÖ´ÐÐ oledba.Fill(ds);µÄʱºò¾Í±¨´í:Óû§´úÂëδ´¦Àí£ºInvalidOperationException¡°Î´ÔÚ±¾µØ¼ÆËã»úÉÏ×¢²á¡°OraOLEDB.Oracle¡±Ìṩ³ÌÐò¡£¡±
Çë¸ßÊÖ°ïÖúÒ»ÏÂÈü£¬Ð»ÁË£¡£¡£¡

oracle¿Í»§¶Ë×°ÁËû£¿»¹ÓÐtnsname.oraÓÐûÓÐÕýÈ·µÄ·ÅÖÃÔÚÖ¸¶¨µÄλÖã¿

Data   Source   =   (DESCRIPTION   =   (ADDRESS_LIST   =   (ADDRESS   =(PROTOCOL   =   TCP)(HOST   =·þÎñÆ÷Ãû)(PORT   =   ¶Ë¿ÚºÅ)))(CONNECT_DATA   =   (SERVER   =   DEDICATED)(SERVICE_NAME   =   Êý¾Ý¿âÃû)));   User   Id   =   Óû§Ãû; &nbs


Ïà¹ØÎÊ´ð£º

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ