pl sql developer free download

PL/SQL Developer Quick action: show invisible characters Display historical SQL statements copy entire statements of the Windows to a new SQL windowDisplay invisible characters: You can display the blank space, carriage return;Show History

1. Configure the Oracle database connection In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN: Orcl =(Description =(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))(CONNECT_DATA =(Server = dedicated)(SERVICE_NAME = orc

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 instantcli

quick Input SQL statement, such as input s, press the space, automatically replace the select; For example, enter SE, press space,It is convenient to replace the select * from automatically, saving a lot of time to write duplicate SQL statements.Setup method: Menu tools–> preferences–> editor–> autoreplace–> EditClicking Save will automatically generate the AutoReplace.txt file and save it to the specified

Tags: com mmu develop plsql lov use TNS POS ResultsDescription of the phenomenon: It is normal to compile procedure with Plsql developer connection. Once the test starts to enter debug mode, it is stuck. The initial guess is that there is no permission, but the DBA role, if not the right will directly report the error without permission. The later guess is the version of Oracle or PL

Label:s = SELECT t.* from t w = WHERE b = between and l = '% ' o = ORDER by INSW = in (SELECT a From a where a) SW = Select t.* from t WHERE t sc* = Select COUNT (*) from t st = Select t.* , T.rowid from t f = for update u = Update t SET t. WHERE t 　　1. Save the above contents as Shortcuts.txt, copy to the X:\Program files\plsql developer\plugins directory, Win7 to pay attention to the permissions2. Menu select Tools-Perferences, Editor-autorep

PL/SQL Developer double-click table name query, pldeveloper Double-click a table. The default value is Expand/Collapse. To Expand/Collapse a table, you need to view the table data quickly. If you write select * from tab, it will be troublesome, Double-click table to perform quick query. Method:Tools-> Preferences-> User Interface-> Browser-> Object type (Table

Using PL/SQL Developer to import Excel data often involves data migration after project delivery. Generally, the given data does not have an ID, that is, the primary key. you need to add a column in excel, such as ID. save the excel file as a Text (Tab delimited) file, open plsql, connect to the oracle database to be imported, and then open Tools --> Text importe

Query for a field with Chinese text SELECT * from Issue I where ASCIISTR (i.id) like '%\% ' Query a field with English letters SELECT * from Issue I where regexp_like (I.id, '. [A-z]+[A-z]) (red font changes randomly) Renaming In the SQL Script window, right-click on the table name to select ' Rename ', modify it in the popup window, tap ' OK ' Delete a table Select my objects, find the table name, and right-select ' drop '20

In recent times, many netizens raised questions about Listener Configuration, and the client cannot connect to the server ). This article briefly introduces the Listener Configuration, provides detailed configuration methods for PL/SQL developer to connect to the Oracle database, and puts forward some solutions that the client terminal cannot connect to the serve

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

PL/SQL Developer customizes the case-sensitivity conversion icon to the toolbar. pldeveloper For case-insensitive conversion shortcuts, see http://blog.csdn.net/itmyhome1990/article/details/41363633 You can add the case-insensitive conversion icon to the toolbar using the following methods: Steps: Tools --> Preferences --> User Interface --> Toolbar --> Add

Two days ago, when a colleague uses Plsql, it is too troublesome to change the database by repeatedly entering the password.Below, I say here how to implement plsql do not need to enter a password to quickly login method:1, start logging in, first enter the password as usual login first2. Enter the page after login, select the tool option in the menu bar, select Preferences3. Then check the login history on the left page of the pop-up window and tick the password store4, then finally click on th

Tags: des style blog color os io file data1, found in the local installation of Oracle directory oracle\product\11.2.0\dbhome_1\network\admin, it generally has two files can be edited Tnsnames.ora Listener.ora, generally as long as the configuration Tnsnames.ora can. Configure how the content looks like.# Tnsnames.ora Network Configuration file:d:\app\oracle\product\11.2.0\dbhome_1\network\admin\ tnsnames.ora# Generated by Oracle configuration tools. ORADEV764 = (DESCRIPTION = ( address_list

1. Download PL/SQL Dev 2. Download the simplified Oracle client 3. Install PL/SQL Dev and the Chinese package 4. decompress the Oracle thin client. For example, extract the Directory D: \ oracle10g. 5. Configure the Oracle con

Label:After installation,1. Unzip the instant client to the Plsql Developer installation directoryNote that this version only supports instantclient_11_x and does not support instantclient_12_x if you use 12_x to report DLL errors2. Create the Network/admin directory under the Instant Client directory3. Create the Tnsnames.ora file, write the content format as follows # Generated byOracle configuration Tools. Db_dev=(DESCRIPTION=(Address_list=(ADDRESS

Tags: 2.0 SQL Bracket Cat good effect article tail topDue to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32 of the system can only use up to 3G of memory), improve system performance, many people began to use the Win7 (64Bit) system. A 64-bit Oracle database is installed on a 64-bit system, but there is no corres

Tags: table structure method file ora sysdba net blog log sqlIn cases where the owner of the table cannot be changed, you can use the method of importing and exporting the table structure and table data to move the table under the owner you want (note: In particular, if you are logged in as a sysdba, the owner of all tables is SYS, which can cause trouble for you to access the database in C #, In my other article, I also mentioned ". NET connection to Oracle database errors, myobjects filter in

Label:PL/SQL Developer can import or export CSV files.Import CSV file steps:1, choose Tools->text Importer ....2. Select the second Data to Oracle tab and select Open Data File ... to select the CSV file to import and determine3, select the corresponding owner and table, the field one by one corresponds, and finally click on the bottom of the import, the data is imported into the selected table.Exporting a

Label:Today, I intend to export the query results of SQL statements to a CSV file using the export CSV function of PL/developer. The results of this SQL query in Chinese, and finally opened with Execel found that the Chinese are all garbled.After Baidu got the answer. The following method verifies success under excel20