文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>如何替换sql语句的斜线?

如何替换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
相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载