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

oracle·µ»Ø²åÈë£É£ÄÎÊÌâ - .NET¼¼Êõ / C#

ÔÚдһ¸öÄ£¿éµÄʱºò£¬²åÈëÊý¾ÝʱÐèÒªÁ¢¼´·µ»ØËù²åÈëµÄ£É£Ä£¬×Ô¶¯ÔöÁ¿ÐòÁм°´¥·¢Æ÷ÒѾ­È«²¿Ð´ºÃ£¬ÔÚÍøÉϲéÁ˸ö·½·¨£º
ÔÚ²åÈëÒ»Ìõ¼Ç¼ºóÂíÉÏÖ´ÐÐÒ»ÏÂÏÂÃæµÄÓï¾ä¼´·µ»Øµ±Ç°²åÈëÊý¾ÝµÄID¡£

$query="select seq_atable.currval from dual";

£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­ÎÊÌâÊÇÕâ¾ä»°ÏêϸҪдÔڣã£ÄÇÀïµÄ£¿£¿$query²»ÊǣʣѣգţңÙÓï·¨Âð£¿
sf ....... 





 

CSDNÓиöºÃ´¦,¾ÍÊÇÈËÆøÍú,Óйý²»ºÃµÄµØ·½,¾ÍÊÇÈËÆø¹ýÍú,³ÁµÃ¿ì...ÎÊÌ⻹û½â¾ö,²»ÄܳÁ°¡,ÄÇλ´ó¸ç°ï°ïæÁË...


»¹ÓÐ ³ÁµÃ¿ì¸ú½áÌùÂÊÓйØ...

oracle ÀïµÄ insert Óï¾äÖ±½Ó¿ÉÒÔ returning ¸Õ²Å²åÈëµÄ×Ö¶Î
Èç¹ûÄãÖ»µ÷ÓõĴ洢¹ý³Ì¾Í¿ÉÒÔ°ÑÕâ¸öÖµ ÉèÖÃΪout


Ö±½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËô

ÒýÓÃ
Ö±½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËô

ÒªÊÇÓû§a¸Õ²åÈëÒ»Ìõ, ÔÚ²éѯÐòÁÐ֮ǰ, Óû§bÓÖ²åÁËÒ»Ìõ
ÇëÎÊ a ²éµ½µÄÐòÁÐÊÇË­µÄ?

ÒýÓÃ
ÒýÓà 6 Â¥ strwangfan µÄ»Ø¸´:
Ö±½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËô

ÒªÊÇÓû§a¸Õ²åÈëÒ»Ìõ, ÔÚ²éѯÐòÁÐ֮ǰ, Óû§bÓÖ²åÁËÒ»Ìõ
ÇëÎÊ a ²éµ½µÄÐòÁÐÊÇË­µÄ?

number = ÐòÁÐ.nextval
INSERTINTO±íVALUES
(number, ×Ö¶ÎÖµ1,×Ö¶ÎÖµ2 ...);
number ¾ÍÊÇÓû§a²åÈëʱµÄÐòÁÐ

number = ÐòÁÐ.nextval
INSERTINTO±íVALUES
(number, ×Ö¶ÎÖµ1,×Ö¶ÎÖµ2 ...);


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ