pl sql developer 64 bit

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

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 soluti

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

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

, select Test, in the Test Scrīpt window of the pop-up, for the parameter defined in type, You need to enter values for the value of this parameter, and finally click the number of bars button above: Start debugger or press F9; 3), Last click: RUN or Ctrl+r. Debug shortcut key Toggle Breakpoint: Ctrl+b Start: F9 run: Ctrl+r Single step: CTRL + N Step skip: Ctrl+o Single Step exit: Ctrl+t Run to Exception: Ctrl+y 8, Template shortcut 9, automatically check my Objects by default after login Under

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

PL/SQL Developer Usage Tips1, PL/SQL developer remember login passwordWhen using PL/SQL developer