ç¨ sqlplus user/pwd@orcl
orclæ¯ä½ çæ¬å°ç½ç»æå¡åè½ç»å½åï¼
å¦æè½çè¯ï¼é£ä¹pl/sql devåºè¯¥ä¹è½ç»å½ã
å¦ææ¯64ä½çç³»ç»ï¼åèä¸é¢çæ¹æ³ï¼
64ä½windowsä¸ï¼ç¨PL/SQL Developerè¿æ¥Oracleçæ¬ï¼
?1. ä¸è½½32ä½Oracle InstantClientï¼å¹¶å±å¼å°æç®å½ï¼ä¾å¦C:\instantclient-basic-nt-11.2.0.2.0ï¼
?2. å°ç³»ç»çtnsnames.oraæ·è´å°è¯¥ç®å½ä¸ï¼
?3. å¨PLSQL Developerä¸è®¾ç½®Oracle_HomeåOCI Libraryï¼
Tools?Preferences?Oracle?Connectionï¼
Oracle_Homeï¼ C:\instantclient-basic-nt-11.2.0.2.0
OCI Libraryï¼ C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
?4. å¨PLSQL Developerç®å½ä¸æ°å»ºå¦ä¸batæ件ï¼æ¿æ¢å
¶å¿«æ·æ¹å¼ï¼å¯å¨PLSQL Developerï¼
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
温馨提示:答案为网友推荐,仅供参考