of the menu item, and select the check box above in Autosave desktop on the right.B. Check the Window list option under Tools of the menu item.9. format SQL)When you get a long SQL statement and want to quickly view the logic, you can put it in this tool for formatting, and the statement logic will be clear at a glance.10. The database automatically detects connections Because the database is automatically
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
MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The official website is: Http://www.navicat.com.cn/products/navicat-premium. Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 3, Pl\sql Developer
Because of the reasons for the project need to use the Oracle database, due to time constraints can not learn from the foundation, and the Oracle operation of the command interface is too unfriendly, so I found Pl/sql developer this very useful software to indirectly use the database.
Here's a brief description of how to use this software to connect to Oracle da
The following is a summary of how to use PL/SQL Developer to connect to a 64-bit database on the Internet. I will repost it here and share it with my friends.
Reprinted below:
1) install Oracle 11g 64-bit
2) install a 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0)
: Http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html
Tools of the menu item, and select the check box above in Autosave desktop on the right.B. Check the Window list option under Tools of the menu item.9. format SQL)When you get a long SQL statement and want to quickly view the logic, you can put it in this tool for formatting, and the statement logic will be clear at a glance.10. The database automatically detects connections Because the database is automat
the logic, you can put it in this tool, format, the logic of the statement is clear10. Automatic connection of databaseBecause the database does not operate for a period of time, it will automatically disconnect, and then need to manually connect themselves, because of the network, always stuck there. The tool provides the ability to detect connections, which can be automatically connected.The specific settings are checked in front of the Tools-preferences-check Connection,check connection.11.
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
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 Win
Pl/sql DEVELOPER Related Resources web site
Developer Official website http://www.allroundautomations.com Product official website http://www.allroundautomations.com/bodyplsqldev.html
Pl/sql
infoàtns Names, you can view Oracle's Tnsnames.ora.
Copy to Excel
Execute the SELECT statement in SQL window, after the result, right click on the data area, select Copy to Excel, you can copy the record of the data area to excel. But there are two points to note: First, field can not start with =, otherwise Excel will be mistaken for a function, and two, the number should not exceed 17 digits, otherwise the number of digits will be set to 0, but c
Due 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 corresponding 64-bit 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
Instant-client (Database Instant client)Official note: The instant client is available under a separate OTN development and distribution license for Instant client, which allows the majority of licenses to be downloaded, redistributed, and deployed to the production environment at no charge.Why use Instant-client
No need to install, decompression is good;
Free.
Download instant-clientAddre
Due 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 corresponding 64-bit PL/
Label:Due 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 corresponding 64-bit PL/
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/
Win7 has gradually become the mainstream Windows operating system, and its 32-bit and 64-bit systems are equally different. However, no 64-bit PL/SQL developer is available yet. When 32-bit PL/SQL developer is directly used to con
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.