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

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 ºÍ OracleÖеÄlimitÎÊÌâ½â¾ö·½°¸

oracle top N
1.ÔÚORACLEÖÐʵÏÖSELECT TOP N
   ÓÉÓÚORACLE²»Ö§³ÖSELECT TOPÓï¾ä£¬ËùÒÔÔÚORACLEÖо­³£ÊÇÓÃORDER BY¸úROWNUMµÄ×éºÏÀ´ÊµÏÖSELECT TOP NµÄ²éѯ¡£
¼òµ¥µØËµ£¬ÊµÏÖ·½·¨ÈçÏÂËùʾ£º
      SELECT¡¡ÁÐÃû£±£®£®£®ÁÐÃû£î¡¡from
        ......

ÉñÃØµÄ ORACLE DUAL±í


 
ÉñÃØµÄ ORACLE DUAL±í
 
     DUAL ? ÓÐʲôÉñÃØµÄ? µ±ÄãÏëµÃµ½ORACLEϵͳʱ¼ä, ¼ò¼òµ¥µ¥ÇÃÒ»ÐÐSQL¡¡
¡¡¡¡
¡¡¡¡²»¾ÍµÃÁËÂð? ¹ÊŪÐþÐé….¡¡
¡¡¡¡
¡¡¡¡SQL> select sysdate from dual;¡¡
¡¡¡¡
¡¡¡¡SYSDATE¡¡
¡¡¡¡
¡¡¡¡———¡¡
¡¡¡¡
¡¡¡¡28-SEP-03¡ ......

Oracle dataguardÅäÖÃStep by Step

Ò»¡¢×¼±¸¹¤×÷
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 ......

CMDÏ´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©

Ò»¡¢ÔÚUnixÏ´´½¨Êý¾Ý¿â
1.È·¶¨Êý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû
¹ØÓÚÊý¾Ý¿âÃû¡¢Êý¾Ý¿âʵÀýÃûºÍ·þÎñÃû£¬ÎÒ֮ǰÓÐרÃÅÓÃһƪÀ´Ïêϸ½éÉÜ¡£ÕâÀï¾Í²»ÔÙ˵Ã÷ÁË¡£
2.´´½¨²ÎÊýÎļþ
     ²ÎÊýÎļþºÜÈ·¶¨ÁËÊý¾Ý¿âµÄ×ÜÌå½á¹¹¡£Oracle10gÓÐÁ½ÖÖ²ÎÊýÎļþ£¬Ò»¸öÊÇÎı¾²ÎÊýÎļþ£¬Ò»ÖÖÊÇ·þÎñÆ÷²ÎÊýÎļþ¡£ÔÚ´´½¨Ê ......

javaµ÷ÓÃoracle´æ´¢¹ý³Ì

//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ