In Reports Developer, if you have 2 queries with similar columns selected and you don't name them differently Oracle developer with automatically append a 1, or 2, etc at the end of the name.
Is there any option to turn this feature off? Its causing problems because when the name is referenced in program units, if the query is modified , it will change the column names from name1 to name2 and back to name1 , everytime you make a modification.
Is there a way to get it to stop doing this? Once the name is set at Name1 what's the purpose of changing it to Name2 and then back to Name1 again.
The reason why I believe there is an option somewhere to turn this off, is because this is happening on some machines, and not happening on others. So it must be a setting that some have turned on and some have turned off.
thanks