如何替换sql语句的斜线?
时间:2011-01-11 来源:wmlm
sqlplus change /
如何替换sql语句的斜线?
SQL> select sysdate/ from dual;
select sysdate/ from dual
*
ERROR at line 1:
ORA-00936: missing expression
SQL> l
1* select sysdate/ from dual
SQL>
SQL>
SQL> c'/' as "now"
1* select sysdate as "now" from dual
3* WHERE JOB_ID IS IN ('CLERK', 'SA_MAN')
Enter the following command:
CHANGE /CLERK/SH_CLERK/ The text in the buffer changes as follows:
3* WHERE JOB_ID IN ('SH_CLERK', 'SA_MAN') Or enter the following command:
CHANGE /'CLERK',... /'SH_CLERK'/
引用自
SQL*Plus User's Guide and Reference
Release 9.2
Part Number A90842-01
相关阅读 更多 +