Hello,
Please notice, there is a problem in Code Assistant when trying to select columns like "AV Total CPU Time %" from table as below.
CREATE TABLE t_table
(
"AV Total CPU Time %" number,
"SM Total CPU Time %" number,
"MN Total CPU Time %" number
)
The column name with spaces should be inside quotation-marks (").
Statement produced by CA:
select t.av total cpu time % from t_table t
Statement should be produced to run well:
select t."AV Total CPU Time %" from t_table t
There is in CA another problem too, the column name string should be in orginal case, if not there is "ORA-00911: Invalid character" error
The option "Use orginal case if possible" in CA preferences didn't work for me .
Regards,
ToRo
Please notice, there is a problem in Code Assistant when trying to select columns like "AV Total CPU Time %" from table as below.
CREATE TABLE t_table
(
"AV Total CPU Time %" number,
"SM Total CPU Time %" number,
"MN Total CPU Time %" number
)
The column name with spaces should be inside quotation-marks (").
Statement produced by CA:
select t.av total cpu time % from t_table t
Statement should be produced to run well:
select t."AV Total CPU Time %" from t_table t
There is in CA another problem too, the column name string should be in orginal case, if not there is "ORA-00911: Invalid character" error
The option "Use orginal case if possible" in CA preferences didn't work for me
.Regards,
ToRo
