PL⼀SQL中的斜杠 ⼀

2025-05-08 20:19:43
推荐回答(4个)
回答1:

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;

回答2:

双引号

如:
select sysdate as "a/" from dual ;

回答3:

用 escape '/'转义

回答4:

试试\/