When I run an alter command, I want the command to display in the script output. For example when I run this command
ALTER TABLE APONQA.APON_CODES DROP COLUMN JAG;
I want that command to display. Right now I just get this in the script output
For example;
Time Start: 05/18/2011 9:06:36 PM
Table altered.
Time End: 05/18/2011 9:06:36 PM
Elapsed Time for Script Execution: 766 msecs
Use the following example for the desired outcome:
--
-- Copyright (c) 1988, 2005, Oracle. All Rights Reserved.
--
-- NAME
-- glogin.sql
--
-- DESCRIPTION
-- SQL*Plus global login "site profile" file
--
-- Add any SQL*Plus commands here that are to be executed when a
-- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
-- This script is automatically run
--
REM
REM File: Login.sql
REM Purpose: SQL*Plus login script.
REM
REM Set the session's prompt to be something like:
REM username@global_name>
REM
SET TERMOUT OFF
SET FEEDBACK ON
SET TRIMSPOOL ON
SET ECHO ON
SET TERMOUT ON
In the Output:
Time Start: 5/19/2011 7:59:42 AM
SQL> ALTER TABLE SCOTT.EMP1
ADD (JOB VARCHAR2(10))
Table altered.
Time End: 5/19/2011 7:59:42 AM
Elapsed Time for Script Execution: 422 msecs