Output feedback on sql output

cms technology web page configuration drupal web site

Setup and configuration of cms and drupal web site

To set the feedback environment on Oracle SQL Plus

SQL> set feedback on
SQL> show feedback
FEEDBACK ON for 1 or more rows
SQL> start mynameis
DOC>File :mynameis.sql
DOC>Purpose: Display information from the emp table in the following format:
DOC>"My name is INITCAP(ename), I started work on hiredate."
DOC>*/

'MYNAMEIS'||INITCAP(ENAME)||',ISTARTEDWORKON'||HIR
--------------------------------------------------
my name is Smith, I started work on 17-DEC-80
my name is Allen, I started work on 20-FEB-81
my name is Ward, I started work on 22-FEB-81
my name is Jones, I started work on 02-APR-81
my name is Martin, I started work on 28-SEP-81
my name is Blake, I started work on 01-MAY-81
my name is Clark, I started work on 09-JUN-81
my name is Scott, I started work on 19-APR-87
my name is King, I started work on 17-NOV-81
my name is Turner, I started work on 08-SEP-81
my name is Adams, I started work on 23-MAY-87
my name is James, I started work on 03-DEC-81
my name is Ford, I started work on 03-DEC-81
my name is Miller, I started work on 23-JAN-82

14 rows selected.

SQL> set feedback off
SQL> show feedback
feedback OFF
SQL> start mynameis
DOC>File :mynameis.sql
DOC>Purpose: Display information from the emp table in the following format:
DOC>"My name is INITCAP(ename), I started work on hiredate."
DOC>*/

'MYNAMEIS'||INITCAP(ENAME)||',ISTARTEDWORKON'||HIR
--------------------------------------------------
my name is Smith, I started work on 17-DEC-80
my name is Allen, I started work on 20-FEB-81
my name is Ward, I started work on 22-FEB-81
my name is Jones, I started work on 02-APR-81
my name is Martin, I started work on 28-SEP-81
my name is Blake, I started work on 01-MAY-81
my name is Clark, I started work on 09-JUN-81
my name is Scott, I started work on 19-APR-87
my name is King, I started work on 17-NOV-81
my name is Turner, I started work on 08-SEP-81
my name is Adams, I started work on 23-MAY-87
my name is James, I started work on 03-DEC-81
my name is Ford, I started work on 03-DEC-81
my name is Miller, I started work on 23-JAN-82
SQL>