-
SQLPLus question
How can I turn off the SQL>, i ONLY WANT TO GET THE RESULT,I did try
SET VERIFY OFF
SET HEADING OFF
SQL> SELECT 'ALTER TABLE '|| CODE ||' THIS IS ONLY A TEST' FROM AGENCY;
ALTER TABLE CSFM THIS IS ONLY A TEST
ALTER TABLE TRRC THIS IS ONLY A TEST
SQL> spool off
-
Hi,
You can use follwing set options in the sql script
set sqlprompt ' '
set feedback off
set heading off
-Deepak
-
I did set those options before I post here but seem it's not working and I don't know what I am missing here:
below is the result on my output:
SQL> set heading off
SQL> set verify off
SQL> SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
ALTER TABLE CSFM THIS IS ONLY A TEST;
ALTER TABLE TRRC THIS IS ONLY A TEST;
SQL> spool off
below is what I have on my script:
spool c:\temp\oracle.sql
set heading off
set verify off
set linesize 120
SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
spool off
-
Put the "spool" after the "set"s.
-
use this script
set sqlprompt ' '
set heading off
set verify off
set feedback off
set linesize 120
spool c:\temp\oracle.sql
SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
spool off
Hope this help
-Deepak
-
I did exaclty what you toild me and I still have the verify come back:
SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
ALTER TABLE CSFM THIS IS ONLY A TEST;
ALTER TABLE TRRC THIS IS ONLY A TEST;
spool off
I have done this many times but I don't know what's going on here
thanks
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
I am so sorry guys, I don't know what's going on here, here what I have on my scripts:
SQL> set heading off
SQL> set verify off
SQL> set feedback off
SQL> set linesize 120
SQL> SET ECHO OFF
SQL> SPOOL C:\TEMP\oracle.SQL
SQL> SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
ALTER TABLE CSFM THIS IS ONLY A TEST;
ALTER TABLE TRRC THIS IS ONLY A TEST;
SQL> SPOOL OFF
SQL>
and below is my result:
SQL> SELECT 'ALTER TABLE ' ||CODE ||' THIS IS ONLY A TEST;' FROM AGENCY;
ALTER TABLE CSFM THIS IS ONLY A TEST;
ALTER TABLE TRRC THIS IS ONLY A TEST;
SQL> SPOOL OFF
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|