Oracle SQL Jumpstart with Examples- P2

Oracle SQL Jumpstart with Examples- P2: Review"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single...
Nội dung trích xuất từ tài liệu:
Oracle SQL Jumpstart with Examples- P2 20 1.6 SQL Tools Before you begin the following steps, you will need these two pieces of information about your database: The database name or network name. If you are running the database on your own computer, this is the name you gave the data- base when it was created. If you are not sure what you named it, go to a command prompt (see step 1 to learn how) and then type this command: lsnrctl status Look for a line that begins like this. The word in quotation marks is your database name. In this example, the database SID name is OLTP. Instance oltp, status READY, ... If you are running from a client computer and using a remote database on the network, you must use the network name defined in your local Oracle Net configuration. The configuration file named TNSNAMES.ORA has all of the network names available to you. The file is located in $ORACLE_HOME/network/admin directory. Here is an example of the text found in the TNSNAMES.ORA file for the OLTP network name: OLTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 1300server) (PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oltp)))Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. 1.6 SQL Tools 21 Figure 1.11 Win2K Registry ORACLE_SID Variable. The password for the users named SYS and SYSTEM. The Oracle Database Configuration Assistant in Oracle Database 10g allows set- ting of SYS and SYSTEM passwords to the same value. If you are running a database on your own computer or on a database server, you can reach the database directly by omitting the database name. When you omit the name, Oracle uses the bequeth protocol and the cur- rent $ORACLE_SID variable setting to access the database. In Windows the $ORACLE_SID variable is set in the registry, and on UNIX or Linux in a user or root profile. Figure 1.11 shows a Win2K registry location. When you use the database name, Oracle uses the transmission control protocol (TCP). Follow these steps to start up SQL*Plus Command Line and run an SQL command: Note: The steps here, and throughout the book, use the sample tables and data created especially for this book. Appendix A contains instructions for locating and installing all of the sample tables. 1. Go to a command-line prompt on your computer. If you are using Windows, click on Start/Programs/Accessories/Command Prompt. A window appears with a blinking cursor. This is your Chapter 1Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. 22 1.6 SQL Tools Figure 1.12 SQL*Plus Command Line in Windows 2000. command prompt. If you are using UNIX, you may be at the command prompt when you log in. It looks like a dollar sign ($). If you are not already at the UNIX command prompt, select Ter- minal Window from your Utilities menu or execute an operating system shell. 2. Type the following command, replacing pwd with the password for the SYSTEM user and replacing name with your appropriate netw ...