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

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) values(id, name);
end;
/
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´úÂ룺
package com.hyq.src;
import java.sql.*;
import java.sql.ResultSet;
public class TestProcedureOne {
  public TestProcedureOne() {
  }
  public static void main(String[] args ){
    String driver = "oracle.jdbc.driver.OracleDriver";
    String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:HUAYU";
    Statement stmt = null;
    ResultSet rs = null;
    Connection conn = null;
    //CallableStatement:ÓÃÓÚÈ¥µ÷Óô洢¹ý³Ì
    CallableStatement cstmt = null;
    try {
      Class.forName(driver);
      conn =  DriverManager.getConnection(strUrl, "scott", "tiger");
      CallableStatement proc = null;
      proc = conn.prepareCall("{ call mytest2(?,?)}");
 //¸ø?ºÅ¸³Öµ
      proc.setString(1, "100");
      proc.setString(2, "user1");
 //Ö´Ðд洢¹ý³Ì
      proc.execute();
    }
    catch (Exception ex2) {
 ex2.printStackTrace();    
    }
    finally{
      //¹Ø±Õ×ÊÔ´..
    }
  }
}
µ±È»ÁË£¬Õâ¾ÍÏÈÒªÇóÒª½¨ÕűíTESTTB,ÀïÃæÁ½¸ö×ֶΣ¨I_ID£¬I_NAME£©¡£
¶þ£ºÓзµ»ØÖµµÄ´æ´¢¹ý³Ì£¨·ÇÁÐ±í£©
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE mytest3(id in varchar2,name out varchar2)  as
BE


Ïà¹ØÎĵµ£º

javaÈëÃÅ

 Javaѧϰ´ÓÈëÃŵ½¾«Í¨ 
Ò»¡¢ JDK (Java Development Kit) 
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......

ÉñÃØµÄ 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ÓÐÁ½ÖÖ²ÎÊýÎļþ£¬Ò»¸öÊÇÎı¾²ÎÊýÎļþ£¬Ò»ÖÖÊÇ·þÎñÆ÷²ÎÊýÎļþ¡£ÔÚ´´½¨Ê ......

OracleÈçºÎ¸Ä±älistenerµÄ¶Ë¿ÚºÅ (Linux)

ÔÚLinuxÉÏ°²×°oracleµÄʱºò²»Ð¡ÐÄ°²×°ÁËÁ½´Îlistener, ¸ãµÃlistenerµÄ¶Ë¿ÚºÅ±ä³ÉÁË1522¶ø²»ÊÇȱʡµÄ1521, ¿Í»§¶ËÁ¬Á˺þö¼Ã»ÓÐÁ¬½ÓÉÏ£¬×îºó²Å·¢ÏÖÊÇlistenerµÄ¶Ë¿ÚºÅ²»¶Ô¡£Ò»ÏÂÊÇÎҸıälistener¶Ë¿ÚºÅµÄ²½Ö裺
1. Ê×ÏÈÐèҪֹͣlistener, ʹÓÃÃüÁîlsnrctl stop
2. listenerÍ£Ö¹ÒԺ󣬵½ÄãµÄ$ORACLE_HOME/network/adminÏÂÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ