sql server developer

PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)Labels ):Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html2. Download and install PLSQL (around 16 Mb ):Http://www.onlinedown.net/soft/4902.htm3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a new folder, such as D:/oracleclient/instantclient_11_2

Resolved in three steps:1. Check the server code:Execute SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle

Label:Resolved in three steps:1. Check the server encoding:Run SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle

them by the last update time. Run the following statement: SELECT * from sys.objects where type in (' U ', ' V ', ' P ') Order by modify_dateThis statement identifies all the user tables, views, and stored procedures in the database and sorts them by time, so that you can see others recently added and modified those database objects. Sys.objects does not contain triggers, and triggers are in sys.triggers. There are similar sys.tables,sys.views and so on.　　Information_schemaIf we want to quickly

Oracle SQL Developer Connection error (ORA-12505)I had a problem with my Oracle database, and I finally got it done. Today I have created another DBA administrator connection method, and I will share my solution with you, I hope it will be useful to you. Connection error code: Listener refused the connection with following error: ORA-12505, TNS: listener ...... confirm that this is the SID error connecting

When logging on to Oracle SQL developer, the problem is solved. When logging on to oracle's built-in SQL developer, the connection method was not selected at the beginning. The default connection type "Basic" was used. I filled in the connection name, user name, password, and connection prompt me error. Listener refuse

When logging in to Oracle with PL/SQL Developer: Using a filter for all users can leads to poor performance!Analysis: Regardless of the configuration of Oracle, you will see very many tables, views, sequences, etc. that are not relevant to the current work when using the tree directory on the left side of Plsql, resulting in very slow opening timesSpecific solution: Tools-->object browser filter--> Select "

installation of weapons is a top priority. There are four modules in the system: Fleet information Management, warship information management, military officer information management, weapon information management. At the same time in the four systems to be inserted, query, change and other changes. Based on these analysis, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDMandPDM are drawn using Power Designer . Create a table space, create a user, as

Tags: plsql installing Oracle Client InstallationDownload the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip Specific installation method can refer to Baidu2:pl/sql Developer 11.0Http://files.allroundautomations.com/plsqldev1106

Please refer to:Http://www.cnblogs.com/ymj126/p/3712727.htmlOrhttp://blog.csdn.net/cselmu9/article/details/8070728Oracle 11g Client can be downloaded from the official Oracle website or at the following URL.Http://pan.baidu.com/s/1X9xDkWhat about PL/SQL developer? Heroes can also be google/baidu to the latest version.Http://pan.baidu.com/s/1X9xDkWood elder brother's articles are based on their own practice,

After installing ORACLE11GR2 for the first time, it was curious to point out that when you click on SQL Developer under Application development, a window pops up, To choose a java.exe path, I will say the JDK1.7 under the Java.exe fill in, and then shut down the interface, the next time, found the warning, the highest version must not be higher than 1.6, and no prompt changes, directly into the interface, b