Sql output problem in SQLPLUS....

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 27 Jun 2004 21:29:11 -0700
Message-ID: <ea01504d.0406272029.17420332_at_posting.google.com>

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 Received on Mon Jun 28 2004 - 06:29:11 CEST