Bernhard S
Member³
Sometimes it happens that you just miss a comma in a list of selected columns and oracle automatically makes the second column an alias for the frist column then like in:
Especially in command window that gets used to create a lengthy view, it's hard to find such problems. So in such cases it would help a lot if PL/SQL Developer could just highlight column names and their aliases differently. So the previous example would then look something like this:
select col1 col2, col3 from my_table;
This way you can right away see, that col2 is just and alias. It should be possible to change the syntax highlighting in preferences. This functionality should be implemented wherever it's easily possible to skip commas and involuntarily create aliases that way.
SQL:
select col1 col2, col3 from my_table;Especially in command window that gets used to create a lengthy view, it's hard to find such problems. So in such cases it would help a lot if PL/SQL Developer could just highlight column names and their aliases differently. So the previous example would then look something like this:
select col1 col2, col3 from my_table;
This way you can right away see, that col2 is just and alias. It should be possible to change the syntax highlighting in preferences. This functionality should be implemented wherever it's easily possible to skip commas and involuntarily create aliases that way.
