Oracle SQL*Plus: The Definitive Guide, Second Edition by Jonathan Gennick

By Jonathan Gennick

Up to date for Oracle 10g, this bestselling ebook is the single in-depth advisor to SQL*Plus. It essentially describes the right way to practice, step by step, the entire initiatives that Oracle builders and DBAs are looking to practice with SQL*Plus - and perhaps a few you did not discover you may practice. in an effort to leverage of the total energy and adaptability of this renowned Oracle software, this e-book is an imperative source.

Show description

Read Online or Download Oracle SQL*Plus: The Definitive Guide, Second Edition PDF

Similar databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This ebook is a brief reference for the SQL dialect supported by means of the Teradata Relational Database administration approach. The publication is usually a short connection with the supported information description words for the Teradata RDBMS and the information Dictionary. The viewers for this quickly reference is all clients of Teradata SQL who want quickly, non-detailed information regarding find out how to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make varieties and studies precious advance varieties to entry the knowledge you wish and make reviews that make experience! for those who concept you needed to use a spreadsheet software to provide experiences and kinds, bet what! entry can prove great-looking varieties and reviews that really exhibit what is going on together with your information -- when you know the way to invite it properly.

Additional info for Oracle SQL*Plus: The Definitive Guide, Second Edition

Sample text

Command-line versions of SQL*Plus echo nothing at all. 4, there is a bug that prevents the CONNECT username technique from working. You can enter CONNECT with the username as an argument, then enter the password when prompted, but SQL*Plus won't pass the correct information to the database. 57 58 As you might expect, you can pass a connect string to CONNECT. You'll need to do that any time you connect (or reconnect) to a database other than your local, default database: SQL> CONNECT gennick@db01 Enter password: Connected.

Choosing Your Default Database On Linux and Unix, when you're running SQL*Plus on the same machine that is the database server, you'll often use the oraenv utility to specify the (local) database to which you want to connect. For example, to set your default database to the db01 instance, specify the following: oracle@gennick02:~> . oraenv ORACLE_SID = [prod] ? db01 You specify the database, which must be local to your machine, by typing its system identifier (SID) in response to the prompt. This example shows the Oracle SID being changed from prod to db01.

After you have successfully logged into your database, the SQL*Plus screen will look much like that shown in Figure 2-4. 51 52 Figure 2-4. The Windows SQL*Plus GUI At first glance, the Windows version of SQL*Plus doesn't seem to add much to the command-line version because it implements only a simple, scrolling window into which you type commands. But there are some advantages to using the Windows GUI. The GUI version implements copy and paste using the standard Ctrl-c/Ctrl-v key combinations, allows you to easily size the window any way you want (think large), and implements a scroll-back buffer so that you don't need to worry too much about query results scrolling by before you can read them.

Download PDF sample

Rated 4.34 of 5 – based on 31 votes