c# 中一句查询语句，带了特殊字符该怎么写？

[yypandxzz]

string sql ="select timer as 时间,fw as 风温, top_t11 as 1#顶温1,top_t12 as 1#顶温2 from HIS_DATA_RFL_FW ";
//这样写 语法没报错 但是 在oracle 数据库中会报错 原因应该是重命名后带有特殊字符
在ORACLE 中 select timer as 时间,fw as 风温, top_t11 as "1#顶温1",top_t12 as "1#顶温2" from HIS_DATA_RFL_FW
是可以重命名并查询成功
但是C#中这样
string sql ="select timer as 时间,fw as 风温, top_t11 as "1#顶温1",top_t12 as "1#顶温2" from HIS_DATA_RFL_FW ";
不行，谁能帮忙解决下 谢谢了

[於黾]

不要乱加双引号,都去掉

[於黾]

或者这样: string sql ="select timer as 时间,fw as 风温, top_t11 as \"1#顶温1\",top_t12 as \"1#顶温2\" from HIS_DATA_RFL_FW "; 双引号需要转义

[yypandxzz]

谢谢，可以了，百度了好久都没找到答案，大神一下就解决了

[tcmakebest]

双引号不知道转义, 这不是SQL的问题,这是C#基础太差.

[yypandxzz]

半道出家 呵呵

[娃都会打酱油了]

用单引号，不要用双引号