Avatar of RUA Volunteer2?
RUA Volunteer2?
Flag for United States of America asked on

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.
Oracle Database* PL/SQLSQL

Avatar of undefined
Last Comment
RUA Volunteer2?

8/22/2022 - Mon
PortletPaul

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.)
RUA Volunteer2?

ASKER
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?
SOLUTION
PortletPaul

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
RUA Volunteer2?

ASKER
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.
Just trying to make sense of it all.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!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
RUA Volunteer2?

ASKER
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.
RUA Volunteer2?

ASKER
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. Color Settings in Preferences
PortletPaul

:) happy days
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
slightwv (䄆 Netminder)

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.
RUA Volunteer2?

ASKER
Now that is a cool tool. When something is published I would imagine I can turn off the color scheme as to not bother the next guy who probably will know this stuff like the back of his hand and will not want a color anywhere. I will make note never to do that.