DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: displaying CLS with column heading

  1. #1
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    Question displaying CLS with column heading

    What is the reason behind displaying CLS with column heading.
    How can i remove this.

    SQL> select * from school;
    clsSID CID SNAME SMARKS
    ---- ---- ---------- ----------
    S001 c001 Amit 80
    S002 c001 vishal 81
    S003 c001 surabhi 91
    S004 c002 deepti 78
    S005 c003 vijay 75
    S006 c003 rahul 85

    Thanks in Advance.
    ~KD.DBA~

  2. #2
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    if any answer pls reply
    ~KD.DBA~

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Rename column?

    select clsSID SID, .... ?

    Not really sure what you mean. Please elaborate.
    Assistance is Futile...

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by waitecj
    Rename column?

    select clsSID SID, .... ?

    Not really sure what you mean. Please elaborate.
    Yes when ever I fire any query, it always displays cls with first column heading. like if i fire "select * from school" the result i will get is:

    clsSID sname Smarks

    column name is only SID not clsSID.

    The result(Column Headings) should be like :
    SID SNAME SMARKS
    ~KD.DBA~

  5. #5
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Can you try doing select * from dual and paste the output here..

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    anything in your login.sql?

  7. #7
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Anything in your glogin.sql?
    Able was I ere I saw Elba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width