Re: SQLPlus - How to spool without query string?
From: Son KwonNam <kwon37xi_at_ihatespam.xxx>
Date: Mon, 26 Sep 2005 15:37:44 +0900
Message-ID: <dh84rt$5hk$1_at_news2.kornet.net>
Date: Mon, 26 Sep 2005 15:37:44 +0900
Message-ID: <dh84rt$5hk$1_at_news2.kornet.net>
Thank you, all.
[Quoted] It works perfectly.
But when I try this, I had to make *.sql script file and run like "sqlplus user/passwd _at_test.sql"
It did not work interactively on sql*plus.
Anyway that's what I exactly wanted.
Thanks again.
Isa wrote:
> Hi:
> you can put at the beginning of the select:
> set termout off
> set arraysize 5
> set echo off
> set verify off
> set heading off
>
> This removes all the text from the query result. Only remains the
> values of the select
> I hope it's usefull to you.
> Regards,
> Isa
>
Received on Mon Sep 26 2005 - 08:37:44 CEST