scott@orcl>create view "/test"("/ename") as select ename from emp;
视图已创建。
select "/ename" from "/test";
在plsql块中也是如此:
begin
execute immediate 'create view test("/ename") as select ename from scott.emp';
end;
双引号
如:
select sysdate as "a/" from dual ;
用 escape '/'转义
试试\/