-
sqlplus feedback question
I wanted to turn feedback off so when my report gets generated, i dont see the following..I turned feedback to off but yet i still see these messages...any ideas oracle docs says use feedback...
any ideas?
SP2-0103: Nothing in SQL buffer to run.
SQL> set feedback off
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> set echo off
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> set pagesize 999
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> set linesize 180
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> col hostname format a15
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> break on report
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> compute sum of sessions on report
SQL> /
SP2-0103: Nothing in SQL buffer to run.
"High Salaries = Happiness = Project Success."
-
These ...
Code:
set echo off
set pagesize 999
set linesize 180
col hostname format a15
break on report
compute sum of sessions on report
... are all SQL*Plus commandfs. They don't need "/"
-
man after 5 years you still dont know how sqlplus works?!
-
Pando, Thankyou for your comments...but I do know sqlplus...I have written a complex query which I didnt post but it was my silly mistake I didnt realize what I did with the formatting, I must have zoned out. I thank slimdave for pointime out.
Thankyou for your ongoing support.
"High Salaries = Happiness = Project Success."
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
|