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

oracle link

Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
     ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
       ´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
        1¡¢ÒѾ­ÅäÖñ¾µØ·þÎñ
        create public database
link fwq12 connect to fzept
identified by neu using 'fjept'       CREATE DATABASE LINKÊý¾Ý¿âÁ´½ÓÃûCONNECT TO Óû§Ãû IDENTIFIED BY ÃÜÂë USING ‘±¾µØÅäÖõÄÊý¾ÝµÄʵÀýÃû’;
     2¡¢Î´ÅäÖñ¾µØ·þÎñ
create database link linkfwq
  connect to fzept identified by neu
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = fjept)
    )
  )';
host£½Êý¾Ý¿âµÄipµØÖ·£¬service_name£½Êý¾Ý¿âµÄssid¡£
       ÆäʵÁ½ÖÖ·½·¨ÅäÖÃdblinkÊDz¶àµÄ£¬ÎÒ¸öÈ˸оõ»¹ÊǵڶþÖÖ·½·¨±È½ÏºÃ£¬ÕâÑù²»Êܱ¾µØ·þÎñµÄÓ°Ïì¡£
       Êý¾Ý¿âÁ¬½Ó×Ö·û´®¿ÉÒÔÓÃNET8 EASY CONFIG»òÕßÖ±½ÓÐÞ¸ÄTNSNAMES.ORAÀﶨÒå.
       Êý¾Ý¿â²ÎÊýglobal_name=trueʱҪÇóÊý¾Ý¿âÁ´½ÓÃû³Æ¸úÔ¶¶ËÊý¾Ý¿âÃû³ÆÒ»Ñù
       Êý¾Ý¿âÈ«¾ÖÃû³Æ¿ÉÒÔÓÃÒÔÏÂÃüÁî²é³ö
       SELECT * from GLOBAL_NAME;
       ²éѯԶ¶ËÊý¾Ý¿âÀïµÄ±í
       SELECT …… from ±íÃû@Êý¾Ý¿âÁ´½ÓÃû;
       ²éѯ¡¢É¾³ýºÍ²åÈëÊý¾ÝºÍ²Ù×÷±¾µØµÄÊý¾Ý¿âÊÇÒ»ÑùµÄ£¬Ö»²»¹ý±íÃûÐèҪд³É“±íÃû@dblink·þÎñÆ÷”¶øÒÑ¡£
        ¸½´ø˵ÏÂͬÒå´Ê´´½¨:
 &nb


Ïà¹ØÎĵµ£º

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
  v_clob    CLOB;
  v_varchar VARCHAR2(32767);
  v_start  PLS_INTEGER := 1;
  v_buffer  PLS_INTEGER := 32767;
BEGIN
  DBMS_LOB.CRE ......

¡¾×ª¡¿ ORACLE ·ÖÇø±í PARTITION table

ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......

oracle ±í½á¹¹µÄÐÞ¸Ä

oracle ±í½á¹¹µÄÐÞ¸Ä
½ñÌì×ܽáϹØÓÚ±íµÄÐÞ¸Ä,·ÀÖ¹ÒÔºóÍü¼Ç,ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·Âð!!!
¸ü¸Ä±íµÄ½á¹¹
1.±à¼­±íµÄ×Ö¶Î
  ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
  Óï·¨:
    ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
 eg1:
   alter table ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ