Link to home
Start Free TrialLog in
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.
Avatar of PortletPaul
PortletPaul
Flag of Australia image

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.)
Avatar of 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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
User generated imageIt 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!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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. User generated image
:) happy days
Avatar of slightwv (䄆 Netminder)
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.
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.