A Gentle Introduction to

SQL

Running OraclegoogleOráculo Corriente

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 secuencia de la conexión - que es sin duda alguna increíblemente simple instalar - ayuda sería apreciada aquí
scottgooglescott
user namegooglenombre del usuario
tigergoogletigre
passwordgooglecontraseña
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 sus datos incluyen el &amp del carácter; incita para un valor. Utilice el comando SET DEF OFF;googleFIJE DEF APAGADO; to avoid this.googlepara evitar esto.

The editor is hideous. Copy and paste from a decent text editor.googleEl redactor es horrible. Copia y goma de un editor de textos decente.

If results are wide the format is unreadable. googleSi los resultados son anchos el formato es ilegible. SET LINE 500googleFIJE LA LÍNEA 500 can help as can googlepuede ayudar como lata SET PAGESIZE 100googleFIJE 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.