oracle sql developer book

Tags: enter none sid \ n Instance term Oracle names post The traditional way to connect to a remote database is to install an Oracle locally. Then use the Network configuration Assistant. Then connect with PL/SQL Dev. It is not very convenient because the database needs to be installed locally?The second method is described below1, first to the

Label:Easy to use PL/SQL developer Related settings some time ago, the company internal Training PL/SQL related knowledge, here I think very convenient settings to share to everyone. 1. When using PL/SQL developer, it is convenient for you to work with PL/

;support info (support information)->tns Names, you can view the Tnsnames.ora of Oracle; 7. Debugging Stored ProceduresWhen using PL/SQL developer to operate Oracle, some stored procedures are sometimes called, or stored procedures are debugged;Methods for calling stored procedures:1) First, select procedures in the br

installed. The content is as follows: 　　# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_2\network\admin\tnsnames.ora　　# Generated by Oracle configuration tools.　　ORCL =　　(DESCRIPTION =　　(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.205)(PORT = 1521))　　(CONNECT_DATA =　　(SERVER = DEDICATED)　　(SERVICE_NAME = orcl)　　)　　)　　EXTPROC_CONNECTION_DATA =　　(DESCRIPTION =　　(ADDRESS_LIST =　　(ADDRES

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 o

First, download: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlThis is the homepage of the Oracle Instant client download, and there are many versions available for download.But pay attention to third-party tools such as: PL/SQL developer and Toad version, 32-bit to correspond to 32-bit oracleinstant Client, do not because 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. C

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 connect win7 (64-bit) as the server's oracle, su

[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 Developer Usage Tips1, PL/SQL developer remember login passwordWhen using PL/SQL developer, you want PL/SQL developer to remember the

means.The same query, using the Sqlplus method, is as follows:As you can see, the query statement executed successfully.To determine whether this is a PL/SQL developer bug, did not have time to fine-grained analysis, the first use of sqlplus execution script.So the operation is as follows:20 minutes later, 40 million data insertion was successful. The essays are written. Blue Growth Kee Series: Original wo

Use Instant Client to configure PL/SQL Developer, instantpl Previously PL/SQL Developer was used to directly install the full version of Oracle Database on the local machine. One was easy to use, and the other was able to perform some demo tests on the local machine. Recent