Do not install Oracle using PL / SQL

2010-07-22  来源:本站原创  分类:Database  人气:148 

Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, Otherwise, Oracle is using up most succulent of should or pl / sql Developer. Development of the machine is too lazy to install stout of Oracle, even if the client is extremely heavy.
Fortunately found a free installation of Windows, the client can use Oracle pl / sql developer handy way to share:

1, from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html the Download Instant Client, note the next two basic package can not recommend basiclite (I downloaded is about 45M of that) (download time to mail registration)

2, the disk to create the directory, unzip the past, eventually extracting file will be in the same directory. For example extract to c: \ oracleclient

3, create the directory c: \ oracleclient \ network \ admin

4, create file tnsnames.ora as follows (you can also copy over your original cover on the line)
oracledata =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = yourhostIp) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yourSID)
)
) Copyright Sqlclub

5, set the pl / sql Developer's perference:
oracle_home: "c: \ oracleclient \"
OCI Library: "c: \ oracleclient \ oci.dll"

6, restart the pl / sql developer, user name password, and set oracledata tnsnames.ora

7. To solve the problem of Chinese garbage, set the environment variable nls_lang = SIMPLIFIED CHINESE_CHINA.ZHS16GBK or you can directly run the following batch.

Reprinted from: http://www.javagov.cn/article/Document/211.html

相关文章
  • Do not install Oracle using PL / SQL 2010-07-22

    Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, Otherwise, Oracle is using up most succulent of should or pl / sql Developer. Development of the machine is too lazy to install stout of Oracle, even i

  • Not install Oracle uses PL / SQL Developer 2011-07-01

    PL / SQL Developer is a very powerful and very good third-party management tools with the oracle, but need to use it to install oracle, at least according to a streamlined version. I use the books that people who really do not want to kind of books d

  • Oracle Client PL / SQL Chinese garbled solution 2010-02-23

    Oracle Client PL / SQL Chinese garbled solution Keywords: database pl / sql developer field garbled English In the windows to create a named "NLS_LANG" system environment variable, set the value "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and

  • Oracle's PL / SQL block 2010-04-21

    1, PL / SQL block: Concept: PL / SQL is a procedural language (Procedural Language) and the Structured Query Language (SQL) a combination of programming language. Categories: a, anonymous: one-time use, not reuse. b, named: include (stored procedures

  • Oracle 11g pl / sql Study Notes (1) 2010-09-26

    Oracle 11g pl / sql Study Notes Sample Database HR schema Major command sqlplus /nolog conn /as sysdba desc dba_users select username,account_status from dba_users order by username; conn hr/hr desc employees desc departments 1, PL / SQL based 1.sql

  • Oracle 11g pl / sql study notes (a) 2010-09-26

    Oracle 11g pl / sql study notes Sample Database HR schema Major command sqlplus /nolog conn /as sysdba desc dba_users select username,account_status from dba_users order by username; conn hr/hr desc employees desc departments A, PL / SQL-based 1.sql

  • Book: Oracle 11g PL / SQL Programming 2011-09-18

    Oracle 11g PL / SQL Programming

  • Oracle中PL/SQL中if语句的写法介绍 2014-05-21

    以下是对Oracle中PL/SQL中if语句的写法进行了详细的分析介绍,需要的朋友可以过来参考下 /* If语句: 判断用户输入的数字. */ set serveroutput on --接收键盘输入 accept num prompt '请输入一个数字:'; declare --将屏幕输入的数字付给变量 pnum number := # begin if pnum = 0 then dbms_output.put_line('您输入的是0'); end if; if pnum = 1 then

  • Oracle使用PL/SQL操作COM对象 2014-07-24

    正在看的ORACLE教程是:Oracle使用PL/SQL操作COM对象.PL/SQL是由Oracle公司对标准SQL进行扩展,专用于Oracle数据库中程序设计的专用语言,属第三代过程式程序设计语言.从Oracle8开始提供了直接从PL/SQL中调用外部C语言过程,允许开发人员用PL/SQL进行使用C语言编制的程序模块.从Oracle8i开始,又引入了Java程序. 在本文中主要介绍外部例程的基本原理以及使用条件,介绍如何通过引用外部例程来操作Windows中的COM对象,并做了一个操作Exce

  • Manually install the Oracle Database PL / SQL for remote connections 2010-05-25

    As an underscore, let me get something so simple get several hours ~ ~ So in such a small mistake, a moment not looking ~ ~ ~ Toad for Oracle / Oracle SQL developer / Navicat Premium can access remotely, that is, PL / SQL error reported over the foll

  • connect remote oracle 10g pl sql 2010-08-19

    Premise has been installed in the machine oracle 10g server. Or, respectively, in the two machines to install oracle server, the client 1, Integrity client , plsql connect 1. Download 10201_client_win32.zip (oracle10.2g Integrity client ), all the wa

  • Free installation of oracle using PL SQL developer client to connect to remote oracle server (green version of oracle client) 2010-10-19

    Recently there is a demand to connect to remote oracle server, although there are many tools that can be connected, such as DbVisualizer, navicat and so can be known, PL SQL DEVELOPER operation of this tool in terms of oracle is unmatched by any othe

  • connect to a remote oracle 10g pl sql 2010-08-19

    Premise has been installed in the machine oracle 10g server. Or two machines were installed in the oracle server, the client A full client, plsql connect 1 Download 10201_client_win32.zip (oracle10.2g full client), all the way next installed, 2 Open

  • Composite data types Oracle 10g pl / sql collection of learning six - the index table. Nested tables. Variable-length array 2010-11-12

    --Oracle 10g A composite data type pl/sql collection , The collection can be divided into the nested table index table. . Variable-length arrays --1. Index table ( Subscript is no limit on the length, and can also be negative ) -- Before the 9i , Whe

  • Oracle's PL / SQL utility 2011-07-12

    This library is a collection of various utility packages for PL / SQL, as well as links to useful libraries hosted and maintained elsewhere. Generate PDF files using PL / SQL http://technology.amis.nl/blog/8650/as_pdf-generating-a-pdf-document-with-s

  • Complex data types Oracle 10g pl / sql collection of learning six - the index table. Nested table. Variable-length array 2010-11-12

    - Oracle 10g complex data types pl / sql collection, the collection can be divided into index tables, nested tables, variable-length array - 1, the index table (subscript no length limit, and can be negative) - In 9i before the definition of the inde

  • Oracle's PL / SQL to set the server name 2011-05-17

    How to set up PL / SQL server name, which as shown in the picture: Go to Start menu under NetManager the Oracle menu settings: Figure Figure 2:

  • Oracle 10G:PL/SQL正规表达式(正则表达式)手册 2015-03-09

    Oracle Database 10g 的一个新特性大大提高了您搜索和处理字符数据的能力.这个特性就是正规表达式,是一种用来描述文本模式的表示方法.很久以来它已在许多编程语言和大量 UNIX 实用工具中出现过了. Oracle 的正规表达式的实施是以各种 SQL 函数和一个 WHERE 子句操作符的形式出现的.如果您不熟悉正规表达式,那么这篇文章可以让您了解一下这种新的极其强大然而表面上有点神秘的功能.已经对正规表达式很熟悉的读者可以了解如何在 Oracle SQL 语言的环境中应用这种功能.

  • The third study notes oracle (function: Pl / sql) 2011-07-09

    Function: Pl / sql: Basic syntax: set ServerOutput on;[ Define output ] declare[ Define ] bookName varchar2(40); begin[ Start ] bookName :=[ To assign values to variables ]'gouchao'; dbms_output[ Output ].put_line(bookName); end[ The end of ]; / If c

  • Oracle: Let PL / SQL Developer Password Remember me 2011-07-04

    To facilitate the use of PL / SQL, you can make PL / SQL to remember passwords, specific methods: PL / SQL Developer 6.0.6.947-> Tools -> Preferences -> Oracle-> log history VGH "storage history" and "with password storage "