syntax highlighting

[Mihovil Pupovac]

Is there a way to highlight all table or view names in my plsql code?

/Thanks

 

[Marco Kalter]

If you download and install the Customized Syntax Highlighting Plug-In , you can define your own custom keywords, based on a query. A query that returns all table and view names is easily created.

 

[Mihovil Pupovac]

Oh, thanks, it worked perfectly. But it still won't highlight tables that are nested inside strings...do you have any idea how to override this?

 

[Marco Kalter]

No, I don't think this is possible. A string is always highlighted as a string, regarless of the string contents.

 

[Mihovil Pupovac]

I tried to turn off highlighting for strings and it still doesn't work. Is there a way to completely turn off string highlighting, like in some configuration file or something?

 

[Marco van der Linden]

@Mihovil

Menu: Tools/Preferences/User Interface/Editor
Under 'Syntax Highlighting' uncheck 'Strings' works for me

 

[Mihovil Pupovac]

In my case it doesn't work. Altough i did exactly the same thing as you, seems that i cannot make my customized highlighting appear nested inside strings. Note that i'm using the Customized Syntax Highlighting Plug-In and the version of pl-sql developer is 7.0.0.1050.

 

[Marco van der Linden]

@Mihovil
A string is just that, a string. Within a string neither PL/SQL Developer nor Oracle itself will recognize database objects. E.g. select table_name from all tables will be highlighted according to your settings, but if you were to use something like execute immediate 'select table_name from all_tables' then only 'execute immediate' will be highlighted as keywords. The select statement will be treated just as a string

 

[RobertK]

I want ONLY the words : FUNCTION, PROCEDURE
to have say a backbround color - "Custom Keywords" does not seem to work in this case....
Is there a way to do this ?

thanks

 

[RobertK]

hello ?

 

[Marco Kalter]

Works fine in 7.1, but in 6.0 you need to remove the function and procedure keywords from the plsql.kwf, sql.kwf and command.kwf files.

 

[RobertK]

got it, thanks Marco