1. Start with only Oracle and access connections2. Open Oracle SQL Developer:Tools--> Preferences--> Database--third-party JDBC driver--Add driver entries3. Automatically loaded into the directory, Jtds.jar downloaded to put here. (My path: C:\Documents and Settings\administrator\application data\sql developer\)my jtds.jar free: http://download.csdn.net/detail/kk
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
Tags: plsql developer software WrapStatement ************************************************************** *********Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/39932149*************************************************************************************************************** *
1 Installation Configurationhave been using Toad to manage the database, today, a small study of SQL Developer tools, after the installation of ORACLE, the default installation of SQL Developer, the installation directory is $oracle_home/sqldeveloper, The first time you start will be prompted to enter the Java director
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
Tags: des style blog tar width get1. 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 in the program Files (x86) directory, or PL/
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
Configuring the PL/SQL Developer Connection Server databaseThe client software is installed on the remote application server and can be downloaded on the Oracle official website.Example:Environment
Application Server operating system
WIN 7
Local address
192.168.56.117
Production server operating system
Enterprise Linux Server Release 5.4
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/
PL/SQL Developer Import and Export database method and illustrate how well does you KNOW the APPLE UNIVERSE?In, Apple became the first company worth how much?Which religion did Steve Jobs practice?What is one of the Apple protects its secrecy?In 1981, "Woz" is in a plane crash and suffered which effect?Why does Steve Jobs leave his job designing video games at Atari?Who is Apple's second biggest, after the
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/
[connect]
Disconnects from the database
Edit
Displays a text editor to edit the SQL Buffer
Exec [ute] Procedure
Executes the specified procedure
Exit [application]
Quits a running script or closes the command window. Adding the application parameter will also close PL/SQL developer.
Get [filename]
Loads a comman
PL/SQL DeveloperYesOracle DatabaseThis document describes how to use PL/SQL Developer to import and export databases, and describes precautions for importing or exporting databases, next we will introduce them one by one.
Export Steps:
1 tools-> export user object selection option to export the. SQL file.
2 tools-> exp
PL/SQL developerYesOracle DatabaseThis document describes how to use PL/SQL developer to import and export databases, and describes precautions for importing or exporting databases, next we will introduce them one by one.
Export Steps:
1 tools-> Export user object selection option to export the. SQL file.
2 tools
Original: PL/SQL Developer how to connect a 64-bit Oracle plotDue 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
To put it a little bit, pl/SQL developer needs to install the local Oracle client to connect to remote oracle before using the client configuration. Due to the bloated client, oracle now provides green and small solutions. The following is a detailed description.
Environment: xp, pl/SQL developer, Instant Client
Questi
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.