Newly installed oracle9i, using pl / sql developer connection up operating table when the error: ORA-01460: conversion request can not be achieved or unreasonable. Cause of the problem is: the client and server character set is inconsistent. After th
Now install the oracle version too, and often have to change the tnsnames.ora configuration file. According to the information available online, the easiest is to: In the environment variable to set the TNS_ADMIN entry path is to have the tnsnames.or
Using the PL / SQL Developer tool for landing a newly created user query, quoting the following error (PL / SQL Developer Version: 7.1.5 1403): Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable ...
Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, the only regret is that only supports JDK5, but this little regret as long as the configuration configuration can be avoided. Otherwise, Oracle is usin ...
Host Environment: win xp Database: oracle 11gR2 32bit PL / SQL Developer 7.15 Steps are as follows: Fortunately found a free installation of Windows, the client can use Oracle pl / sql developer handy way to share: 1, the installation plsqldev715.exe ...
Always wanted to be used alone pl / sql developer This tool to connect oracle, because the machine Anzhuang orcle Pao up like ox plowing, Wang Shang a search, there Henduo Xiangguanbiaoti, basic Fu Zhi, Kandao dongwei_6688 author to write in more detail,
PL / SQL Developer Tips 1, PL / SQL Developer remember the login password when using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 -> to
First, it should install the oracle client and install pl / sql developer. Modify the D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames.ora Quote SNDEV = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 0.0.0.0) (PORT = 11111)) (CO ...
1, download oracle_client to the local. 2, install the client, select 178M of that is to install only the client 3, the installation is complete in the command line, type sqlplus, if you can use that installed the 4, and now, of course, can not conne ...
Oracle database is believed to have a lot of companies build their business-critical support for the importance of the background, is often used by many developers back. However, Oracle provides its own set of client-side tools are not useful, a grea
PL / SQL Developer to connect oracle database to meet several conditions, (1) First of all, at least the machine is equipped oracleClient, it can be. Of course, if the machine can be equipped with a server. (2) and then check OracleOraDb10g_home1TNSL
Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, the only regret is that only supports JDK5, but this little regret as long as the configuration configuration can be avoided. Otherwise, Oracle is using up
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 other too
Under normal circumstances, with the PL / SQL Developer Connection is the need to install Oracle Oracle client software, which means your hard drive will be occupied the space of about 1G-2G, for the Windows operating system, you will be more number of bo
1. PL / SQL Developer remember the login password in the use of PL / SQL Developer, the In order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer-> tools-> Prefere
To do an entire summer in an Oracle-based data processing program. But has not found a suitable artificial laboratory database to facilitate access method. Coolest when I practice is to write a program to connect the database using JDBC want to form their
Configuring PL / SQL Developer to connect Oracle database, the easiest configuration Why use instant-client You use the Oracle client is also OK, if you pretend to be too troublesome. Then distributed free of using the oracle instant client it is not expe
Sql client, although the most convenient is extremely versatile and lightweight Sql Workbench, the only regret is that only supports JDK5, but this little regret as long as the configuration configuration can be avoided. Otherwise, Oracle, the use of them
Recently there is a demand to connect to a remote oracle server, although there are many tools can be connected, such as DbVisualizer, navicat and so can be known, PL SQL DEVELOPER This tool is in the oracle to the operation of any other tool can match, c
1, the use of PL / SQL DEVELOPER how to connect a remote Oracle database? Modify the ORACLE_HOME / NETWORK / ADMIN / tnsnames.ora file content, add: CRDS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = remote Oracle server ip address) (PORT = 15
PL / SQL Developer with skills 1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 ->
Today in Win7 on the configuration a bit and found always wrong, the original online information is a small configuration file to write the parentheses, sweat, I used to write the connection string parameters compare, and found that the final surface
Thanks: jslfl, refer to: http://jslfl.iteye.com/blog/788831 A security official free version of Oracle client, connect to the database method 1, http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html download Instant Client P
First, install the necessary 1, PL / SQL Developer installation program, the official website: http://www.allroundautomations.com/ ; 2, Oracle's Instant Client, the official website: http://www.oracle.com/cn/ . Note: Instant Client version 188.8.131.52.0
The new project started, use the PL / SQL to connect to Oracle on new data, and Internet access to some information, coupled with his own inference and finally get. 1, I have configured JDBC colleagues found the file where the Oracle database server addre
1. After login PL SQL Developer , On the left to find the Procedures, right-click pop-up submenu , Click new 2. In the dialog box, enter the stored procedure name and parameter name. Parameter type , Then click OK: 3. Then the stored procedure code input
The following tips only for PL / SQL Developer 6 or later, version 5 only one part of the property. 1, right-click menu in PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porg
1, right-click menu In PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porgram Window, right-click an object name will pop up a menu containing the command operation object, w
1, the first site to download Oracle Instant Client: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html Depending on your operating system to select a different version of Instant Client Download back is a compressed fil
Normally, with PL / SQL Developer to connect Oracle is a need to install the Oracle client software, which means your hard drive will be about 1G-2G occupy the space for the Windows operating system, you will be more Some boot from the start of the servic
Oracle database is believed to have become the key to many companies build their own business, an important background support, but also many developers often use the background. However, Oracle provides its own set of client tools are not very good,
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 did no
Use PL / SQL Developer connection Oracle11G when the 12541 and 12514 errors, the solution is as follows: 12541 error occurs (no listener) can modify the app \ user \ product \ 11.1.0 \ db_1 \ network \ admin \ listener.ora file, verify the following
1, the first site to download Oracle Instant Client (can also download a client on OK, and then install. Remember the installation path): Depending on your operating system to select a different version of Instant Client Download the back is a compre
了解一点编程的常识的人都知道，编码风格很重要。在阅读代码方面，保持一致的编码风格，阅读起来比较容易；大家都应该养成一种自己的编码习惯，并保持下去。 1，登录后默认自动选中My Objects 默认情况下，PLSQL Developer登录后，Brower里会选择All objects，如果你登录的用户是dba，要展开tables目录，正常情况都需要Wait几秒钟，而选择My Objects后响应速率则是以毫秒计算的。 Tools菜单 --> Object Brower Filters，会打
1, oracle10g installation is relatively simple 1. To download the Vista version of Oracle Oracle: Oracle Database 10 g Release 2 (10.2.0.4) for Microsoft Windows Vista x64 and Microsoft Windows Server 2008 x64 2. Unzip the downloaded installation file 102
PL / SQL DEVELOPER basic Detailed description (proposal written after the first stored procedure, the initial hand must-read) Used the oracle of all complaints, in order to stabilize its operation to provide graphical slow sad ah, p4 +128 M to start ...
If only export the table structure (built table statement), does not export the table data can be used Tools - Export User Objects Select to export the table, set up to export the path and all parameters, click Export on the OK PS: this approach is t ...
According to this method: http://hi.erp100.com/space-44763-do-blog-id-6761725.html Can be successful, but encountered problems accessing data garbled, the result did not engage in a day. Finally resolved by this method: reference post: http://hi.baid ...
PL / SQL DEVELOPER: Advantages: 1) multi-threaded model, a single window SQL operation does not cause other windows to die; 2) similar to the SQLPLUS the Command Window, features very strong, used to write SQL for students who feel very cool; 3) In t ...
PL / SQL Developer 184.108.40.2062 (or PL / SQL Developer 8 .* series SN, registration code, serial number) registration code are as follows: Product code: leswljrftczs7bjz8pz2kq7vzq85fu67q8f8rgg2bv Serial number: 642136713 Password: xs374ca
PL / SQL DEVELOPER disable scientific notation: Tools - Prefrence - SQL Window - Select the "Number fields to_char"
PL / SQL Developer Developer official website provides version control plug-in is the VCS, but the VCS need to rely on other to achieve Microsoft SCC interface version control tool, but the more the project using svn. Therefore, PL / SQL Developer De
Quote PL / SQL Developer script to export data, data If only export the table structure (built table statement), does not export the table data can be used Tools - Export User Objects Select to export the table, set up to export the path and all parameter
Start PL / SQL Developer is a pop-up to the error message: Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the client character set through
PL / SQL DEVELOPER basic Detailed description (proposal written after the first stored procedure, the initial hand must-read) Using PL / SQL is also almost a year, and now find that lots of other good stuff ah. Ha ha Used the oracle of all complaints
1, PL / SQL Developer Login Password Remember Using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Oracle-
Open PL / SQl Developer in the "SQL Window" or "Command window" can be run pl / sql block Write an anonymous block: (1) declare w varchar2 (20); / / variable declarations, type in the post begin select * into w from dual; / / not
Using oracle pl / sql developer summed up the points 1. Only the implementation of the cursor sql statement setting: / Tool / Preferences / SQL Windows / select Auto Select Statement, if not selected, the sql windows have all the sql execution. Note: Judg
1, login by default automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand tables directory, normally have to Wait a few seconds, and select the My Objects mil