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

Arijit Chatterjee wrote:

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

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