ORA-00911: invalid character with special characters in table columns

[Bernhard S]

Hello,

when I have a table that contains special characters in the table column names, pl/sql-developer doesn't put those column names in between double quotes. When you take the SQL generated by pl-sql-developer via right-click on table - view - view sql
out of a table with columns like:
A? VARCHAR2(2) Y
pl-sql-developer takes over those colum names without without quoting in the create table ... ( :
A? VARCHAR2(2),
...
Consequently when trying to execute this generated create table DDL, if fails with: ORA-00911: invalid character
pl-sql-developer should put those columns in double quote like:
"A?" VARCHAR2(2),

Thanx for fixing that.

BTW: Is there any way here in the forum that a sequence of blanks doesn't get transformed into just one blank, messing up all formating that way?

 

[rbrooker]

pssst....

use a [ CODE] [ /CODE] block. this maintains spacing. (remove the spaces after the "[" )

eg.

this     is
     spaced in
  an     oddly
 asthetic
                      manner :)