-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
DELIMITER $$
CREATE DEFINER=`root`@`` PROCEDURE `new_routine`(
_startMonth int,
_En ......
³õѧ.net,Ҳû½Ó´¥¹ýoracle,²»ÖªµÀ¸ÃÈçºÎÏÂÊÖ¡£Íû¸ßÈËÖ¸µã¡£
ADO.NET
System.Data.OracleClient
OracleConnection
OraCommand
OraDataAdapter
ÐèÒªµÄÃü¿Õ¼ä
using System;
using System.Data;
using System.Data.OracleClient;
ORACLEµÄ°²×°ÅäÖá£È¥Ñ§Ï°Ñ§Ï°
http://oracle.chinaitlab.com/List_2.ht ......
xpϵͳ¿ÉÒÔ°²×°oracleÂð
9i ºÍ10gµÄ¶¼ÄÜ°²×°Âð
Õâ¸öÎʵģ¬Ó¦¸Ã¿ÉÒÔ°É¡£¡£¡£
¿ÉÒԵģ¬µ«Óû§Ãû²»ÄÜÊÇÖÐÎÄ
µ±È»¿ÉÒÔ, µ«ÊDz»ÄÜÊÇhome edition(¼ÒÍ¥°æ±¾µÄ), ǧÍò×¢Òâ
9i, 10g, 11gµÄ¶¼¿ÉÒÔ°²×°, ÎÒÏÖÔÚ¾ÍÓÃ×ÅÄØ!
ÒýÓÃ
µ±È»¿ÉÒÔ, µ«ÊDz»ÄÜÊÇhome edition(¼ÒÍ¥°æ±¾µÄ), ǧÍò×¢Òâ
9i, 10g, 11gµÄ¶¼¿ÉÒÔ°²×°, ÎÒÏ ......
´ó¼Ò·¢±íÒ»ÏÂ×Ô¼ºµÄÒâ¼û°¡£¡
1 ¿ªÔ´ÐÔ²»Ò»Ñù
2 Êý¾Ý¿âÈÝÁ¿ÐÔÄܽç±ð²»Äܲ¢ÂÛ
3 ¹«Ë¾¹æÄ£ÍêÈ«²»Ò»Ñù
OracleÄ¿Ç°ÊǹØϵÊý¾Ý¿âÖв¢·¢ÐÔÄÜ×îºÃµÄ£¬Ò²µÃµ½¹«ÖÚÈÏ¿É¡£
Mysql³äÆäÁ¿¿ÉÒÔËã¸öÖÐÐÍÊý¾Ý¿â
oracleÊÇÃæÏò´óÖÐÐÍÆóÒµÓ¦ÓõÄÊý¾Ý¿âϵͳ£¬¾ßÓнϸߺͽÏÍêÉƵÄÐÔÄÜ£¬µ«¶ÔÊý¾Ý¿â¹ÜÀíÔ±¾ßÓнϸߵÄÒªÇó¡£Ö ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈÇ°ÓõÄ10gÒ²Óöµ½ÀàËƵÄÎÊÌâ
ʹÓÃmicrosoft ole db provider for oracleʱÏÔʾµÄ·þÎñÆ÷Ãû³ÆÊÇ×Ô¶¨ÒåµÄÂð£¿ÎªÊ²Ã´ÎҵĻ¹ÊDZ¨´í
Çë´ó¼Ò°ï°ïæлл
°ï¶¥£¡
Ö± ......
±í½á¹¹ÓëÐÅÏ¢ÈçÏ£º
CREATE TABLE TB_ITEM_INFO(
item_name varchar2(20),
item_data number(10,4),
constraint PK_ITEM_INFO primary key (item_name)
);
item_name(primary_key) item_data
value1 1.0
value2 2.0
value3 ......