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

C# µ÷ÓÃOracle ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ ʵÀý

1. ÔÚoracle Ï´´½¨±í
     t_user(
        ID varchar(20),
        Name varchar(20)
       )
 2.  Ìí¼ÓÊý¾Ý 
           '1' , 'ÕÅÈý'
           '2' , 'ÀîËÄ'
 3. ´´½¨°ü²¢ÇÒ¶¨Òå±äÁ¿ºÍÉùÃ÷´æ´¢¹ý³Ì
     CREATE OR REPLACE PACKAGE pkg_user AS
        --¶¨Òå·µ»ØÖµ£¨ÓαêÀàÐÍ£©
      TYPE myrctype IS REF CURSOR;
         --¶¨Òå²éѯ¹ý³Ì
      PROCEDURE sp_userlist (cur_result OUT myrctype);
      END pkg_user;
 4.´´½¨´æ´¢¹ý³Ì sp_userlist
     CREATE OR REPLACE PACKAGE BODY "PKG_USER" AS
       --²éѯ¹ý³Ì
     PROCEDURE sp_userlist(cur_result OUT myrctype)
     IS
        sqlstr   VARCHAR2 (500);
     BEGIN
          OPEN cur_result FOR
             select * from t_user ;
    END sp_userlist ;
    END pkg_user;
5. C# ÖоͿÉÒÔµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÁË.
    ÔÚOracle helper ÖÐÌí¼Ó
   
      public static void RunSql(string SqlString, CommandType cmdType, out DataTable dt)
        {
         
            OracleCommand cmd = CreateSqlCommand(SqlString, cmdType);
            OracleDataAdapter da;
     &n


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracleÊý¾Ý¿âͨ¹ýÃüÁîµÇ¼£¬Ö´ÐÐSQLÓï¾ä

¡¡¡¡¡¡
        һֱûÓÐÍæ¹ýͨ¹ýÃüÁîÔÚDOSÏÂÖ´ÐÐoracleÊý¾Ý¿â,ËäÈ»¸ã¿ª·¢2ÄêÁË£¬»òÐíÕâÆªÎÄÕÂдµÃ±È½Ï·ôdz£®µ«»òÐí¶ÔÄÄЩ¸Õ¸ÕѧORACLEµÄÅóÓÑ»¹ÊÇÓÐÒ»¶¨°ïÖúµÄ£®
¡¡¡¡¡¡Í¨¹ýÃüÁîÄܹ»ºÜºÃµÄÖ´ÐдóÅúÁ¿Êý¾Ý½Å±¾£§½Å±¾£®sql£§£®±ÜÃâͨ¹ýPLSQL DeveloperÖ´ÐÐÅúÁ¿Êý¾ÝÔì³ÉµÄËÀ»úÇé¿ö£®
¶þ ......

Oracle + Sun: Java Strategy

Oracle and Sun
http://www.oracle.com/events/productstrategy/index.html
Oracle + Sun: Java Strategy
   http://oracle.com.edgesuite.net/ivt/4000/8104/9236/12630/lobby_external_flash_clean_480x360/default.htm 
Oracle + Sun: Java Strategy
  ......

Unix For Oracle DBA

     ¶ÔÓÚ¸Õ½Ó´¥unixµÄÈ˶øÑÔ,ÀûÓùܵÀ½«¸÷ÖÖÃüÁî×éºÏÔÚÒ»ÆðÀ´ÊµÏÖij¸ö¹¦ÄÜ,ÊDZȽÏÄÑÊÊÓ¦µÄÒ»¼þÊÂÇé,ÏÂÃæ£¬ÎÒ¾ÍÓÃÒ»¸ö¾ßÌåµÄÀý×Ó,Ïêϸ½²ÏÂ×ÅÀïÃæµÄÓ÷¨ºÍ˼·.¿´¿´µ½µ×ÎÒÃǰÑÃüÁî¶¼°óÔÚÒ»Æð,unix¶¼×öÁËʲô.
     ¾ÍÓÃÒ»¸öoracle¹ÜÀíÖÐ,¿ÉÄÜ»áÓöµ½µÄÀý×Ó°É,Èç¹ûoracle¹ÒÁË£¬ ......

ORACLEÎﻯÊÓͼ ¶¨Î»µ¼ÖÂÎﻯÊÓͼÎÞ·¨¿ìËÙˢеÄÔ­Òò


ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ