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
Ïà¹ØÎĵµ£º
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,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......
ADFÊÇ£¨Application Development Framework£©µÄ¼ò³Æ£¬ËüµÄǰÉíÊÇBC4J¡£ ¹âÌýÕâ¸öÃû×Ö¾ÍÖªµÀËüÊÇÒ»¸öend-to-endµÄ¿ò¼Ü¡£ºÍSpringÒ»ÑùËüÔÚÆóÒµÓ¦Óüܹ¹µÄÿһ¸ö²ã´Î¶¼ÌṩÁËËüµÄÖ§³Ö¡£ADFµÄ¼Ü¹¹ÈçÏÂͼËùʾ£º
ÔÚÿһ²ãADF¶¼ÓÐËüµÄһЩ×é¼þ¡£ÎÒÕâ´ÎÖ÷ÒªÏë½²½²ADFµÄdata binding£¬ÒòΪËü¸ôÀëÁËÒµÎñÂß¼²ãºÍweb²ã£¬Ê¹µÃÁ½¸ö²ã´Î ......
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)
......
Q1.ÔõÑù´´½¨±í£¿
Q2.ÔõÑùɾ³ý±í£¿
Q3.ÔõÑù´´½¨ÊÓͼ£¿
Q4.ÔõÑùɾ³ýÊÓͼ£¿
Q5.ÔõÑù¸ø±íÌí¼Ó×ֶΣ¿
Q6.ÔõÑùɾ³ý±íÖÐij¸ö×ֶΣ¿
Q7.ÔõÑù¸øÄ³¸ö×Ö¶ÎÌí¼ÓÔ¼Êø£¿
Q8.ÔõÑùÈ¥³ýij¸ö×Ö¶ÎÉϵÄÔ¼Êø£¿
Q9.ÔõÑù¸ø±í¼ÓÉÏÖ÷¼ü£¿
Q10.ÔõÑùɾ³ý±íµÄÖ÷¼ü£¿
Q11.ÔõÑù¸ø±íÌí¼ÓÒ»¸öÍâ¼ü£¿
......