René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Oratclsh - a little demo

First, oratclsh must be started, usually by typing oratclsh in the prompt.
ORATCLSH for 32-bit Windows: Version 8.1.7.0.0 - Production on 28-FEB-2002 02:52:35

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

oratclsh[1]- oralogon me/mysweetpassword
oratcl1
oratclsh[2]- oraopen oratcl1
oratcl1.0
oratclsh[3]- orasql oratcl1.0 "select * from dual";
0
oratclsh[4]- orafetch oratcl1.0
X
oratclsh[5]- orafetch oratcl1.0
oratclsh[6]- oralogoff oratcl1
oratclsh[7]- exit
Soon, you (or at least I did) will realise that typing oratcl1.0 for almost every command is a nuisance. A better approach is to use a variable for oratcl1.0,... this saves me from a lot of typing.
oratclsh[1]- oralogon me/mysweetpassword
oratcl1
oratclsh[2]- oraopen oratcl1
oratcl1.0
oratclsh[3]- set h oratcl1.0
oratcl1.0
oratclsh[4]- orasql $h "select * from dual"
0
oratclsh[5]- orafetch $h
X
oratclsh[6]- orafetch $h
oratclsh[7]- oralogoff oratcl1
oratclsh[8]- exit