Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
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!
A quick Google returned:
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
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
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day 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. 
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.
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
(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.)