toad sql developer

First, go to Oracle's website to download an Oracle 11g Client (My 11g Oracle), but you need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlThis is a green version of Oracle Client, so as long as it needs to be decompressed, it can be. Unzip the downloaded Oracle client file Instantclient-basic-win32-11.2.0.1.0.zip (note 32-bit). Then create a new network\admin directory under the extracted C:\instantclient_11_2 dire

I. PL/SQL Developer data ImportTools->import TablesThe corresponding path is the path of the Sqlplus.exe, in general, in the \app\admin\product\11.2.0\client_1\bin\sqlplus.exe.The imported path is the path of the SQL file that you need to import, click Import to implement the import operation.Ii. PL/SQL

Tags: select root directory NTC Click need to restart OCI technology sharing styleRequires oracle11g installation package, PL/SQL Developer, and instantclient_11_21.oracle Click Install (need to pay attention to change the administrator password);2. Copy the network folder under the F:\app\Administrator\product\11.2.0\dbhome_1 directory to the root directory of instantclient_11_2 and instantclient_11_ 2 the

Tags: plsql developer ora-00936Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.The blog:http://blog.csdn.net/huangyanlong/article/details/49897839 of Blue Some time ago, when attempting to extract data using PL/SQL developer, a ora-00936 error was encountered w

Get ready: PL/SQL Developer: I'm using plsqldev1005 (32-bit) Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit After the installation is successful, you need to configure the environment variables:Tns_admin environment variable, similar to: C:\app\Lzj\

When you use the PL/SQL Developer tool to log on to a new user for query, the following error is reported (PL/SQL Developer version: 7.1.51403 ):Dynamic Performance Tables notAccessible,Automatic Statistics disabledFor this sessionYou can disable statistics inThe preference menu, or obtain selectPriviliges onV $ sessio

Win7 gradually became the current mainstream Windows operating system, with its 32 and 64-bit systems evenly tied. However, there is no 64-bit pl/sql developer come out, directly with 32-bit Pl/sql developer Connection Win7 (64-bit) as Oracle of the server, there is always such a mistake, through online data and their

the table, and if you do, you will be prompted not to export, which is the first and third way to export. The third type is exported to. Pde format, the. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL developer; can't use the editor to view, efficiency don't know how PS: Only the

select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following: S=select copy code is saved to PL/SQL Developer installation path

Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2 Download required software: Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9 Download link: http://pan.baidu.com/s/1gdH53IN Step 1: Install Oracle_11gR2 In the displayed "configuration Security Update" window, cancel "I want to accept security updates through My Oracle Support" and click "Next ":In the "Ins

(password: change_on_install) when the modifications are complete, click OK. In the Finish window, click Close. Step two: Decompression instantclient-basic-nt-11.2.0.3.0 to the installation directory I put it under the F:\Oracl\product directory. Step Three: Install and configure Plsql Developer Plsql Developer Normal next installation can be. The configuration is as follows: After the installation

When you create a new connection with an Oracle database, you encounter ora-12505, this problem is resolved and ora-12519 error, depressed for a half-day, after a toss problem solved, the following small series of my two solutions to share to you, for reference only. Solution One: Today when you work in a new connection to encounter ORA-12505, resolved and encountered ORA-12519 error. ORA-12505: There is no problem with using Pl/sql

Recently, because of the job needs, the boss asked the Oracle database on the server to migrate data to another server, I am not very familiar with Oracle, the migration of the database This is a matter of time spent, but also on the internet to inquire a lot of information. All kinds of moves are exhausted or not successfully migrated.Finally, the spirit of the dead horse as a live horse doctor, the Oracle SQL De