Connor at 10:29, 19 July 2012

2012-07-19T10:29:22Z

Connor: Created page with "

Running Oracle

Name of the server	oracle
Name of the client	sqlplus
Typical co..." 2012-07-19T10:28:54Z 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..." New page <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 command line to start the client</th> <td><tt>sqlplus scott/tiger@soc3</tt><br/> <dl> <dt><p>soc3</p> <dd><p>the connection string - which is doubtless incredibly simple</p> <p>to set up - help would be appreciated here</p> <dt><p>scott</p> <dd><p>user name</p> <dt><p>tiger</p> <dd><p>password</p> </dl> </td> </tr> <tr> <th>Useful commands</th> <td><pre>select * from cat; describe <i>tableX</i>; start file.txt help set; </pre></td> </tr> <tr> <th>Beware!</th> <td> <p>If your data includes the character & it prompts for a value. Use the command <tt>SET DEF OFF;</tt> to avoid this.</p> <p>The editor is hideous. Copy and paste from a decent text editor.</p> <p>If results are wide the format is unreadable. <tt>SET LINE 500</tt> can help as can <tt>SET PAGESIZE 100</tt>.</p> </td> </tr> <tr> <th>Tips for not looking stupid when faced with a new Oracle installation.</th> <td> 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. </td> </tr> </table>

Name of the server

oracle

Name of the client

sqlplus

Typical co..."

2012-07-19T10:28:54Z

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..."

New page

<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 command line to start the client</th>
<td><tt>sqlplus scott/tiger@soc3</tt><br/>
<dl>
<dt><p>soc3</p>
<dd><p>the connection string - which is doubtless incredibly simple</p>
<p>to set up - help would be appreciated here</p>
<dt><p>scott</p>
<dd><p>user name</p>
<dt><p>tiger</p>
<dd><p>password</p>
</dl>
</td>
</tr>

<tr>
<th>Useful commands</th>
<td><pre>select * from cat;
describe <i>tableX</i>;
start file.txt
help set;
</pre></td>
</tr>

<tr>
<th>Beware!</th>
<td>
<p>If your data includes the character & it prompts for a value.
Use the command <tt>SET DEF OFF;</tt> to avoid this.</p>
<p>The editor is hideous. Copy and paste from a decent text editor.</p>
<p>If results are wide the format is unreadable. <tt>SET LINE 500</tt>
can help as can <tt>SET PAGESIZE 100</tt>.</p>
</td>
</tr>

<tr>
<th>Tips for not looking stupid when faced with a new Oracle installation.</th>
<td>
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.
</td>
</tr>
</table>

@@ Line 29: / Line 29: @@
 <th>Useful commands</th>
 <td><pre>select * from cat;
-describe <i>tableX</i>;
+describe tableX;
 start file.txt
 help set;

Starting Oracle - Revision history

Connor at 10:29, 19 July 2012

Connor: Created page with "

Running Oracle