echo "select count(*) from subscribers;" | sqlplus -s db/db
--
Kind reGards,
Gerard
(ghp_at_santens.be; ghp_at_skynet.be)
Andrea Beam <abeam_at_holly.ColoState.EDU> schreef in artikel
<60bnt7$75k_at_holly.ColoState.EDU>...
> Are there any 'set' options that will allow me to go from this:
> $ echo "select count(*) from subscribers;" | sqlplus db/db
>
> SQL*Plus: Release 3.2.2.0.0 - Production on Wed Sep 24 13:59:19 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.2.2.3.0 - Production Release
> With the parallel query option
> PL/SQL Release 2.2.2.3.0 - Production
>
> SQL>
> COUNT(*)
> ----------
> 89065
>
> SQL> Disconnected from Oracle7 Server Release 7.2.2.3.0 - Production
> Release
> With the parallel query option
> PL/SQL Release 2.2.2.3.0 - Production
>
> To this:
> $ echo "select count(*) from subscribers;" | sqlplus db/db
> COUNT(*)
> ----------
> 89065
>
> Thanks much,
>
> abeam_at_holly.colostate.edu
>
Received on Wed Sep 24 1997 - 00:00:00 CDT
