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
Ïà¹ØÎĵµ£º
C#¿ª·¢WPF/Silverlight¶¯»¼°ÓÎϷϵÁн̳Ì(Game Tutorial)£ºÄ¿Â¼
±¾ÏµÁн̵̳ÄʾÀý´úÂëÏÂÔØ(¸Ðл Òø¹âÖйú Ìṩ×ÊÔ´·ÖÁ÷)£º
µÚÒ»²¿·ÖÔ´Â룺WPFGameTutorial_PartI(1-20½Ú)
µÚ¶þ²¿·ÖÔ´Â룺WPFGameTutorial_PartII(21-26½Ú)
µÚÈý²¿·ÖÔ´Â룺WPFGameTutorial_PartIII(27-30½Ú)
µÚËIJ¿·ÖÔ´Â룺WPFGameTutorial_PartI ......
¡¡¡¡¡¡
һֱûÓÐÍæ¹ýͨ¹ýÃüÁîÔÚDOSÏÂÖ´ÐÐoracleÊý¾Ý¿â,ËäÈ»¸ã¿ª·¢2ÄêÁË£¬»òÐíÕâƪÎÄÕÂдµÃ±È½Ï·ôdz£®µ«»òÐí¶ÔÄÄЩ¸Õ¸ÕѧORACLEµÄÅóÓÑ»¹ÊÇÓÐÒ»¶¨°ïÖúµÄ£®
¡¡¡¡¡¡Í¨¹ýÃüÁîÄܹ»ºÜºÃµÄÖ´ÐдóÅúÁ¿Êý¾Ý½Å±¾£§½Å±¾£®sql£§£®±ÜÃâͨ¹ýPLSQL DeveloperÖ´ÐÐÅúÁ¿Êý¾ÝÔì³ÉµÄËÀ»úÇé¿ö£®
¶þ ......
http://blog.csdn.net/XIAOHUI_LIAO/archive/2007/08/27/1759990.aspx
create materialized view [view_name]
refresh [fast|complete|force]
[
on [commit|demand] |
start with (start_time) next (next_time)
]
as
{´´½¨ÎﻯÊÓͼÓõIJéѯÓï¾ä}
ÒÔÉÏÊÇ ......
ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖƲ¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......