pl sql developer free download

--f82: Execute a single statement--mouse cursor resting place F83: Execute multiple statements--select more than one statement F84: Beautify code--toolbar PL/SQL Beautifier5: Debug Stored Procedure-Select procedures in the Browse window to find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, in the test Scrīpt window that is defined as

If the OS is a Windows 7 64-bit system, the Oracle version for Oracle 11g 64 installs PL SQL Developer please refer tohttp://myskynet.blog.51cto.com/1471053/623957 HTTP://SUPPORT.MICROSOFT.COM/KB/2585547/ZH-TW1, PL/SQL developer r

In the Execution menu you can disable statistics, or get SELECT permissions in the V_$session,v_$sesstat and V_$statname tablesSolutions[Email protected] ~]$ Sqlplus sys/manager123 as SysdbaSql> Grant Select on V_$statname to Zheng;Sql> Grant Select on V_$sesstat to Zheng;Sql> Grant Select on V_$session to Zheng;Sql> Grant Select on V_$mystat to Zheng;If you need

PL/SQL _ Developer _ the export tool is not recognized. pldeveloper Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/44974587 You cannot use th

Local Oracle client connects to remote database with Plsql developer , log in when reported ORA-12638: resolution of failure of identity certificate retrievalLocate the installation directory: C:\oracle\BIToolsHome_1\network\ADMIN Open Sqlnet.oraFind sqlnet in there . Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out : #SQLNET. Authentication_services= (NTS)Reason:Sqlnet. Authentication_services= (N

ArticleDirectory Latest reply Homeend of PL/SQL Posted on: Author: jaspersbq Source: cnoug blog homepageI wrote SQL statements in the SQL window of PL/SQL 7.0.3. Why is it difficult to use the home and end keys on the keyboa

database. After filling out the next step directly.(6) Enter this page, you can click the Test button to test the database connection. (7) The user name and password of the current login, the result of the test and the reason are displayed after entering. After entering, click the Change Login button to modify the user name and password. The user name starts with the LC , the middle is the instance name (m572)in the GS Suite, and finally the 9999. The password is the password that is connected

PL/SQL Developer and instantclient client installation configurationOracle installation I will not write, will not be installed on the Internet casually find a tutorial can be installed, installation is relatively simple. However, PL/SQL

PL/SQL Developer and instantclient client installation configurationOracle installation I will not write, will not be installed on the Internet casually find a tutorial can be installed, installation is relatively simple. However, PL/SQL

)Protocol select TCP.Next, enter ip:192.168.56.5If the test is not successful, may be due to incorrect login information, you can click "Change Login" reset after re-test, the following is the test success:The next step is to enter the service name configuration interface as follows:At this point, the client software configuration is complete, the interface click Exit.2. Connect PL/SQL

Tags: PL/SQL Developer remote database without native Oracle clientI. Download PL/SQL DeveloperPL/SQL Developer

In PL/SQLAutomatic statisticsThis function is used to generate statistical reports for executed SQL statements and test scripts. Generally, a new user does not have the corresponding permissions, so the user cannot actually use it. (even if you activate this option, seeHere), As shown in. The permission here indicates whether access is allowed.Dynamic Performance Table). If you want the general use

ORACLE you haven't actually written to the database since you modified the data. If you change the wrong, you can roll back.Dot the green tick is write cache, Is the post meant to be transmitted? Change is what it means, you know.Post changes is to pass the changes and not actually write to the database. If someone queries the database at this time, they will not see what you have changed. you are not actually writing to the database until you commit it.This is the concept of database tra

Locate the installation directory: C:/oracle/product/10.2.0/db_1/network/admin Open Sqlnet.oraFind sqlnet in there . Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out: # Sqlnet. Authentication_services= (NTS)The reason: My computer is in domain control, and NTS is just the window OS authentication method.PL/SQL Developer log in when reported ORA-12638: res

Double-click Table Defaults to Expand/collapse expand/collapse Sometimes you need to quickly view the table data, if writing select * from tab will appear troublesome,We can make a quick query by double-clicking the table.The method is:Double-click Action (Table), User Interface, Browser, Tools, Preferences, Quer Y Data)Reprint Please specify source: http://blog.csdn.net/itmyhome1990/article/details/38663783PL/SQL

Label:Original: http://blog.csdn.net/kimsoft/article/details/8751267 Operating system: Windows 7 64-bit flagship requirements, install PL/SQL developer for development First, download the official Oracle Lite Green Edition Http://www.oracle.com/technetwork/topics/winsoft-085727.html Special note To

Use Oracle instantclient to connect to the Oracle database 1. Download the correspondingProgramI got a 10204 instantclient-basic-win32-10.2.0.4.zip.(34,742,358 bytes) Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html? _ Template =/ocom/print Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html 2. decompress the Oracle instatnt client to D: \ instantclient_10_2.3. Deco

Prior to the project because of the need to use the ORACL database, due to limited time to start learning from the foundation, and Oracle operation of the command interface is too unfriendly, so found the PL/SQL developer This very useful software to use the database indirectly.Here is a brief introduction to how to connect the ORACL database with this software.T

client directory, create a new folder network, the network in the new admin, in the admin directory, a suffix named. ora file: Tnsnames.ora\instantclient_11_2\network\admin\tnsnames.oraNotepad opens and the content is added as follows:# Tnsnames.ora Network Configuration File:d:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)))(Connect_data =(service_name = ORCL)))Test-name

Tags: recommended https down nload beautification tool stored procedure recommended check DownloadFor a stored procedure to write a large number of SQL statements, which inevitably need to beautify the statement, making the program more readable.The PL/SQL Developer development tool comes with a beautification tool, bu