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

C# Á¬½ÓOracleÊý¾Ý¿â


C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®
http://developer.51cto.com
 2009-08-20 17:55  ØýÃû  °Ù¶È¿Õ¼ä  ÎÒÒªÆÀÂÛ(
0
)
C#Á¬½ÓOracleÊý¾Ý¿âÒÔ¼°C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®µÈÄÚÈݽ«ÔÚ±¾ÎÄÖÐÕ¹ÏÖ£¬Ï£Íû±¾ÎÄÄܶԴó¼ÒÁ˽âC#Á¬½ÓÊý¾Ý¿âÓÐËù°ïÖú¡£
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®£¨²éѯÊý¾Ý£©
using
 System;  
using
 System.Collections.Generic;  
using
 System.ComponentModel  
using
 System.Data.OracleClient;;
//ÕâÐкÍÏÂÒ»Ðж¼ÒªÏÈÔÚÒýÓÃÖÐÌî¼Ósystem.data.oracleclient
 
using
 System.Data;  
using
 System.Drawing;  
using
 System.Text;  
using
 System.Windows.Forms;  
 
namespace
 WindowsApplication1  
{  
    
public
 partial 
class
 Form1 : Form  
    {  
        
public
 Form1()  
        {  
            InitializeComponent();  
        }  
          
        
private
 
void
 button1_Click(
object
 sender, EventArgs e)  
        {
 
            #region ´Óregionµ½endregionÊÇÊÖ¹¤Ð´µÄ¡£±ðµÄ¶¼ÊÇϵͳ×Ô¶¯Éú³ÉµÄ
 
            
string
 constring = 
"data source=wzd;user=wzd;password=wzd;"
;
//¶¨ÒåÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®
 
            OracleConnection conn = 
new
 OracleConnection(constring);
//½øÐÐÁ¬½Ó
 
        &


Ïà¹ØÎĵµ£º

¹ØÓÚOracle½ø³Ì½á¹¹¼°ºǫ́½ø³Ì¼ò½é


½ø³Ì½á¹¹
½ø³ÌÊDzÙ×÷ϵͳÖеÄÒ»ÖÖ»úÖÆ£¬Ëü¿ÉÖ´ÐÐһϵÁеIJÙ×÷²½¡£ÔÚÓÐЩ²Ù×÷ϵͳÖÐʹÓÃ×÷Òµ(JOB)»òÈÎÎñ(TASK)µÄÊõÓï¡£Ò»¸ö½ø³Ìͨ³£ÓÐËü×Ô¼ºµÄרÓÃ´æ´¢Çø¡£ORACLE½ø³ÌµÄÌåϵ½á¹¹Éè¼ÆÊ¹ÐÔÄÜ×î´ó¡£
ORACLEʵÀýÓÐÁ½ÖÖÀàÐÍ£ºµ¥½ø³ÌʵÀýºÍ¶à½ø³ÌʵÀý¡£
µ¥½ø³ÌORACLE£¨ÓֳƵ¥ÓÃORACLE£©ÊÇÒ»ÖÖÊý¾Ý¿âϵͳ£¬Ò»¸ö½ø³ÌÖ´ÐÐÈ«²¿ORA ......

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ                              
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîÈ¨Í ......

Oracle/PLSQL: Lpad and Rpad Function

Oracle/PLSQL: Lpad Function£º
http://www.techonthenet.com/oracle/functions/lpad.php
RPAD and LPAD [Oracle SQL]£º
http://www.adp-gmbh.ch/ora/sql/rpad.html
ÒýÊö
In Oracle/PLSQL, the lpad function pads the left-side of a string with a specific set of characters.
The syntax for the lpad funct ......

MS SQL 2005Á´½Ó·þÎñÆ÷Á¬½ÓÔ¶³ÌORACLEÈ«¹ý³Ì

µÚÒ»²½:ÏÂÔØ°²×°Oracle 10g Release 2 ¿Í»§¶ËÈí¼þ,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
ÏÂÔØºó°²×°
 
 
 
µÚ¶þ²½:ÏÂÔØ°²×°Oracle ODAC,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/other/ole-oo4o/ODAC1020221.exe
 
µÚÈý²½: ÖØÆôMS SQ ......

ÈÝÒ׺öÊÓµÄoracleº¯ÊýÎÊÌâ Êý¾ÝÀàÐÍ

×î½üʼÖÕ±»Êý¾Ý¿âÎÊÌâÀ§ÈÅ£¬³öÓÚÏîĿӦÓÃÔ­Òò£¬¶¨ÒåÁËһЩoracle×Ô¶¨Ò庯Êý(User Defined function),ÓÃÓÚÔÚʵ¼Ê²éѯSQLÓï¾äÖе÷Óã¬Ä¿µÄÊÇΪÁ˼ò»¯SQLÓï¾äµÄ¸´ÔÓ¶È¡£Êµ¼ÊʹÓÃÖз¢ÏÖ£¬ÕâЩº¯Êý»á³öÏÖÒ»¸öĪÃûÆæÃîµÄÎÊÌ⣬ÏÈÉÏʵÀý:
CREATE OR REPLACE FUNCTION "GETSINGLEUSER" --·µ»ØµÚÒ»¸ö×Ö·û´®
(sStr in nvarchar2)
r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ