-
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~
-
-
Rename column?
select clsSID SID, .... ?
Not really sure what you mean. Please elaborate.
Assistance is Futile...
-
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~
-
Can you try doing select * from dual and paste the output here..
-
anything in your login.sql?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|