0

If I have a script like this...

SET ECHO ON

SELECT 'I want the person reading the spool to see this whole query.'
  FROM DUAL
 WHERE interesting_logic_ = 'DEBUGGABLE';

SET ECHO OFF

PROMPT I only want the terminal to show this text, not the PROMPT command.
SELECT '...and this text, without the query' FROM DUAL;
HOST cmd /c echo ...and this text, without the command line

SET ECHO ON

How do I keep SET ECHO OFF from echoing?

In other words, how do I achieve the equivalent of @ECHO OFF from DOS and Windows batch scripting?

  • SQLPLUS is really a tool for DBAs and developers to access the database for maintenance and testing. It is not designed for reporting or use by end-users. – Albert Godfrind Jul 25 at 8:48
  • Thanks, Albert. I'm asking because I'd like to save some scrolling when reviewing error messages produced by CREATE PACKAGE BODY statements. (I already use using ANSI escape sequences to color the most important bits to make them stand out.) I use SQL*Plus in lieu of more sophisticated tools because it produces the most reproducible, standardized, portable deployment possible. – durette Jul 29 at 20:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.