delphiÖÐÓÃadoÁ¬½Óoracle 10g
2009-12-01 00:41:35
֮ǰ°²×°ÁËoracle 10g£¬ºóÀ´ÎªÁËÔÚC#ÀïÃæÁ¬½Óoracle£¬°²×°ÁËODAC£¬Ö®ºóÁ¬½ÓÊý¾Ý¿âʱ£¬ÌîдÊý¾Ý¿â·þÎñÃû£¬×ÜÊÇ»á³ö´í£¬Á¬½Ó²âÊÔÎÞ·¨Í¨¹ý£¬²»ÌîÊý¾Ý¿â·þÎñÃû£¬µ¹»¹¿ÉÒÔͨ¹ýÁ¬½Ó²âÊÔ
½ñÍíÖÕÓڲ鵽ÔÒòÁË¡£¡£¡£
ϵͳÊôÐÔÄÇÀïµÄ»·¾³±äÁ¿£¬pathÕâÀoracleµÄÁ½¸öĬÈÏ·¾¶£º
d:\oracle\product\10.2.0\db_1\bin;
D:\oracle\product\10.2.0\client_1;
µÚÒ»¸öÊÇoracleµÄ¿Í»§¶Ë£¬µÚ¶þ¸öÊÇODACµÄ£¬Á½¸öÔÚpathµÄ˳Ðò£¬²»Äܵߵ¹£¬±ÈÈ磺
D:\oracle\product\10.2.0\client_1;d:\oracle\product\10.2.0\db_1\bin;
¾Í»á³ö´íÀ²……µ÷ÕûÁ½¸öµÄ˳Ðò£¬²âÊÔͨ¹ý
µÚÒ»´ÎÓÃdelphiµÄadoÁ¬½ÓÊý¾Ý¿â£¬Á¬½Ó²½Ö裺
¿Ø¼þadoconnectionË«»÷£¬µã»÷buildÉèÖþÍÐÐÁË£¬Óû§ÊäÈëscott£¬ÃÜÂëtiger£¬
ÔÙ¼ÓÈëadoquery£¬connectionÑ¡adoconnection1£¬sqlÑ¡ÏîÀïÃæÐ´Èësql£¬
¼ÓÈëdatasource£¬datasetΪadoquery1£¬
ÔÚadoquery1µÄsalÊôÐÔÖУ¬¼ÓÈëÒ»Ìõ²âÊÔÓõÄsqlÓï¾ä£¬¾äÄ©²»Ó÷ֺœ£»”²»È»Ö´Ðв»ÁË£¬½Ó×ÅÉèÖÃadoquery1¡¢adoconnection1µÄactiveΪtrue
¼ÓÈëdbgrid£¬datasourceΪdatasource1£¬Ó¦¸Ã¾ÍÄÜ¿´¼ûÁË£¬Õâ¸ö¾ÍÊǼòµ¥µÄʹÊý¾ÝÏÔʾ³öÀ´
Ïà¹ØÎĵµ£º
oracle top N
1.ÔÚORACLEÖÐʵÏÖSELECT TOP N
ÓÉÓÚORACLE²»Ö§³ÖSELECT TOPÓï¾ä£¬ËùÒÔÔÚORACLEÖо³£ÊÇÓÃORDER BY¸úROWNUMµÄ×éºÏÀ´ÊµÏÖSELECT TOP NµÄ²éѯ¡£
¼òµ¥µØËµ£¬ÊµÏÖ·½·¨ÈçÏÂËùʾ£º
SELECT¡¡ÁÐÃû£±£®£®£®ÁÐÃû£î¡¡from
......
ÉñÃØµÄ ORACLE DUAL±í
DUAL ? ÓÐʲôÉñÃØµÄ? µ±ÄãÏëµÃµ½ORACLEϵͳʱ¼ä, ¼ò¼òµ¥µ¥ÇÃÒ»ÐÐSQL¡¡
¡¡¡¡
¡¡¡¡²»¾ÍµÃÁËÂð? ¹ÊŪÐþÐé….¡¡
¡¡¡¡
¡¡¡¡SQL> select sysdate from dual;¡¡
¡¡¡¡
¡¡¡¡SYSDATE¡¡
¡¡¡¡
¡¡¡¡———¡¡
¡¡¡¡
¡¡¡¡28-SEP-03¡ ......
Ò»¡¢×¼±¸¹¤×÷
1.1 ÉèÖÃÖ÷¿âµÄforce loggingģʽ
SQL> alter database force logging;
Database altered.
1.2 ´´½¨Ö÷¿âÃÜÂëÎļþ
$ orapwd file=orapw$ORACLE_SID password=thunis entries=4
1.3 ÅäÖÃÖ÷¿âstandby redo log£¬²¢ÑéÖ¤½á¹û
SQL> alter database add standby logfile group 4('/u01/app/oradata/guar ......
Ò»¡¢ÔÚUnixÏ´´½¨Êý¾Ý¿â
1.È·¶¨Êý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû
¹ØÓÚÊý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû£¬ÎÒ֮ǰÓÐרÃÅÓÃһƪÀ´Ïêϸ½éÉÜ¡£ÕâÀï¾Í²»ÔÙ˵Ã÷ÁË¡£
2.´´½¨²ÎÊýÎļþ
²ÎÊýÎļþºÜÈ·¶¨ÁËÊý¾Ý¿âµÄ×ÜÌå½á¹¹¡£Oracle10gÓÐÁ½ÖÖ²ÎÊýÎļþ£¬Ò»¸öÊÇÎı¾²ÎÊýÎļþ£¬Ò»ÖÖÊÇ·þÎñÆ÷²ÎÊýÎļþ¡£ÔÚ´´½¨Ê ......
//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
create table mytest(myid varchar2(30),myname varchar2(50));
´æ´¢¹ý³ÌΪ£º
create or replace PROCEDURE mytest2(id in varchar2,name in varchar2) as
begin
insert into mytest (myid,myname) valu ......