Describe Popup

[Patrick Wolf]

Hi,

when I do a describe for a table/view, eg ALL_USERS the column names are displayed in uppercase, when I double click a name it is copied to the editor, but the name is in lowercase. Why? Is there somewhere a setting?

I also have a simular problem with a variable which is of type %ROWTYPE, when I use the code assistent to select a column if will be returned init cap.

Thanks
Patrick

 

[Marco Kalter]

For the decribe window there is no setting. It simply inserts the name in lowercase.

For the Code Assistant there are various options. See Tools > Preferences > Code Assistant > Coding Style.

 

[Patrick Wolf]

Hi,

i'm still a little bit confused with the correct settings for the Code Assistant.

What do I want? Table/View and column names should be returned in uppercase when selected thru the code assistant.

Based on the help file I have set the code style to "Smart" and Use original case if possible.

To my understanding table/view/column names should now be returned in uppercase because as the help mentioned the oracle dictionary tables are used and there the values are uppercase.

But the code assistant behaves event more irritating.

If I have two %ROWTYPE variables, one for a table and one for a view of the same table. For the view variable code assistant returns the column in lowercase for the table variable the column name is returned in init cap!

If I change the code style setting to "Uppercase" then for the view variable lowercase is returned!!! And for the table variable the column name is now returned in uppercase.

I don't know why the code style is even used, because I have turned the "Use original case if possible" on and all the information is in the dictionary...