Printable View
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.
if any answer pls reply
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:Quote:
Originally Posted by waitecj
clsSID sname Smarks
column name is only SID not clsSID.
The result(Column Headings) should be like :
SID SNAME SMARKS
Can you try doing select * from dual and paste the output here..
anything in your login.sql?
Anything in your glogin.sql?