How to Echo/print/output Text or Comment to the Screen in Oracle SQLPLUS

smallwei 3:55 pm on February 9, 2010 | Answers: 1    
Tags: oracle (136), output (8), print (28), screen (17), sqlplus (7), text (65)

Rate Knowledge:

 Loading ...

• smallwei 3:55 pm on February 9, 2010
  

  Use the command “prompt”

  Example:
  

  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
  
  Connected to:
  Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
  SQL> prompt -- This is comment --
  -- This is comment --