By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,302 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,302 IT Pros & Developers. It's quick & easy.

Sql output problem in SQLPLUS....

P: n/a
Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the details..
================================================== ====================
SQL> desc accountmaster;
================================================== ====================
================================================== ====================
Output of the Command
================================================== ====================
================================================== ====================
Name Null? Type
----------------------------------------- --------
----------------------------
ACCOUNTCODE NOT NULL NUMBER(10)
NAMEOFACCOUNT VARCHAR2(100)
SUPERCODE NUMBER(10)
OPENINGAMOUNT NUMBER(10,2)
ACCOUNTGROUP VARCHAR2(20)
SUBLEDGER CHAR(1)
PAN VARCHAR2(20)
ADDRESS1 VARCHAR2(70)
ADDRESS2 VARCHAR2(70)
ADDRESS3 VARCHAR2(70)
CREDITLIMIT NUMBER(10,2)
CREDITDAYS NUMBER(10)
DOC VARCHAR2(10)
================================================== ========================
SQL> select * from accountmaster where accountcode=7;
================================================== ========================
================================================== ========================
Output of the command
================================================== ========================
================================================== ========================
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
7

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
Reserves & Surplus (Retained Earnings)

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
0 0 01 T

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
0 0

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
SQL>
================================================== ==============
Instead of thesemuch multiple rows I want to see the output in single
row with no wrap.
Please suggest me how to do this????
Regards
Arijit Chatterjee
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Arijit Chatterjee wrote:
Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the details..
================================================== ==================== Instead of thesemuch multiple rows I want to see the output in single
row with no wrap.
Please suggest me how to do this????
Regards
Arijit Chatterjee


Dear Arijit

It is time to Read The Fantastic Manual. The one at http://docs.oracle.com
(follow the link to your version of the dtabase, then to 'View Library',
'List Books' and SQL*Plus Reference Manual or SQLPlus Quick Reference
Guide.)

Your requirements are resolved by a combination of setting column size,
column format and line width, and I simply can not tell you the right
values. Look up the syntax for SET LINEWIDTH and COLUMN

/Hans
Jul 19 '05 #2

P: n/a
Respected Sir,
Thanks for your guidance.I opened Sqlplus window then
Options -> Environment -> LineSize
Set to custom and put the value 1000.
Now it is showing perfectly.
Regards
Arijit Chatterjee
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.