pl sql developer tutorial

1. Configure the Oracle database connection In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN: Orcl =(Description =(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))(CONNECT_DATA =(Server = dedicated)(SERVICE_NAME = orc

PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)Labels ):Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html2. Download and install PLSQL (around 16 Mb ):Http://www.onlinedown.net/soft/4902.htm3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a new folde

database. After filling out the next step directly.(6) Enter this page, you can click the Test button to test the database connection. (7) The user name and password of the current login, the result of the test and the reason are displayed after entering. After entering, click the Change Login button to modify the user name and password. The user name starts with the LC , the middle is the instance name (m572)in the GS Suite, and finally the 9999. The password is the password that is connected

The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool.PL/SQL Developer is one of the primary tools used by Oracle databases to import and export databases

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 c

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 applicatio

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*************************************************************************************************************** *

Tags: 2.0 SQL Bracket Cat good effect article tail topDue 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 corres

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/

Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Server listener.Configuration complete, with the PL