Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
Understanding the different Color usage defining and highlighting the syntax code in PL/SQL.
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.
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.
Who is Participating?
What product are you using to highlight the code?
(PL/SQL can be executed through a command line supplied by the operating system, so even those command windows are dependent on which operating system you are using.)
(PL/SQL can be executed through a command line supplied by the operating system, so even those command windows are dependent on which operating system you are using.)
I am not highlighting it. PL/SQL gives the code its own color scheme. I am trying to figure out how it identifies what each color identifies and for some reason cannot find it?
Fletcher, what product is it that you are using that displays the code?
e.g.
"Oracle SQL Developer"
example image
PL/SQL by itself has no colours at all
e.g.
"Oracle SQL Developer"
example image
PL/SQL by itself has no colours at all
PL/SQL is Oracle's Procedural programming language.
I'm assuming you mean PLSQL Deveoper? https://www.allroundautomations.com/plsqldev.html
I'm assuming you mean PLSQL Deveoper? https://www.allroundautomations.com/plsqldev.html
You are correct I am wrong. It is the 'PL/SQL Developer' that has the colors. I did not understand the difference. When a tool starts off like that it can be confusing to the novice I guess.
It is the PL/SQL Developer that has the colors. I am trying to understand as there are 4 distinct colors here below in the picture. a
1. Teal
2. Royal Blue
3. Navy Blue
4. Red
I am just wondering if there are some kind of color scheme or color coding happening there to identify things. If that is a universal color scheme found in many of the SQL tools etc. I thought this would be so easy to find in their help documents. Well I seached for the word color and each of the colors above. Shocked they do not identify that. Hell they even have that for flowers. red means love pink means friendship, white is for purity and yellow is just for Texas. I am surprised I cannot find what those mean??? BOING!
It is the PL/SQL Developer that has the colors. I am trying to understand as there are 4 distinct colors here below in the picture. a1. Teal
2. Royal Blue
3. Navy Blue
4. Red
I am just wondering if there are some kind of color scheme or color coding happening there to identify things. If that is a universal color scheme found in many of the SQL tools etc. I thought this would be so easy to find in their help documents. Well I seached for the word color and each of the colors above. Shocked they do not identify that. Hell they even have that for flowers. red means love pink means friendship, white is for purity and yellow is just for Texas. I am surprised I cannot find what those mean??? BOING!
Sorry for the obvious confusion. I feel a bit ignorant but that is not a new feeling. I'll keep dealing with that if you guys can help keep dealing with me? Much appreciated as always.
Cool Looks Like for someone like Me I could even go in and identify other functions and operators with a unique color. Very helpful to someone like myself who benefits from identifying color concepts. 
Any editor worth a crap allows for complete customization.
>>someone like Me I could even go in and identify other functions and operators
I use GVim on Windows as my main editor and vim at work. I have my own custom color setup I like and keep copying around with me.
Colors are a very personal thing and should NEVER be forced upon you. It is also a usability issue for the colorblind and visual impaired.
>>someone like Me I could even go in and identify other functions and operators
I use GVim on Windows as my main editor and vim at work. I have my own custom color setup I like and keep copying around with me.
Colors are a very personal thing and should NEVER be forced upon you. It is also a usability issue for the colorblind and visual impaired.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=56720
Then I found this:
http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=45956
See what options are available under: Tools --> Preferences --> Appearance tab