[20230323]sqlplus #.txt

--//缺省如果sqlplus前面加入# 并不是注解，可以通过执行如下命令关闭,set sqlprefix off

1.环境：
SCOTT@test01p> @ver1

PORT_STRING VERSION BANNER CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0 12.2.0.1.0 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0

2.测试：
SCOTT@test01p> show sqlprefix
sqlprefix "#" (hex 23)

SCOTT@test01p> #select sysdate from dual;
SYSDATE
-------------------
2023-03-23 20:46:52

SCOTT@test01p> set sqlprefix off
SCOTT@test01p> #select sysdate from dual;
SP2-0734: unknown command beginning "#select sy..." - rest of line ignored.

SCOTT@test01p> set sqlprefix +
SCOTT@test01p> +select sysdate from dual;
SYSDATE
-------------------
2023-03-23 20:48:22

ITPub博客

[20230323]sqlplus #.txt

最新文章