Using "$" in Oracle queries being run from C#
I want to run an Oracle query which is somewhat like:
SELE开发者_Go百科CT *
FROM v$sql
WHERE ......
But when I use "v$sql" in C#, I am getting an error "Invalid character".
When I remove that part of the query and replace it with some other table name, it is running fine.
I'm not familiar with C# but try putting v$sql in double quotes: "V$SQL"
Double quotes makes Oracle case sensitive so it needs to be uppercase.
Or try a synonym:
create synonym my_v_sql for sys.V_$SQL;
or
create public synonym my_v_sql for sys.V_$SQL;
精彩评论