Modify Intellisense entries?

[Leigh Kendall]

Is there a way to modify intellisense entries?

Specifically, I'd like to remove the varchar entry since I _never_ use it. It's a bit of a pain to have to hit the down arrow key to get the varchar2 selection.

A bit off topic, but what would be VERY cool, is if you implemented "smart" selections, so I could just type v2 and it would automatically select it. An MS add-in by www.wholetomato.com does this to make selecting intellisense choices much faster. Check it out!...

Anyhow, if smart selections to reduce the list isn't possible, being able to modify the entries would be nice.

Please advise... thanks,

 

[Marco Kalter]

This is currently not possible. I have added this to the list of enhancement requests.

 

[Robert_G]

Specifically, I'd like to remove the varchar entry since I _never_ use it. It's a bit of a pain to have to hit the down arrow key to get the varchar2 selection.

Completely OT, but why in hell would someone want to do such a thing?
varchar2 definitely is an ugly type name, also it is completely incompatible with every other DBMS *and* it is useless as it is only a synonym to the real varchar. I don't get it, really...
It's more a big PITA that PL/SQL Dev will use this dump synonym everywhere as the default type.
Why would I want to create a table with a column of type varchar2?

 

[Marco van der Linden]

From the Oracle Documentation:

VARCHAR Datatype
The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes in behavior, always use the VARCHAR2 datatype to store variable-length character strings.

see the "always"? Yep, sounds pretty useless to me

 

[Stew Stryker]

Oh great! A religious war over VARCHAR vs VARCHAR2!

Robert, not that it matters in hypothetical discussions like this, but I suspect you part of a very small minority that uses VARCHAR instead of VARCHAR2.

From "Oracle PL/SQL Programming", 4th edition, by Steve Feuerstein:

"We agree with Oracle's recommendation. "If there's a possibility of VARCHAR's being changed, it's senseless to depend on it's current behavior. Don't use VARCHAR; use VARCHAR2." [emphasis added]

 

[Marco van der Linden]

@Leigh

On a more helpful note: Try the Short Cuts Plug-In by Tiger, that'll let you define v2 to be replaced by the 'dreaded' varchar2

 

[Leigh Kendall]

Thanks Marco -

I'll check out the Tiger plug-in. Sound like what I'm looking for and would be very useful!

Haven't looked much at the plug-ins lately, will have to check out the others as well.

Thanks again!