REPORT COLUMN NAME CHANGING [message #391177] |
Wed, 11 March 2009 06:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
AAKHEEB
Messages: 9 Registered: June 2004
|
Junior Member |
|
|
hi,
i designed report with following query
select empno,fname from emp and its fine.
i changed the query to
select empno,substr(fname,1,3) fname from emp;
in result column names all in my report changed to
empno1 ,fname1 instead of empno,fname
every time i am channging query its keep changing the name
to empno2,empno3......and so.
how to avoid this i hardcoded this column name so many places in this report.
Any body help me .
|
|
|
Re: REPORT COLUMN NAME CHANGING [message #391200 is a reply to message #391177] |
Wed, 11 March 2009 07:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, it is annoying ... and I don't have a smart way to solve it.
However, I can tell you what I do: in the first step, I rename (i.e. create column aliases), such asselect empno my_empno, substr(fname,1,3) my_fname from emp which eliminates "empno1" and "fname1" labels. Next step is to name them as they should be named:select empno, substr(fname,1,3) fname from emp
Sorry for not being able to help you any better.
|
|
|
|