René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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 |