tailieunhanh - 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. | 20 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 database 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 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 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 to remove this watermark. SQL Tools 21 Figure Win2K Registry ORACLE_SID Variable. The password for the users named SYS and SYSTEM. The Oracle Database Configuration Assistant in Oracle Database 10g allows setting 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 current 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 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 .