toad sql developer

1. PL/SQL Developer remember the Login Password When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for ease of work; Setting Method: PL/

The PLSQL installation directory contains the specialcopy directory and Java. Copy, C ++. Copy, and so on, Add a file: java4stringbuffer. copy with the following content: ; PL/SQL developer specialcopy Definition; ; ; ;# Define "= \"# Define \= \\# Define char (9) = \ tNew stringbuffer (". Append (". Append (" Write such a statement in PLSQL: Select O. COMPID, O. pcompidFrom basic_organization oConnect

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/

1. PL/SQL developer remember the Login PasswordWhen PL/SQL developer is used, PL/SQL developer needs to remember the username and password for logging on to Oracle for ease of work; Setting Method: PL/

With the 64-bit Oracle database installed and the 32-bit Oracle client, prompting for the path to the Java.exe when you first open the client's SQL developer in the Start menu, I select the JDK path that comes with the Oracle database and then make an error:Baidu looks for a workaround because the JDK that comes with the 64-bit Oracle database is also 64-bit, but the installed Oracle client is 32-bit, so it

Easy-to-use PL/SQL Developer settings, pldeveloperSome time before the easy-to-use PL/SQL Developer settings, the company trained pl/SQL related knowledge internally. Here I will share my settings that I think are very convenient. 1. When PL/

PL/SQL Developer usage tips, shortcut keys1, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. This is easy to read code, and to maintain a good coding style, in the same way, in Tools->prefer

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 content:S=selectCopy code is saved to the ~/plugins directory under the PL/SQL

replaced by 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) –>edit 1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/SQL

feature, because remembering passwords can give data security problems.But if it is the development of the library, the password can even be the same as the user name, each input password is really meaningless, you can consider let Plsql developer remember the password.Location: Tools menu--preferences--oracle--logon history--store with password3, double-click to display table dataPlsql developer The defau

Pl/SQL developer encoding format settings 1. pl/SQL developer Chinese fields are garbled: This is caused by inconsistent database numbering formats and pl/SQL developer encoding formats. 2. view and modify the oracle database char

Questions about creating Oracle jobs through PL/SQL developer 8.0 [transfer] test environment: oracle9i, PL/SQL developer 8.0, PL/SQL developer 7.0 After a colleague created Oracle jobs through PL/

The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And porgram window, A menu co

The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database. 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/41479997 After 64bit oracle11g database is installe

Tags: style blog http io strong for file Data 2014Export/import icons are grayed out:Cause: The associated application is not associatedMenu Bar-- T-ools--Import Tables ...--Oracle ImportExport Executable : %oracle_home%\bin\imp.exe Output file:c:\documents and settings\administrator\ desktop \eam.dmpPL/SQL Developer is the primary tool for importing or exporting databases in an Oracle database , and this a

Label:PL/SQL Developer manages multiple sets of databases and connects multiple sets of databases as a unified interface platform. 1.. 1, class SQL Plus Windows: File->new->command window, this is similar to Oracle's client tool SQL Plus, but it is much more useful. 2, set the keyword automatic capitalization: tools->

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 content:S=selectCopy code is saved to the ~/plugins directory under the PL/SQL

PL/SQL Developer connects to the Oracle (64Bit) diagram installed on Windows 7. Thanks to the continuous update of hardware technology, Windows 7 has gradually become the mainstream and the computer memory has gradually increased, to make full use of memory resources (because 32 is the system can only use about 3 GB of memory) and improve system performance, many people begin to use Win7 (64Bit) systems. Th

Oracle developer estimates are very familiar with PL/SQL developer, and there are some small function points that some beginners have not found. PL/SQL Developer supports multi-connection multiple windows, as detailed below. Concept of the primary connectionOpen PL/