Queries in data model of report [message #327700] |
Tue, 17 June 2008 05:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandipshahare
Messages: 21 Registered: March 2008 Location: Pune
|
Junior Member |
|
|
Hi,
I am using report 10g builder.
I am copying the select statements from 1 instance of data model to another then the column alias are changed with extension'_'.
I am not able to edit the field name.
Is it possible to change the name?
Please see the attachment for more details.
-
Attachment: report.jpg
(Size: 35.25KB, Downloaded 747 times)
|
|
|
Re: Queries in data model of report [message #327718 is a reply to message #327700] |
Tue, 17 June 2008 06:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
As two fields can not have the same name, you'll have to open Q12 query and - if you don't like suggested aliases - rewrite the SELECT statement in order to modify field names as you wish. For example, if it wasthat made field names look like "id_" and "name_", modify the query to SELECT id customer_id, name customer_name
FROM ...
If you wanted to change field name in Data Model Editor "directly" (by overtyping the old name), I'm quite sure that you can't do that.
|
|
|