PL/SQL配置檔案解析

NO IMAGE
1 Star2 Stars3 Stars4 Stars5 Stars 給文章打分!
Loading...

1.安裝oracle客戶端
2.配置檔案
加增一個資料庫的方式,是編輯 tnsnames.ora檔案,在C:\Oracle\Ora81\NETWORK\ADMIN 目錄下.

增加類似下面的資訊
SVR236 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.236.236)(PORT = 1523))
    )
    (CONNECT_DATA =
      (SID = webdb)
    )
  )

SVR236配置名稱可以隨便更改
HOST主機名或IP
PORT埠
SID資料庫名稱
(SID = webdb)也可以替換成
      (SERVER = DEDICATED)
      (SERVICE_NAME = openview)
SERVICE_NAME 服務名

 3.新增多個值到資料庫中
    >insert…into…select
    >insert all into


(adsbygoogle = window.adsbygoogle || []).push({});

function googleAdJSAtOnload() {
var element = document.createElement(“script”);
element.src = “//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js”;
element.async = true;
document.body.appendChild(element);
}
if (window.addEventListener) {
window.addEventListener(“load”, googleAdJSAtOnload, false);
} else if (window.attachEvent) {
window.attachEvent(“onload”, googleAdJSAtOnload);
} else {
window.onload = googleAdJSAtOnload;
}

資料庫 最新文章