sql developer installation steps

Here, I learned a very important thing is to use PL/SQL developer to see the execution plan of a SELECT statement, the execution plan can see the cost of this SELECT statement,I/O operation cost and other values, You can clearly see the execution efficiency of each part of the statement. When this select statement is selected, press F5 to do so. Take the following SELECT statement as an example:Take the da

Label:1, first download PL/SQL, installation, cracking;2, download the Oracle INSTANCT client base version of the file, if the system is 32-bit download 32-bit, 64-bit download 64-bit;3, decompression instanct client to any disk, such as (D:\instanctClent), in the decompression file under the path of a new file network, and then build a file under the network Admin,ok;4, with the TXT software to write Tnsna

Get ready: PL/SQL Developer: I'm using plsqldev1005 (32-bit) Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit After the installation is successful, you need to configure the environment variables:Tns_admin

Normally, connecting Oracle with PL/SQL developer requires the installation of Oracle client software, which means that your hard drive will take up about 1g-2g of space, and you will have some more boot-enabled services for the Windows operating system. Of course, for most people, you don't apply the database you create on your own machine, but just want to conn

IamlaosongAlas, the real soil, used toad, has been using dbms_output.put_line debugging stored procedures, only feel inconvenient, with PL/SQL developer, or use this method, online search, just know can be single-step debugging. Learn to use PL/SQL developer debugging features for writing complex stored procedures, pac

First, the problem descriptionThe oracle-client side is not installed locally, and because of limited machine resources, you want to connect to the remote database via PL/SQL developer. Simple installation PL/SQL developer cannot connect to the database remotely.Second, the

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/

PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7, download from Windows 7 PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7I. Problem phenomena and SolutionsSymptom:1. PL/SQL cannot log on to the 64-bit Database2. Enter Chinese in PL/SQL

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: s= The SELECT replication code is saved to the ~/plugins directory under the installation path of PL/

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