Adding ROWID to fields in code assistant

[Hans Erik Busk]

It would be nice if ROWID would show in code assistant together with the regular column names.

 

[BWendling]

then ROWNUM must be included, too. And maybe some other 25 internal variables, such as NULL...

I don't know, whether this will be helpful or merely distracting from the actual column names.

 

[Hans Erik Busk]

The ROWID is a special case as it is necessary for updating a row.
Yes, I know that you can select "edit table" in the object browser, but sometimes I want to update a table after having written a query,with a couple of lookup-tables. It would be convenient just type "a." and let the code assistant - well - assist you.

 

[BWendling]

Maybe in your case, you could define a shortcut key combination.

There is an add-on PL/Shortcuts:
http://www.allroundautomations.com/plsqldevaddons.html

 

[Marco Kalter]

We'll consider a rowid and rownum option for the Code Assistant. I have added this to the list of enhancement requests.

 

[BWendling]

I just want to make clear that I DON'T need or want a "rownum" option.

With my post, I wanted to show that starting to include a "rowid option", this will lead to more and more "obviously necessary" additions of all sort of Oracle internal variables, which makes PLSD code base only bigger but not more useful.

Next week, someone will probably suggest to include all SQL functions in the column list, too.

In case somebody wants to use a function.

 

[Marco Kalter]

When I said "Option" I meant "Preference". I can imagine that some might not want to see these pseudo columns.