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

OracleÊý¾Ý¿â²Ù×÷µÄ·½·¨

 using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OracleClient;
using System.Data;
namespace OilAddSystem{
    /// <summary>
    /// Ìṩ¶ÔOracleÊý¾Ý¿â²Ù×÷µÄ·½·¨
    /// </summary>
    public class ClassOracle {
        /// <summary>
        /// Êý¾Ý¿âÁ¬½Ó×Ö·û´®
        /// </summary>
        private string strOraConn;
        /// <summary>
        /// ¹¹Ôì·½·¨
        /// </summary>
        /// <param name="strConn">Á¬½Ó×Ö·û´®</param>
        public ClassOracle( string strOraConn )
        {
            this.strOraConn = strOraConn;
        }
        //public ClassOracle()
        //{
        //    this.strOraConn = "user id=" + FormWelcome.OraUserID + ";data source=" + FormWelcome.OraServerName + ";password=" + FormWelcome.OraSecreat;
        //}
        /// <summary>
        /// ·µ»ØÊý¾Ý¿âÁ¬½Ó×Ö·û´®
        /// </summary>
        public string GetConnString()
        {
            return strOraConn;
        }
   &n


Ïà¹ØÎĵµ£º

Oracle ²éѯ¡¢¸üлù±¾²Ù×÷

oracle ĬÈϸôÀëµÈ¼¶ÊÇ£º¶ÁÒÑÌá½»¡£
²éÑ¯Ëø¶¨£¬·ÀÖ¹ÁíÍâÓû§¸üУº
select * from books for update;
µ±Ç°Óû§¸üÐÂÖ®ºó£¬ÁíÍâÓû§¿ÉÒÔ¸ü¸Ä¡£
01¡¢±íÁ¬½Ó
¼Ù¶¨from×Ó¾äÖдÓ×óµ½ÓÒÁ½¸ö±í·Ö±ðΪA£¬B±í¡£
ÄÚÁ¬½Ó£ºÑ¡È¡A¡¢B±íµÄÍêȫƥÅäµÄ¼¯ºÏ£¬Á½±í½»¼¯£º
select empno,ename,emp.deptno A,dept.deptno B,dname from emp ......

Oracle°²È«È«½Ó´¥£¨ÉÏ£©

Ëæ×żÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ­²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеϰÌâ¡£¶øOracleÊý¾Ý¿â¸üÊÇÆ¾½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌØµã£¬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾ­Õ¼¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ­²»ÔÙÊÇÒÔǰµÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔǰÊé±¾ÉÏÄÇЩ“¿ÉÍû² ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

Oracle ÖÐµÄ TO_DATE ºÍ TO_CHAR º¯Êý

oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý

¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢

 
Year(Äê):
yy
two digits(Á½Î»Äê)
08
 
yyy
three digits(ÈýλÄê)
008
 
yyyy
four digits(ËÄλÄê)
2008
 
 
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
 
mon
abbre ......

ORACLE REDO ¡¶ÉîÈëdz³öORACLEµÚÁùÕ¡·

RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ