Difference between revisions of "Starting Oracle"
(Created page with "<h1>Running Oracle</h1> <table border="1"> <tr> <th>Name of the server</th> <td>oracle</td> </tr> <tr> <th>Name of the client</th> <td>sqlplus</td> </tr> <tr> <th>Typical co...") |
|||
| Line 29: | Line 29: | ||
<th>Useful commands</th> | <th>Useful commands</th> | ||
<td><pre>select * from cat; | <td><pre>select * from cat; | ||
| − | describe | + | describe tableX; |
start file.txt | start file.txt | ||
help set; | help set; | ||
Latest revision as of 10:29, 19 July 2012
Running Oracle
| Name of the server | oracle |
|---|---|
| Name of the client | sqlplus |
| Typical command line to start the client | sqlplus scott/tiger@soc3
|
| Useful commands | select * from cat; describe tableX; start file.txt help set; |
| Beware! |
If your data includes the character & it prompts for a value. Use the command SET DEF OFF; to avoid this. The editor is hideous. Copy and paste from a decent text editor. If results are wide the format is unreadable. SET LINE 500 can help as can SET PAGESIZE 100. |
| Tips for not looking stupid when faced with a new Oracle installation. |
To get into Oracle use sqlplus or "SQL *Plus Worksheet" if you have a mouse and such like. Start/Programs/Oracle - something/Application Development/SQL *Plus Worksheet. You need to know a user name and password - scott/tiger is created by default. There are admin accounts sys and system. You also need the host string or service - I found this in the latest install log file C:\Program Files\Oracle\Inventory\logs\installActions2003-09-01-02-03-39-PM.log look for s_dbSid - there may be several - by default it is the first part of globalDBName. |
