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