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

OracleδÌṩÏàÓ¦Çý¶¯

  ±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖÐ¶ÔØµôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
        δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
  È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle   Provider   for   OLE   DB µÄÑ¡ÏÔÚ£¬µ«Êǵã»÷µÄʱºò±¨£º
        Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐòÒѾ­±»ÕýÈ·°²×°
  ¿ÉÄÜÊÇÓÉÓÚ°²×°µÄʱºò¸²¸ÇµôÁËÔ­À´µÄÁ¬½ÓÔì³ÉµÄ¡£ÓÚÊÇ£¬ÕÒµ½OraOledbXX.dll½øÐÐ×¢²á£¬XXÊǰ汾ÐÅÏ¢£¬Äã¿ÉÒÔÖ±½Ó²éѯÄãµçÄÔÉϵÄORACLEĿ¼¿´×Ô¼º°²×°µÄÊÇʲô£¬È»ºóʹÓÃÓï¾ä½øÐÐ×¢²á±ã¿ÉÒÔ£¬ÎÒÊÇ·ÅÔÚDÅÌ£¬°²×°µÄORACLE10gµÄ¡£
        regsvr32 D:\oracle\bin\oraoledb10.dll
Äã¾Í¿ÉÒÔ¿´µ½¿ÉÒÔÓÃÁË£¬Èç¹ûÄã²»ÏëÏÔʾ£¬¿ÉÒÔ·´×¢²á:
        regsvr32 D:\oracle\bin\oraoledb10.dll /u


Ïà¹ØÎĵµ£º

oracle½¨Á¢±í¿Õ¼ä

1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......

Oracle ADF ¼ò½é

ADFÊÇ£¨Application Development Framework£©µÄ¼ò³Æ£¬ËüµÄǰÉíÊÇBC4J¡£ ¹âÌýÕâ¸öÃû×Ö¾ÍÖªµÀËüÊÇÒ»¸öend-to-endµÄ¿ò¼Ü¡£ºÍSpringÒ»ÑùËüÔÚÆóÒµÓ¦Óüܹ¹µÄÿһ¸ö²ã´Î¶¼ÌṩÁËËüµÄÖ§³Ö¡£ADFµÄ¼Ü¹¹ÈçÏÂͼËùʾ£º
ÔÚÿһ²ãADF¶¼ÓÐËüµÄһЩ×é¼þ¡£ÎÒÕâ´ÎÖ÷ÒªÏë½²½²ADFµÄdata binding£¬ÒòΪËü¸ôÀëÁËÒµÎñÂß¼­²ãºÍweb²ã£¬Ê¹µÃÁ½¸ö²ã´Î ......

Oracle RETURNING INTO Ó÷¨Ê¾Àý

The RETURNING INTO clause allows us to return column values for rows affected by DML statements. The following test table is used to demonstrate this clause.
DROP TABLE t1;
DROP SEQUENCE t1_seq;
CREATE TABLE t1 (
id NUMBER(10),
description VARCHAR2(50),
CONSTRAINT t1_pk PRIMARY KEY (id) ......

Oracle»ù´¡ÖªÊ¶

Q1.ÔõÑù´´½¨±í£¿
Q2.ÔõÑùɾ³ý±í£¿
Q3.ÔõÑù´´½¨ÊÓͼ£¿
Q4.ÔõÑùɾ³ýÊÓͼ£¿
Q5.ÔõÑù¸ø±íÌí¼Ó×ֶΣ¿
Q6.ÔõÑùɾ³ý±íÖÐij¸ö×ֶΣ¿
Q7.ÔõÑù¸øÄ³¸ö×Ö¶ÎÌí¼ÓÔ¼Êø£¿
Q8.ÔõÑùÈ¥³ýij¸ö×Ö¶ÎÉϵÄÔ¼Êø£¿
Q9.ÔõÑù¸ø±í¼ÓÉÏÖ÷¼ü£¿
Q10.ÔõÑùɾ³ý±íµÄÖ÷¼ü£¿
Q11.ÔõÑù¸ø±íÌí¼ÓÒ»¸öÍâ¼ü£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ