Oracle
Oracle Database is a leading commercial DBMS. It supports very large databases and numbers of transactions. It runs on many operating systems and hardware platforms and is complex enough to require a full-time database administrator to run and maintain it.
You can learn about Oracle products at www.oracle.com. Click the Download link and look in the Database category. After you register and agree to the license terms, you can download a free, single-prototype, development-only version of Oracle Database. Documentation is at www.oracle.com/technology/documentation.
This book covers Oracle 10
g but also includes tips for earlier versions. The version of Oracle that you're running is displayed in the initial "Connected to" message that appears when you log on to SQL*Plus or sqlplus (or run the query SELECT banner FROM v$version).
You can use the SQL*Plus graphical tool or the sqlplus command-line utility to run SQL programs.
To use SQL*Plus
1.
|
Start SQL*Plus.
This procedure varies by platform. In Windows, for example, choose Start > All Programs > Oracle - OraDb10g_home1 > Application Development > SQL Plus.
|
2.
|
Enter your user name, password, and a database name; then click OK (
Figure 1.13 ).
Figure 1.13. The SQL*Plus logon screen.
If you're connecting to a remote Oracle database, ask your database administrator for connection parameters.
|
3.
|
To run SQL interactively, type or paste an SQL statement. The statement can span multiple lines. Terminate it with a semicolon (;) and then press Enter to display the results (
Figure 1.14 ).
Figure 1.14. The results of an interactive SELECT statement in SQL*Plus.
or
To run an SQL script, type @
sql_script and then press Enter to display the results (
Figure 1.15 ).
sql_script is a text file containing SQL statement(s) and can include an absolute or relative pathname.
Figure 1.15. The same SELECT statement run as a script in SQL*Plus.
|
To use the sqlplus command-line utility interactively
1.
|
At a command prompt, type:
sqlplus
user@dbname
user is your user name, and
dbname is the name of the database to use. sqlplus will prompt you for your password.
|
2.
|
Type an SQL statement. The statement can span multiple lines. Terminate it with a semicolon (;) and then press Enter to display the results (
Figure 1.16 ).
Figure 1.16. The results of a SELECT statement in sqlplus interactive mode.
|
To use the sqlplus command-line utility in script mode
Figure 1.17 ).
Figure 1.17. The same SELECT statement in sqlplus script mode.
 Tip
You can (but shouldn't) specify
user/password instead of
user to avoid being prompted for your password.
To exit the sqlplus command-line utility
To show sqlplus command-line options
- At a command prompt, type sqlplus -H and then press Enter.
|
لطفا منتظر باشید ...
