Sql output problem in SQLPLUS....

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Arijit Chatterjee
    #1

    Sql output problem in SQLPLUS....

    Dear All,
    I am faceing a problem in sql output in SQLPLUS screen.I am explaining
    the details..
    =============== =============== =============== =============== ==========
    SQLdesc 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)
    =============== =============== =============== =============== ==============
    SQLselect * 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
    Tags: None
    • Hans Forbrich
      #2
      Re: Sql output problem in SQLPLUS....

      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

        Comment

        • Arijit Chatterjee
          #3
          Re: Sql output problem in SQLPLUS....

          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

            Comment

            Previous template Next
            Working...