A Gentle Introduction to

SQL

Running OraclegoogleOracle Courant

Name of the server oracle
Name of the client sqlplus
Typical command line to start the client sqlplus scott/[email protected]googlesqlplus scott/[email protected]

soc3googlesoc3
the connection string - which is doubtless incredibly simple to set up - help would be appreciated here googlela corde de raccordement - qui est sans aucun doute incroyablement simple pour installer - aide serait appréciée ici
scottgooglescott
user namegooglenom d'utilisateur
tigergoogletigre
passwordgooglemot de passe
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 googleSi vos données incluent le &amp de caractère; il incite pour une valeur. Employez la commande SET DEF OFF;googlePLACEZ DEF AU LOIN; to avoid this.googlepour éviter ceci.

The editor is hideous. Copy and paste from a decent text editor.googleLe rédacteur est affreux. Copie et pâte d'un éditeur de texte décent.

If results are wide the format is unreadable. googleSi les résultats sont larges le format est illisible. SET LINE 500googlePLACEZ LA LIGNE 500 can help as can googlepeut aider en tant que bidon SET PAGESIZE 100googlePLACEZ 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.