troubleshooting Question

Understanding the different Color usage defining and highlighting the syntax code in PL/SQL.

Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America asked on
Oracle Database* PL/SQLSQL
11 Comments3 Solutions188 ViewsLast Modified:
Trying to understand the Colors defining the syntax code in PL SQL. Does it highlight syntax in a way consistent with other SQL developers in the industry.
I would assume like other tools terms are similar. Like Functions are relatively consistent across the board SUM(Fields), AVG(Field) as are Operators ((+,-,=,/,*..etc)
I have used the word Color in the Help file and literally read every line of text that has the word 'COLOR' in it or the word 'RED' etc that has something to do with the syntax and only found one that said ...

Syntax Highlighting
This group of preferences control the syntax highlighting that is used in the editors. You can enable or
disable syntax highlighting, and define the style and color of keywords, comment, strings, numbers and
symbols (:=, =>, ||, and so on). For keywords you can additionally control if they should be converted to
uppercase, lowercase or capitalized. You can also define a custom syntax highlighting, and define the
words that should be highlighted. Pressing the Custom Keywords button will bring up an editor that
allows you to define these words.
The Keyword Case preferences controls how keywords are formatted when they are typed: Uppercase,
Lowercase or Init Caps.

I do know that Red identifies Removed and used as identifying comments not read by the Developer Tool obviously.

Is there a color code or color schema available for PL SQL? I have googled and looked at Help with nothing on the colors of the syntax in PL SQL. Your thoughts appreciated.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros